… is getting closer to PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that… installation base. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0… in timeline (from 0 to 1800 sec): I am not sure how to explain it, that with …
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables you to…it to verify replication Peter will discuss using it to verify upgrades I’ll show how to use it to …, get the source code from Launchpad, and file bug reports on Launchpad. PS: in addition to …
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… that get changed that might have unforeseen consequences (one of the reasons why distributions like to pin release versions.) Given MariaDB is MySQL with patches, I’m not sure quite how much that gains, or…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… standpoint and updating stats may cause old MySQL Version to get slower plan instead of new one getting faster. Check stats sampling settings such as… able to get new version to pick the old plan no matter how you try and you might be forced to change your application by changing how…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which have security features to prevent core files to…mysql (datadir) on my system (Ubuntu). You might be lucky and it might work in your system. I also enable multiple “versions…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… path than 4.1 to 5.1 just because so much more people have followed that road. So how do people approach… probably go to the earliest MySQL version and still get same result. The more exotic or complicated functionality is the more likely it to be… to temporary get extra boxes for time of upgrade. Swapping master. Finally as you have your slave running on new MySQL version you want to…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL…to crash/overtake it. Others constantly have to detect and restrict abusers. This is not to mention many Virtual Hosting companies use old MySQL versions…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… likely get more cool contributions accepted into community version. The great question however why MySQL … kind of Certified version. But lets leave this aside – this is how Sales and Marketing…versions is they are expected to reach end of life faster, so you will need to upgrade to new MySQL Version…
Post: MySQL End Of Life (EOL) Policy
August 22, 2008 By 6 Comments
We’ve discussed today how we should implement MySQL Version advisory in mk-audit tool. One obvious questions was to look at the end of life – it is often bad idea to run MySQL versions past end of life as even security bugs may not be fixed in these (though do not get paranoid…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… about how to make MySQL replication reliable, part of which is to eliminate temporary tables….What you see depends on your version of MySQL, because the logging of stored …to me that there’s no way to get the CREATE TEMPORARY TABLE statement to be logged inside the transaction. And when it comes to…
