MySQL tuning advice

2006-09-12 Thread Gregory T Pelle
Hello, I am looking for some advice regarding the tuning of a dedicated MySQL database server. The machine in questions is a Dell 2850 with dual Xeon procs and 4GB of memory running FreeBSD 6.1. Its sole purpose in life is to run the MySQL 5.0.x database engine serving out databases to

Re: MySQL tuning advice

2006-09-12 Thread Dan Buettner
I highly recommend Jeremy Zawodny's High Performance MySQL from O'Reilly. Dan On 9/12/06, Gregory T Pelle [EMAIL PROTECTED] wrote: Hello, I am looking for some advice regarding the tuning of a dedicated MySQL database server. The machine in questions is a Dell 2850 with dual Xeon procs and

Re: MySQL tuning advice

2006-09-12 Thread Brent Baisley
with persistent connections and PHP, you can easily trip over your own connections. - Original Message - From: Gregory T Pelle [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, September 12, 2006 12:50 PM Subject: MySQL tuning advice Hello, I am looking for some advice