A duplicate key error resulting from a trigger operation.
How I rotate MySQL's InnoDB log files.
I was receiving this error multiple times in the MySQL 5.6.13 error log for my slaves. This is how I figured out the problem and fixed it.
Some solutions to MySQL temporary tables disappearing after a MySQL restart, especially within a Stored Procedure during Replication.
A resume of my skills and accomplishments.
If you've ever pasted a word document into a browser's text area and then insert it into a MySQL table, you've probably encountered some funky characters replace the quotes, dashes and other special characters.This is due to Microsoft using extended character sets over ASCII 128.In the past I'd have to manually search and replace the bad text. Today I decided to find a better solution. Searching on Google, I came across the following blog postReplacing smart quotes, em-dashes, and ellipses with...
To tell how many files MySQL has open, you need to login as root and run one of the following commands:# lsof | grep mysql# lsof | grep mysqld# lsof -c mysqld# ls -l /proc/<PID>/fd /* where <PID> is the process ID of the program you are interested in */# lsof | grep "/var/lib/mysql"You can tell how many files your OS has opened with this:# cat /proc/sys/fs/file-maxOn a MySQL client, you can run the following:SHOW OPEN TABLESTo close the open files run:FLUSH TABLES
I am compiling a list of resources I am using to study for the MySQL 5 Certification. This blog entry is for Part I and II of the DBA exam. I will have a separate blog for the Developer exam as well.MySQL DBA Part ILinks to Check OutMySQL DBA Part IILinks to Check Out PlanetMySQL Blog: I Can't See My Databases! http://www.planetmysql.org/entries/4376 PlanetMySQL Blog: What to Tune in MySQL Server after Installation http://www.planetmysql.org/entries/4279 PlanetMySQL Blog: MySQL...