Comments on: 5 Minute DBA MyISAM Example Config Files

By: MyISAM with key_buffer larger than 4 GB » Big DBA Head!

MyISAM with key_buffer larger than 4 GB » Big DBA Head! — Thu, 11 Jun 2009 16:20:05 +0000

[...] 5 Minute DBA MyISAM Example Config Files [...]

By: Matthew Yonkovit

Matthew Yonkovit — Thu, 11 Jun 2009 15:29:31 +0000

Erkules,

Thanks… shows you how much I work with MyISAM now days. Learn something new all the time.

By: Mark R

Mark R — Thu, 11 Jun 2009 15:18:31 +0000

In my opinion, you should not run MySQL on a 32-bit system. It’s just too risky. Running out of address space causes the process to quit, leaving many MyISAM tables in need of repair.

Also you’ve not put in max_connections, which is vital to ensure it won’t run out of address space.

I’d say no new significant sized installation should be done on a 32-bit box, and existing ones should be migrated as soon as convenient (of course there’s a lot of QA work associated with that)

By: erkules

erkules — Thu, 11 Jun 2009 15:14:44 +0000

key_buffer_size: As of MySQL 5.0.52, values larger than 4GB are allowed for 64-bit platforms
(http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_key_buffer_size)
Works here:)