# my.cnf advice needed
**URL:** https://forums.percona.com/t/my-cnf-advice-needed/1522
**Category:** Other MySQL® Questions
**Created:** [September 30, 2010, 1:52pm UTC](https://forums.percona.com/t/my-cnf-advice-needed/1522 "2010-09-30T13:52:55Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@jeffchristiansen](https://forums.percona.com/u/jeffchristiansen)
#### Post date: [September 30, 2010, 1:52pm UTC](https://forums.percona.com/t/my-cnf-advice-needed/1522/1 "2010-09-30T13:52:55Z")
Hello,
I’ve already made some changes based on other threads I’ve found here (increasing interactive\_timeout from 10 to 600 and wait\_timeout from 10 to 30 sec), however I’m looking for any additional suggestions for improving performance. I’m already tracking down some of the slow queries from the log.
This server is dedicated for MySQL only. The servers connecting to them are mainly connecting via ColdFusion 9, but some PHP.
Dell PowerEdge 185
Red Hat Enterprise Linux ES release 3 (Taroon)
MySQL Version: 5.0.22-standard-log
4GB of RAM
Dual 2.8GHz/2MB Cache, Xeon, 800MHz Front Side Bus
36GB SCSI 15K HD
my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max\_connections=250
set-variable = interactive\_timeout=600
set-variable = wait\_timeout=30
set-variable = max\_allowed\_packet=1M
set-variable = max\_connect\_errors=999999
skip-innodb
skip-bdb
skip-locking
key\_buffer\_size = 1024M
max\_allowed\_packet = 2M
table\_cache = 768
sort\_buffer\_size = 8M
record\_buffer=1M
read\_buffer\_size = 2M
#read\_rnd\_buffer\_size should be 1M per GB of RAM
read\_rnd\_buffer\_size = 6M
myisam\_sort\_buffer\_size = 64M
thread\_cache\_size = 64
query\_cache\_type=1
query\_cache\_size= 64M
query\_cache\_limit=2M
thread\_concurrency = 4
#tmp\_table\_size should equal max\_heap\_table\_size as mySQL uses the smaller of the two
tmp\_table\_size = 1024MB
max\_heap\_table\_size = 1024MB
join\_buffer\_size = 2M
log-slow-queries
long\_query\_time=1
log-error= /var/lib/mysql/usint02-slow.log
#log-queries-not-using-indexes
[mysqldump]
quick
max\_allowed\_packet = 16M
[mysql.server]
user=mysql
#basedir=/var/lib
[safe\_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[isamchk]
set-variable = key\_buffer=128M
set-variable = sort\_buffer=128M
set-variable = read\_buffer=2M
set-variable = write\_buffer=2M
[myisamchk]
set-variable = key\_buffer=128M
set-variable = sort\_buffer=128M
set-variable = read\_buffer=2M
set-variable = write\_buffer=2M
[mysqlhotcopy]
interactive-timeout
I’d be happy to provide any additional information if it would be helpful. We are using phpMyAdmin, so I have provide reports from it as well.
Thank you,
Jeff
---
### Author:  [@xaprb](https://forums.percona.com/u/xaprb)
#### Post date: [October 1, 2010, 4:14pm UTC](https://forums.percona.com/t/my-cnf-advice-needed/1522/2 "2010-10-01T16:14:35Z")
5.0.22 is a steaming pile of… your first action should be to upgrade to the latest 5.0.x series. And why are you disabling InnoDB?
---
### Author:  [@jeffchristiansen](https://forums.percona.com/u/jeffchristiansen)
#### Post date: [October 1, 2010, 9:03pm UTC](https://forums.percona.com/t/my-cnf-advice-needed/1522/3 "2010-10-01T21:03:02Z")
Thanks for your reply xaprb. Obviously, I’m not a DBA and have been learning things on my own as I go. This system has been in place for several years, I wasn’t the installer, and hasn’t been updated. I appreciate your assistance.
At the risk of sounding naive, shouldn’t I upgrade to the latest version (5.1.51) instead of 5.0.x? Also, since I’ve never performed one, how complicated is the upgrade process?
Regarding InnoDB, our tables have been MyISAM since they were set up originally (as the default I believe). I believe that skip-innodb came from when we had MySQL running on the web server and had limited RAM. Should I consider changing to InnoDB? I read this article ( [http://www.mysqlperformanceblog.com/2009/01/12/should-you-mo](http://www.mysqlperformanceblog.com/2009/01/12/should-you-mo) ve-from-myisam-to-innodb/). All our tables together are 133MB and use mysqldump to make nightly backups. I run a website that displays information, there is some user interactivity, but we’re mostly doing selects, some of which are pretty complex; very few inserts and deletes except for a couple tables.
One thing is painfully clear, I think I need to pick up a copy of your book.
Thanks again,
Jeff