tcpdump -i eth0 ‘port 3306’
Category: MySQL
Migrate MySQL from Slaved Drive
Migrate MySQL from Slaved Drive 1. Mount the slave drive. We’ll assume you mounted it at /media/slave Find the drive: # fdisk -l Disk /dev/sda: 1000.2 GB, 1000204886016 bytes 255 heads, 63 sectors/track, 121601 cylinders Units = cylinders of 16065…
Optimize Mysql
Did you know that mysql comes with configuration files for better optimization? These files are located at: /usr/share/doc/mysql-server-5.1.71/my-huge.cnf /usr/share/doc/mysql-server-5.1.71/my-innodb-heavy-4G.cnf /usr/share/doc/mysql-server-5.1.71/my-large.cnf /usr/share/doc/mysql-server-5.1.71/my-medium.cnf /usr/share/doc/mysql-server-5.1.71/my-small.cnf /usr/share/man/man5/openssl.cnf.5ssl.gz Or /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Stop mysql # service mysqld stop Stopping mysqld: [ OK ]…
Mytop
Install the repository CentOS 5.x rpm -Uhv http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm CentOS 6.x 64 bit rpm -Uhv http://apt.sw.be/redhat/el6/en/i386/rpmforge/RPMS/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm Install mytop yum -y install mytop Configuration Odds are, you will get an error initially running this program unless you configure it first. whereis mytop…
Debugging sleeping connections with MySQL
Have you ever seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why this would happen ? I see if frequently with web applications and it is often…