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
mysql
|Performance
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