many thanks brothers
Now, my query fastest again with limit 1, because query count(*) just result
1 row
=-hery-=
- Original Message -
From: "BD" <[EMAIL PROTECTED]>
To: "Hery Yulianto" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, Febru
#x27;',
`FIELD_3` varchar(150) default NULL '',
PRIMARY KEY (`FIELD_1`,'`FIELD_2`),
KEY `FIELD_1` (`FIELD_1`),
) TYPE=MyISAM PACK_KEYS=1
but, why still long time to got the result from this query : select
count(*) from TABLE_1 where FIELD_1 =
but, i do query sintax, just simple select count(*) from TABLE_1 where
FIELD_1 = "XXX_CC";
But i got the result very long timemore 10 minutes
I used Sun Solarys with 2 Gygabyte RAM.
What wrong with my strusture database...
thank's for your answer, i with you always f
my solution for this problem
1. Please you look status salve on the mysql with syntax mysql> show slave
status
2. After that, please you look Log_File on column, what a name file ?
3. Please you open your shell this file with mysqlbinlog "file_name" | more
4. please you find the position (246
Hi Brothers or Sisters,
I need to know, how to configure MySQL can be support unicode like Chinese
(simplified and Traditional), Croation,Chezh or whatever.
I using PHP programming and needed can transaction with Chinese character.
Thank you for explain to me
Best Regard,
Hery
--
Hi All,
I need to know, how to configure MySQL can be support unicode like Chinese
(simplified and Traditional), Croation,Chezh or whatever.
Thank you for explain to me
Best Regard,
Hery Yulianto
-
Before posting, please
Hello brother or sister
I have a problem with replication on MySQL.
I used MySQL version 3.23.38.
But why i cant connect to master from slave but i had a this problem.
Below, message on the log from slave.
I need you all help me, what i can do this.
for information i must change max_allowed_p