June 18, 2013

Post: How to diagnose errors in the MySQL error log

March 26, 2012 By 4 Comments

… our forums: 120326 16:56:45 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#sql_21b2_0.MYI’; try to repair it 120326… writing file ‘/tmp/MYK74Kpi’ (Errcode: 28) The gem in all of that mess is this bit: (Errcode: 28). Now, MySQL includes a… left on device That’s the key to understanding what really happened. MySQL created a temporary table, using the MyISAM storage engine, and…

Filed Under: Insight for DBAs, Percona Software

Comment: To pack or not to pack - MyISAM Key compression

October 26, 2008 By 4 Comments

pack_keys doesn’t seem to do anything for me (MySQL 5.0). I have table with index in reverse order (primary key(col DESC)). If I run myisampack, it generates 1kb file…. myisamchk rebuilds the index, and rebuilt index file has sensible size, but still doesn’t work – all I get is “126 Incorrect key file for table“.

Filed Under: Insight for DBAs Tagged With: , ,

Post: Logging Foreign Key errors

September 27, 2012 By Leave a Comment

…table, file or just show them on STDOUT. Let’s see how to use it: 1- Create the table First we create the table… MySQL error code 150: Foreign key constraint is incorrectly…key in table is “PRIMARY” See http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html for correct foreign key…

Filed Under: MySQL

Post: Hacking to make ALTER TABLE online for certain changes

October 29, 2007 By 26 Comments

…table with desired table structure and switch .frm table definition files. For safety, I’d recommend to flush tables with read lock while switching .frm files…incorrect values are just returned as empty. But I suppose this does violate mysql data file…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Announcing Percona Server for MySQL version 5.5.29-30.0

February 26, 2013 By Leave a Comment

…Percona Server for MySQL version 5.5…files were created and treated as InnoDB data files for…key errors. Errors would happen if a trigger is fired while a slave was processing replication events for a table…for the slow query log. Bug fixed #730173 (Laurynas Biveinis). Fixed the incorrect help text for…

Filed Under: Events and Announcements, MySQL, Percona Software Tagged With: , , ,

Post: MySQL Error Message Nonsenses

March 16, 2008 By 7 Comments

… iceberg of not so helpful or misleading error messages. Incorrect information if file table.frm is perhaps my favorite one. How do you… of strange file system/OS error until you run perror: [pz@sl1 ~]$ perror 150 MySQL error code 150: Foreign key constraint is incorrectly formed… table ‘yt’ is full For me table is full means something like I’m out of disk space (or quota set for the table size…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… error: mysql> CREATE TABLE dir_test_innodb4 (fts_doc_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY); ERROR 1166 (42000): Incorrect column name… of the FT indexes for a given table, you’re still left with all of the other FTS_*.ibd files, and it appears that the only way to get rid of them is to actually rebuild the table. -rw-rw—-. 1 mysql mysql…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

…, and in an ascending order of the file address, then InnoDB schedules the read of …€™s memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here. …for example, if ORDER and ORDERLINE tables are joined to form a single table), it might make sense for a foreign key…

Filed Under: Insight for Developers Tagged With: ,