MySQL Foriegn Key create ERROR: MySQL Error Number 1005
Have you ever come across this error? MySQL Error Number 1005ERROR 1005 (HY000): Can’t create table ‘./wordpress/#sql-2693_f74e.frm’ (errno: 150) Jason summarized very good article to track down error reported on his blog. It helped me , hopefully these tricks will help you as well!! Post in comment , if it helps to save your day!!
Find MySQL table level Insert/Update/Delete Statistics
Many customers are asking for getting stats from their MySQL installation. It’s pretty easy to find stats per database from Com_ variables and graph them as counter to get the number of INSERT/UPDATE/DELETE on the database level. To get the DML stats from MySQL at table level there is only one option : mysqlbinlog . […]
DBA Boot Camp: MySQL for the Oracle DBA
Wow!! It’s free seminar for full day on MySQL for Oracle DBA!! Check it out on MySql website to free registration. Location and details: Date: Tues Aug 14, 2007Time: 8am-6pmLocation:The Westin New York at Times Square270 West 43rd StreetNew York, NY 10036Phone: 212-201-2700Fax: 212-201-2701Reservations: 866-837-4183 I am going to attend . If you are , […]