…in customer cases featuring the following error message: SQLSTATE[HY000] [1135] Can’t create…:59:37)# service mysql restart Shutting down MySQL (Percona Server)… SUCCESS! Starting MySQL (Percona Server).. SUCCESS!… the issue. See here for additional details (Thanks to Raghavendra Prabhu for the link…
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: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly authenticated: …it’s possible to log access denied messages to the error log. We just need to enable log… are using Percona Server you can get more detailed information about what a particular user is doing….
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: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… Percona’s software is open-source and free, all the details of the release can be found in the 5.1… unbootable server. Bug fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on… MySQL 5.0 or older, importing that table could crash Percona Server in some cases. Bug fixed #1000221 (Alexey Kopytov). Error log messages…
Post: Announcing Percona Server 5.5.25a-27.1
July 21, 2012 By Leave a Comment
…is open-source and free, all the details of the release can be found … statements will fail with the following error: “The MySQL server is running with the –…message wasn’t pointing to Percona Server bugtracker. Bug fixed #1007254 (Vadim Tkachenko). If the tablespace has been created with MySQL…
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
…open-source and free, all the details of the release can be …introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug … #686392 (George Ormond Lorch III). LRU messages are now more verbose for LRU… compiler resulted in a compiler error. Bug fixed #997496 (Alexey Kopytov). Variable …
