Hi taron,

There are a number of factors involved in determining the optimal MySQL memory settings.

For a quick guide, though, I'd recommend checking out the MySQL tuning primer script:

https://launchpad.net/mysql-tuning-primer

Regards,

Jankball

If the only thing this system does is run MySQL, you probably want to start with my-large.cnf (/usr/share/doc/mysql-server-5.0/examples/my-huge.cnf.gz or some similar directory)

While I haven't worked on a very high load site in some time, I find that generally I get good enough performance by picking the appropriate pre-fab mysql config file, so I spend my time elsewhere.