On Friday 22 October 2004 11:10, Mechain Marc wrote:
> If you don't want to have those error messages:
>
> Increase the value of "Open File" using ulimit shell command.
>
> Do a ulimit -a to see the current value
> Do a ulimit -n newvalue to increase it
>
> You can also modify the /etc/limits file
hard Bennett [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 22 octobre 2004 00:48
À : [EMAIL PROTECTED]
Objet : Re: mysql optimizing large table
Hi,
On Thursday 21 October 2004 22:00, Dathan Vance Pattishall wrote:
> My.cnf.huge is not good enough for your system specs. Calculate the Key
>
Hi,
On Thursday 21 October 2004 22:00, Dathan Vance Pattishall wrote:
> My.cnf.huge is not good enough for your system specs. Calculate the Key
> efficiency from the show status command. I bet the key efficiency is less
> then 90% or so.
By my count it is 99.88, the status output is:
Key_blocks_u
My.cnf.huge is not good enough for your system specs. Calculate the Key
efficiency from the show status command. I bet the key efficiency is less
then 90% or so. In this case increase the key_buffer_size try 512M. A good
stat for a proper key_buffer_size in the sum of all index files block size.
Th