Re: myisamchk buffer_size warnings
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
Open Source Database Magazine
hello everyone, Many of you know I have been the editor of MySQL Magazine for the last two years. Beginning with the summer issue I will be making some pretty major changes. The magazine is being renamed Open Source Database Magazine and I am going to be attempting to steer the subject matter to include any open source db. The details are here: http://www.paragon-cs.com/wordpress/2009/06/16/mysql-magazine-is-dead-long-live-open-source-database-magazine/ This does not mean that MySQL will be forgotten. Quite the opposite, I expect that there will be more articles about MySQL Server than any other database if for no other reason than there are more installations of MySQL than any other OS db. So step up to the plate! Send me a proposal for an article for the next issue which will come out in mid-July. Looking forward to hearing from you. thanks, Keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Duplicate key name when importing mysql dump file
Hi, I'm trying to import a dumpfile like so: cat aac.sql | mysql -u root AAC It all runs fine until I get something like: ERROR 1061 (42000) at line 5671: Duplicate key name 'FK_mediaZip_to_zipSet' Is there a way I can tell it to ignore or replace the key? Thanks, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org