On October 11th, 2007 James Day (not verified) says:
Did you at least use one of the default configuration files from the list at dev.mysql.com ? MySQL's defaults with no configuration file have historically been for systems with minimal RAM, so no configuration file at all cripples it if you're after anything more than serving a few pages on a desktop PC.
key_buffer_size is the cache size for the MyISAM index pages, MyISAM data rows come from OS cache. 20% of the RAM available for the database is a fair initial setting.
The Windows installer does do some basic tuning but *nix people are expected to look over the instructions and do some basic setup themselves.
PostgreSQL people would probably be unhappy that you were using MyISAM instead of InnoDB but the bare defaults for MyISAM are so inappropriate for high use that it's not really important.
MySQL defaults, not a recommended initial config file?
Did you at least use one of the default configuration files from the list at dev.mysql.com ? MySQL's defaults with no configuration file have historically been for systems with minimal RAM, so no configuration file at all cripples it if you're after anything more than serving a few pages on a desktop PC.
key_buffer_size is the cache size for the MyISAM index pages, MyISAM data rows come from OS cache. 20% of the RAM available for the database is a fair initial setting.
The Windows installer does do some basic tuning but *nix people are expected to look over the instructions and do some basic setup themselves.
PostgreSQL people would probably be unhappy that you were using MyISAM instead of InnoDB but the bare defaults for MyISAM are so inappropriate for high use that it's not really important.