Hi!

>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:

Sinisa> Fournier Jocelyn [Presence-PC] writes:
>> Hi,
>> 
>> I noticed an annoying behaviour with MySQL 4.0.0.
>> I have 11 tables with a lot of rows (about 1 Million and more) which are constantly 
>updated by a php script.
>> It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart, 
>some tables are corrupted (and not the same, it randomly occurs), and I have to run a 
>myisamchk to repair them.
>> 
>> Here is the structure of the table :
>> 
>> 
>> CREATE TABLE searchhardwarefr9 (
>> mot varchar(30) NOT NULL,
>> topic mediumint(8) unsigned DEFAULT '0' NOT NULL,
>> date date DEFAULT '0000-00-00' NOT NULL,
>> pseudo varchar(35) NOT NULL,
>> numreponse int(10) unsigned DEFAULT '0' NOT NULL,
>> PRIMARY KEY (mot, pseudo, date, numreponse, topic),
>> KEY pseudo (pseudo, date, numreponse, topic),
>> KEY numreponse (numreponse, topic),
>> KEY topic (topic)
>> );

<cut>

Apart from the new key-cache code and batch insert code, the MyISAM
code is identical in MySQL 3.23 and 4.0

Could you try to follow the instruction at

http://www.mysql.com/doc/R/e/Reproduceable_test_case.html

to try to make a test case of this?

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to