Hi,
can someone clarify the myisamchk -R (to re-sort the table) parameters for
me..
$ myisamchk -R shop_registration
The value of the sort key is bigger than max key: 32.
$ myisamchk -R shop_registration -O sort_key=31M
The value of the sort key is bigger than max key: 32.
I have tried several combinations or the following parameters, but cannot
get it quite right
Possible variables for option --set-variable (-O) are:
key_buffer_size current value: 134213632
read_buffer_size current value: 2097144
write_buffer_size current value: 2097144
sort_buffer_size current value: 134217720
sort_key_blocks current value: 16
decode_bits current value: 9
thanks
Andy
---------------------------------------------------------------------
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