Re: mysql error and sometimes crash the table
Hey
Not sure, if it will help, but use the Default key buffer size.
Yours is really high for Caching. - Maybe your just run out of buffer size!?
The "normal" KeyBufferSize = 256k!
But try out with for example:5M
You can use the "M" word for Megabyte and "G" would be Gigabyte. - But decrease your size!
Key Buffer size is realted to myISAM Tables. - What you could do as well is to Change to INNODB. - It is the much safer way (even for "production" Servers)
Have a nice weekend
Subject
Written By
Posted
Re: mysql error and sometimes crash the table
August 17, 2013 06:12AM
September 02, 2013 01:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.