MySQL Blog Entries


Posted Jul 29, 2015

MySQL: SQL Error (1062): Duplicate entry '16777215' for key 'PRIMARY'

Posted Oct 9, 2013

A duplicate key error resulting from a trigger operation.

Rotating the Innodb Log File

Posted Oct 9, 2013

How I rotate MySQL's InnoDB log files.

MySQL 5.6 - [Note] Slave: received end packet from server, apparent master shutdown

Posted 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.

MySQL In Memory Temporary Tables in Stored Procedures with Replication

Posted 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

Posted Mar 18, 2013

A resume of my skills and accomplishments.

Replacing Bad Microsoft Characters in MySQL

Posted 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

Posted 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

Posted 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...

Latest Discussions

  • Carlos: Thank you!
    May 16, 2014 | Replies (0)
  • Jessica: Great info, thanks!
    May 15, 2014 | Replies (1)
  • Walter: Thanks, you totally saved me a bunch of searching around just now. I was setting up a percona xtradb...
    Feb 25, 2014 | Replies (0)
  • Avi: I've found the reason of the problem in my case. It's a bug as described here :
    Dec 12, 2013 | Replies (0)
  • Avi: I've also met that behavior twice on 5.6.12 slaves. However, i didn't find the root cause of that....
    Dec 12, 2013 | Replies (0)