June 19, 2013

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

… in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE… 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index …detail what the “will be disallowed in a future release” means. In MySQL

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… questions in this post, along with providing a bit more detail on some of the questions that I did cover during… this message: 130606 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers…

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

… from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL…) mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR… restart replication, it fails. However, I don’t like the error message, specifically the ‘fix in config file’ part. What happens if…

Post: MySQL Error Message Nonsenses

… helpful error messages. Start with basics for example – The error message in case of syntax error gives you information about tokens near by but little details: mysql> select * from user oder by pwd; ERROR 1064…

Post: Recovering CREATE TABLE statement from .frm file

MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql

Post: Troubleshooting Relay Log Corruption in MySQL

… relay relay log corruption and you can check details in the MySQL Error log file. The error message describes few reasons and indeed because there… in relay logs. Really this is only one of various error messages you could see if relay log corrupted. You could also… are bad on the master you would get the same error message again and can continue with investigation. What if logs on…

Post: Percona XtraBackup 1.6.4

MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL…innodb files blueprint for technical implementation details. Bugs Fixed innobackupex assumed that /…messages would go to STDERR. With this bug fixed, we have gone through both programs and ensured that only error messages

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

mysql> alter table dir_test_innodb ADD FULLTEXT KEY (full_name, details), ADD FULLTEXT KEY (details); ERROR

Post: Announcing Percona Server 5.1.66-14.1

… is open-source and free, all the details of the release can be found in …#805805 and #1060136 (Laurynas Biveinis). Fixed the upstream MySQL bug #61509. Crash in YaSSL was causing… checks are enabled. Error message has been made more verbose including error number and system error message as well. Bug…

Post: Announcing Percona Server 5.5.27-29.0

… is open-source and free, all the details of the release can be found in …are enabled. Error message has been made more verbose, it now includes the error number and system error message as well… maximum number of indexes per table. Upstream MySQL bugs: #54127, #61178, #61179 and #61180. Bug fixed …