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?

link|improve this question

50% accept rate
same RAM? same HW? same storage engine in both servers? – Marco Ramos May 29 '10 at 16:08
Yeap. Same server with same configuration. Just different versions of mysql and the changes in the my.cnf. – rmarimon May 29 '10 at 16:10
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.