…tool, which is synonymous with Valgrind itself, is relatively widely used for the MySQL server development: there is support for it in the MySQL Test Framework…consider backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there is no need for workarounds in…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
… the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no guarantee.’ It turned out that an…:00:00 | +———————+ Very bizarre. On one hand, it seems like MySQL is using date windowing for two-digit dates (this would explain…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads…’s test MySQL 5.6.2. It is important to remember that 5.6.2 multiple purge thread support is very experimental and is likely… half of the experiments is stable. Finally, the last two graphs: Again, we can see that there is no difference in history list…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… because it uses a threshold for which there is no good one-size-fits-all value. This plugin, … that the server is alive and responds to a query. The pmp-check-mysql-status is also very flexible …for example, you can certainly do so; it also supports an incremental mode of operation, so you can (…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… no problems in most cases. When storage type changes, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even if it is not clearly visible. mysqlcheck -A –check-upgrade is… it much slower checking your progress along the way. There is no limit as Safe you can get so I would just…
Post: MySQL Support or Support for MySQL ? MySQL Trademark Policies
October 26, 2007 By 11 Comments
What is the difference between “MySQL Support” and “Support for MySQL” ? In my mind there is not much difference in meaning just first one is shorter and… “MySQL Support” or “MySQL Consulting” The most well case known with MySQL Trademark enforcement so far is perhaps MySQL Front which MySQL asked to be renamed but MySQL… risk and MySQL may request them to be renamed. As I understand what you’re Open Source Project and make no money…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… about Query Plan is you might not be able to get new version to pick the old plan no matter how you… report the problem through MySQL support channel if often helps to know whenever it is the problem in stick MySQL changes between versions on… bug is in Percona Server indeed by running the same test on MySQL server of the same version. If you’re Support customer…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… that Oracle made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However, there are still users… just as it works on MySQL, with no need to rewrite applications, management scripts, or anything else. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…has some vanilla settings that aren’t useful. (There is no such thing as a good default, sorry.) Let’… the time. If you’re not a Percona support/consulting staff member, then of course you can … on Percona.TV, our MySQL video/screencast blog site. Another interesting topic is how to examine a system …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… MySQL because there are no clear resource usage metrics available, and so in most cases you do not know where exactly memory is… applies both to implicit and explicit ones) but as there is no control of how many tables application can create it does… be found and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
