… 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
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…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… 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: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… 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: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… MySQL table but it is not convenient enough. Bad Parser Error Messages MySQL Parser is in general far from perfect when it comes to error handling. “You have an error in your SQL… taken a time to research into details. So just beware. I also hope other time MySQL and third parties will develop tools…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… connection is not 0 (NORMAL) Check connection handling manual for details. The testing I did was as follows – I would run… surprising: Running “TightLoop” script terminated after 30 seconds with “Fatal error: Maximum execution time of 30 seconds exceeded in /var/www… to print nice error message as well as to do some cleanup work – for example you can open another MySQL connection to kill…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… it turns out to be hard — I want to provide details and links for everything, but then it isn’t really a digest anymore, so I cut out a lot of detail. Team news in general: There is a new Quality Assurance… some English-editing changes to awkwardly worded and badly spelled error messages and the like. There is work afoot to get Percona…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…–pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:…most variability, so I’ll have to be even less detailed and a little vague. The next command is this: … I’m going; or just get on an instant messaging chat and tell the customer “here’s the top …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical … fail with “ERROR 1020 (HY000): Record has changed since last read in table ‘t’” error message. If … be changed. This is also area where detailed documentation is missing so far. [-] No protection …
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… became different, they just need to be detailed enough. So back to this case… MySQL was getting overloaded with thousands of same… err when it tries to put too much load on MySQL as MySQL load stabilizes increasing number of connections higher until you… on page basics when you randomly have some pages giving error messages. In some cases you can also do ramp up feature…
