Re: Database Performance Tweaking

2006-06-07 Thread Dan Buettner
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 glea

Database Performance Tweaking

2006-06-06 Thread Cx Cx
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: