Replication slave interrupted by "DROP /*!40005 TEMPORARY*/ TABLE ..."

2004-02-11 Thread Oscar Yen
t support under mysql 4.0.12, we have to create temporary tables :< ); I suspect that mysql will drop the temporary tables automatically when associated connection dropped unexpectedly, am I right? Has anybody encountered similar situation, and how he resolved the problem? Thanx Oscar Yen

Strange slow queries

2004-02-11 Thread Oscar Yen
a and b, the result is similar. Thanks you for your attention. Oscar Yen.

Similar simple query slow down dramatically, by just select one more field, why?

2004-02-18 Thread Oscar Yen
N¬™ë,j°jËkj{zºÞw­…«k‰©oz»"¢z ‰¦ºx†j×­˜úèDear all, I have asked the question days before, but no one seems interested in it Considering table imgstore, defined as create table a ( imgid int not null, parent int, imgtype char(3), img longtext, primary key (imgid), key searchke

Re: Similar simple query slow down dramatically, by just select one more field, why?

2004-02-18 Thread Oscar Yen
N¬™ë,j°jËkj{zºÞw­…«k‰©oz»"¢z ‰¦ºx†j×­˜úèThanks for reply. - Original Message - From: "Ludwig Pummer" <[EMAIL PROTECTED]> To: "Oscar Yen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 8:39 AM Subject: Re: Simi