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