On Wed, 17 Jun 2009, Johan De Meersman wrote:
Aren't those options defined in megabytes ?
On Tue, Jun 16, 2009 at 4:59 PM, Thomas Spahni <t...@lawbiz.ch> wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk
on any
table I get the following warnings:
Warning: option 'key_buffer_size': unsigned value
18446744073709551615 adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned value
18446744073709551615 adjusted to 4294967295
Warning: option 'write_buffer_size': unsigned value
18446744073709551615 adjusted to 4294967295
Warning: option 'sort_buffer_size': unsigned value
18446744073709551615 adjusted to 4294967295
/etc/my.cnf contains the following:
[myisamchk]
key_buffer_size=20971520
sort_buffer_size=20971520
read_buffer_size=2097152
write_buffer_size=2097152
What's wrong here?
Thomas Spahni
Hi again
According to the very fine Manual
<http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html> the
values can be given as Bytes or with a suffix of K|M|G. This didn't change
anything in my case.
It's strange that I see a similar error from mysqld when I run make test.
It says:
CURRENT_TEST: alias
090617 12:44:21 [Warning] option 'max_join_size': unsigned value
18446744073709551615 adjusted to 4294967295
Something must be very wrong here.
Regards, Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org