MySQL processes slowing down host server

Site is overloading the server MySQL InnoDB database with approx 2gb data. Quite a few sleeping MySQL processes that could be the cause. Before drilling down in code I would like to make few tweaks to mysql db configuration.Reduce the MySQL wait_timeout value to 3 seconds and increasing the number of allowed connections.Apparently, persistent connections […]

MySQL on Mac OS X

MySQL on Mac OS X 10.7.3 Installation & configuration Download the mac based tar or dmg from MySQL website Add group mysql Add user mysql who’s group is mysql shell> cd /usr/local shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz shell> cd mysql shell> chown -R mysql . shell> chgrp -R mysql . shell> scripts/mysql_install_db –user=mysql shell> chown -R […]

MYSQL replication in the same box

MYSQL replication in the same box   MYSQL 5.0.17 standard (SLAVE) – MYSQL 4.1.1 standard (MASTER) – MASTER running on port 3306 SLAVE running on port 3308 MASTER (my.cnf) server-id = 1 log-bin SLAVE (my.cnf) [mysqld] server-id = 2 master-host = localhost master-user = root master-password = mysql master-port = 3306 replicate-do-db = […]