June 18, 2013

Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)

…server from slave to master. One of the key things to protect your data integrity is …-host and master-port in the my.cnf file? # cat my.cnf [...] master-user=rsandbox master-…> change master to master_host=”; ERROR 1210 (HY000): Incorrect arguments to MASTER_HOST Fortunately, the documentation also…

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

key(col DESC)). If I run myisampack, it generates 1kb file which doesn’t work. 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”.

Post: How to diagnose errors in the MySQL error log

… our forums: 120326 16:56:45 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#sql_21b2_0.MYI’; try to repair…:56:45 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file ‘/tmp/MYK74Kpi’ (Errcode: 28) The gem in all of that… examples are error 13 (permission denied) or 2 (No such file or directory). The typical reaction is “but it certainly has…

Comment: The #1 mistake hosting providers make for MySQL servers

…. From time to time we get the “ERROR 126 (HY000): Incorrect key file for table” error message, we repair the table, but it…

Post: Logging Foreign Key errors

… log those errors. It can log them to a table, file or just show them on STDOUT. Let’s see how… with perror: # perror 150 MySQL error code 150: Foreign key constraint is incorrectly formed Still difficult to know what the problem is… what the tool has logged: mysql> select * from test.foreign_key_errors\G *************************** 1. row *************************** ts: 2012-09-26 14:28:31…

Post: MySQL Error Message Nonsenses

… iceberg of not so helpful or misleading error messages. Incorrect information if file table.frm is perhaps my favorite one. How do… discover this issue – storage engine which is specified in .frm file is not available and give user friendly error message. Another… strange file system/OS error until you run perror: [pz@sl1 ~]$ perror 150 MySQL error code 150: Foreign key constraint is incorrectly formed…

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

… is that there are a lot of “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632…_doc_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY); ERROR 1166 (42000): Incorrect column name ‘fts_doc_id’ Various points in…, for each new FULLTEXT KEY that you create, you’ll get a corresponding FTS_*_DOC_ID.ibd file (but none of the…

Post: Announcing Percona Server for MySQL version 5.5.29-30.0

… Biveinis). Time in slow query log was displayed incorrectly when slow_query_log_timestamp_precision variable… upstream bug #67504 that caused spurious duplicate key errors. Errors would happen if a trigger… rpm builds, that were caused by missing files. Bug fixed #1099809 (Alexey Bychko). Fixed the …

Post: Heikki Tuuri Innodb answers - Part I

… accessed, and in an ascending order of the file address, then InnoDB schedules the read of all … the system’s memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here…, in the same order in the foreign key and the referenced key (this same order condition could be …

Post: Hacking to make ALTER TABLE online for certain changes

…_increment, (2) flush tables with read lock, (3) swap .frm files while keeping mysql suspended and (4) unlock the tables afterwards…` (text) VALUES (‘test’); ERROR 1062 (23000): Duplicate entry ’0′ for key 1 Unfortunately, adding auto_increment does not work that way… – rows that have incorrect values are just returned as empty. But I suppose this does violate mysql data file structure, so be…