… 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: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 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…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…MySQL / Percona Server Application compatibility. There is no or minimal application changes required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is… transactional applications. The Galera library is developed by Codership Oy company and Galera 2.x supports such new features as: …
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… environments. The 2.0.0 release contains no changes from the last beta (1.9….is now included as well. Support for compiling and running Percona XtraBackup against debug versions of InnoDB. This is… the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there …
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… enables you to ALTER large tables with no blocking or downtime. As you know, MySQL locks tables for most ALTER operations, but… table with no interruption. With this new version of the tool, one of the most painful things anyone experiences with MySQL is significantly…, for example, to support new types of RAID controllers. Percona Toolkit is a hot topic at the upcoming MySQL Conference and there will…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…, and that is Hash Joins. Hash Join As I have told before MySQL has only supported one join algorithm and that is Nested Loop… appropriately sized buffers less no. of Innodb_buffer_pool_reads are done, and less amount of data is read from disk, in… is one number in MariaDB 5.5 that is quite large as compared to MySQL 5.6 and that is ‘Handler_mrr_init’. Is it…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 23, 2012 By 9 Comments
… flavors of MySQL. 2. I am the lead author of the second and third editions of that book. I have no involvement… Doing Something Wrong, but that is not a topic for this comment thread. You could try our forum or consulting/support services!
Post: MySQL End Of Life (EOL) Policy
August 22, 2008 By 6 Comments
… of MySQL 5.0 most likely before MySQL 5.1 will proven MySQL 5.0 replacement. There is no blame on MySQL – it is no fun to support these old versions both for Support team… for this and this is exactly what premium MySQL Support levels are for. My main point is – make sure you understand MySQL Release Policy and…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… Pacemaker installation since this is fairly straightforward and covered elsewhere. I’ll discuss the MySQL resource agent and the supporting configuration while assuming…beyond a defined threshold, the reader VIP(s) is removed. MySQL is not restarted. If no slaves are ok, all VIPs, readers and writer…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…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…
