MariaDB 5.3 is now GA, and MariaDB 5.5 is RC. One of the primary features in these releases is all-round coverage with subquery optimizations. Practically every kind of subquery available in SQL has got some new optimization . We do a lot of...
For as long as it is only about a few of them, it is as simple as looking at the SHOW PROCESSLIST output for thread identifiers to kill. They can be found in the first column called Id . These values can be passed to KILL thread_id command in...
In an earlier post titled How to work with a long process list in MySQL , we showed a neat way to work with the process list by using various shell tools. But some of that can also be done using pure SQL. Since version 5.0 a lot of MySQL meta and...
I m really excited to today announce the first GA (Generally Available; i.e. stable) release of Percona XtraBackup 2.0 . We have worked hard since our last major release on improving the reliability and user experience of Percona XtraBackup as...
I m really excited to today announce the first GA (Generally Available; i.e. stable) release of Percona XtraBackup 2.0 . We have worked hard since our last major release on improving the reliability and user experience of Percona XtraBackup as...
I am happy to also announce the latest minor release in the Percona XtraBackup 1.6 series. We recognise that not everybody will want or be able to make the leap to our new major release, Percona XtraBackup 2.0 and so we re also releasing Percona...
I am happy to also announce the latest minor release in the Percona XtraBackup 1.6 series. We recognise that not everybody will want or be able to make the leap to our new major release, Percona XtraBackup 2.0 and so we re also releasing Percona...
I ve been a consultant for over five years now and I m just beginning to learn some basic things. One of them is how to spot a lose-lose customer relationship. I say I m just beginning because I continue to find new lose-lose scenarios that I don...
If for any reason you need to change the size of InnoDB log files (also known as transaction logs ), but not sure how to do it, this post will guide you through the steps. Step 1: Preflight checks Something to keep in mind Database restart is...
Today at a conference I was approached with a task, typical for a modern web app. We have a chat system, and need to store and show all messages in the system. There is no limit as to how long you store, and how much you can see. There are two...