…, it gives me this error message: “mysql_install_db: command not found” I’m not able to find mysql_install_db anywhere on the… work on either. Should I install Percona server: http://www.percona.com/doc/percona-server/5.5/installation.html on these images…
Post: More on MySQL Error Messages
April 6, 2011 By 9 Comments
I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error messages it produces. Now…/share/mysql/english/errmsg.sys The file does exist so “can’t find messagefile” error message is misleading to say the least. The error… it in Percona Server ? We could but because there are a lot of simple changes needed, plus many of message files would…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 10 Comments
I already wrote about some MySQL Error Messages which are confusing, here is one more: 080603 20:53:… new slave Server I’m getting error log file flooded with messages like this and there is no hint in the message what would… it would be nice to include possible reason for this error message which MySQL already does in many other cases. I’ve now…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
… 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… by pwd; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… indexes 7 defined in the MySQL This customer was running Percona Server 5.1 and they got this error on two tables during…’d probably consider this on a newer version of Percona Server or MysqL 5.6. Another person (I’m looking at you… to close and be reopened and simply see if the error message comes back. That might something of a performance impact, but…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… Percona’s data recovery experts, among other things). Percona Server news: Percona Server 5.5 release is nearing the final stages: Vadim… awkwardly worded and badly spelled error messages and the like. There is work afoot to get Percona Server packages included in Ubuntu. There… provide Windows packages for XtraBackup. XtraBackup tests were augmented: more server versions, tests for export/import, tests for partitioned tables. Bug…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
… it unless you look in MySQL server Error Logs but the error message accessing Innodb tables is also very obfuscated: error : Incorrect information in file: ‘./prod… your server you should first take a look at MySQL Server error logs but few people do it or spend a time examining error messages accurately…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
…MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql….00 sec) mysql> select * from test_innodb; ERROR 2013 (HY000): Lost connection to MySQL server during query Recovering…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… against more recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, Percona Server 5.1.59… operating messages would go to STDERR. With this bug fixed, we have gone through both programs and ensured that only error messages go… –incremental-lsn options were specified together, innobackupexwould give an erroneous error message when it tried to look at the contents of a…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option …engine_condition_pushdownblogpercona.commanual error_countblogpercona.commanual event_…lc_messagesblogpercona.commanual lc_messages_dirblogpercona.commanual lc_time…modeblogpercona.commanual ssl_verify_server_certblogpercona.commanual Ssl_versionblogpercona…
