Question : I have a question in regards of what potential issues that might happen with a MySQL 5.1 DB […]
MySQL 5.1: change datadir variable value in my.cnf
Question : Below is my system configuration: OS: RHEL5 MySQL: 5.1.73 Default datadir=/var/lib/mysql/ But, the above directory has space crunch. […]
Can I do anything about a very long running KILL command?
Question : I’ve got a table with 103M+ records in it and takes up 70GB on the disk. I decided […]
Upgrading from MySQL 5.1.37 to MySQL 5.1.73
Question : We have a fairly advanced website that runs on a cloud system. We have one master DB server […]
How to replicate particular table in MySQL master-slave configuration?
Question : How do I replicate a particular table in a MySQL master-slave configuration? I have tried replicate-do-table and replicate-wild-do-table. […]
Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down
Question : I always wonder, why does the max_used_connections value not come down, once it reaches the peak value of […]
Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?
Question : MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than […]
InnoDB engine is not loading after tuning parameters
Question : After installing MySQL-5.1.73, I placed default my-huge.cnf into /etc/my.cnf and started the mysql service. It was running without […]
MySQL replication – slave is continuously lagging behind master
Question : I am using MySQL-5.1.50 with a Master-slave replication setup. Most of the time the slave is lagging behind […]
Disable MySQL replication
Question : I’m running following: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.6 (Santiago) # uname -a Linux […]