Craig, this is the right place, but performance is a pretty broad topic.
I personally highly recommend Jeremy Zawodny's book, 'High Performance
MySQL'. It's based on 4.1, so the info will be well suited to your
install (I don't know if it will be updated for 5 ... anyone?).
You can also glean quite a bit of useful info from the docs on
optimization, at:
http://dev.mysql.com/doc/refman/4.1/en/optimization.html
As a first stab, you might evaluate which of MySQL's included 'my.cnf'
files fits your situation (read comments in file), and implement that
(backing up your current file first just in case).
Good luck,
Dan
Cx Cx wrote:
Hi All,
Hope this is the right list to post to, excuse if it is not ;-)
Server scenario:
Dedicated server running MySQL 4 and secondary process inserting data into
MySQL
How does one calculate what the values should be for the following areas in
the my.cfg file to give optimal performance:
- Key Buffer Size
- Maximum Packet Size
- Sort Buffer Size
- Network Buffer Size
- MyISAM Sort Buffer Size
- Tables to Cache
- etc
Basically anything that can be tweaked to enhance the servers perfomance.
Thanks In Advance
Craig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
