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

Reply via email to