MySQL Posts

Jul 29, 2015
Blog Post Editor: Setting Publish Date
Oct 27, 2014
PHP Calling Multiple MySQL Stored Procedures
Oct 8, 2014
CakePHP: Restrict DebugKit to An IP Address
Sep 20, 2014
MySQL: SQL Error (1329): No data - zero rows fetched, selected, or processed
Apr 3, 2014
MySQL: SQL Error (1062): Duplicate entry '16777215' for key 'PRIMARY'
Oct 9, 2013
A duplicate key error resulting from a trigger operation.
Rotating the Innodb Log File
Oct 9, 2013
How I rotate MySQL's InnoDB log files.
MySQL 5.6.13 : The incident LOST_EVENTS occured on the master. Message: error writing to the binary log
Oct 2, 2013
MySQL 5.6 - [Note] Slave: received end packet from server, apparent master shutdown
Sep 5, 2013
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.
PHP Class For Submitting Leads to MyMedLeads API
Aug 6, 2013
MySQL In Memory Temporary Tables in Stored Procedures with Replication
Jul 6, 2013
Some solutions to MySQL temporary tables disappearing after a MySQL restart, especially within a Stored Procedure during Replication.
Website and MySQL Developer Resume - Orlando, Fl
Mar 18, 2013
A resume of my skills and accomplishments.
Replacing Bad Microsoft Characters in MySQL
Apr 20, 2010
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...
How many files does MySQL have open on Redhat Linux
Oct 31, 2006
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
MySQL 5 Certification DBA Review
Oct 24, 2006
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! PlanetMySQL Blog: What to Tune in MySQL Server after Installation PlanetMySQL Blog: MySQL...