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