Why the huge difference between etch and lenny MySQL

Posted by rmarimon on Server Fault See other posts from Server Fault or by rmarimon
Published on 2010-05-29T16:02:58Z Indexed on 2010/05/29 16:12 UTC
Read the original article Hit count: 468

Filed under:
|

I've been working on a program for the last year. The development environment is working with a database in MySQL running on debian etch version mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2. The production environment is working on debian lenny with version mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2. I was just timing some database access and what takes in the development environment 150 seconds, takes 300 in the production environment. I checked the /etc/mysql/my.cnf files on both systems and the only differences are

# development 
bind-address        = 10.168.1.82
log_bin         = /var/log/mysql/mysql-bin.log

# production
bind-address        = 127.0.0.1
myisam-recover      = BACKUP
#log_bin            = /var/log/mysql/mysql-bin.log

I dump a database from the production and load it into the development and with the same server everything takes half the time !!! What should I check?

© Server Fault or respective owner

Related posts about mysql

Related posts about Performance