…and New one is Barracuda? It should not be the problem. Innodb internal format is rather low level and it rarely impacts application…the same time so other has full resources (including memory) available. Another thing to mention having multiple instances of different MySQL versions on the same…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…and persistent connections combined with a large number of application servers can lead to a situation where the database server…MySQL replication is one of the core, fundamental features — and it’s single-threaded and relies on the binary log, which are two major limitations. And…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… down the MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL versions… a DROP table waiting to run on the same table, and as such I have reported the bug: http://bugs.mysql.com/bug.php?id=67873
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… your application by changing how query is written and provide the hints. Check Query Execution If query execution plan looks the same it …bug to Percona Server bug tracking system check whenever the bug is in Percona Server indeed by running the same test on MySQL server of the same version. If …
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL… be application changes which might not be practical for old applications. For the same reasons we often see old MySQL versions not being upgraded to the…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… data races, starvations etc–have a big impact on application‘s stability and are at the same time hard to find due to their nondeterministic…used for the MySQL server development: there is support for it in the MySQL Test Framework, DBQP, and the server source is properly annotated to get the most …
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…the process we work on generation test database of significant size as testing your application on…The downside of using these techniques if of course you’ve got to have summary tables and original tables on the same server…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…MySQL 3.23 and MySQL 4.0 team the small tight knit team was working on the server and Monty was personally reviewing all the code and knew all the…and especially its efficiency) is not growing on the same pace. This also means fewer customers use the same features, and so the…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…Server on Linux You’re a corporate application…and install Percona Server from the Arch Linux AUR Repo at the same time: (pacman is the…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…mysql“). Before you embark on enabling core file you should consider two things – disk space and restart time. The core file will dump all MySQL Server…the if it works you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes accessing the…
