Early bird registration for the International PHP Conference might be over but Oracle has just received discounts. 
If you register for a 2 days with the code "Oracle 1" it will only cost you 499€ instead of 699€ +VAT. If you register for a 3 days with the code "Oracle 2" it will only cost you 699€ instead of 899€ +VAT.
Ulf Wendel from Oracle is going to be presenting 2 different sessions on MySQL:

• MySQL DB Cluster Usage made easy: mysqlnd_ms
• …

Some archeologist will find my first two editions of High Performance MySQL and wonder why I stored so many Post-It notes and wrote some many notes in them.

High Performance MySQL editions one through three

I picked up the first edition at a MySQL Conference in Orlando and was impressed. The second edition was more impressive when it appeared a few years later. Now the third edition has come off the presses.

The third edition is bigger, badder, and covers all the updates while retaining the easy to read style from the previous editions. This book has become as ‘must have’ reference for MySQL DBAs. And yes you need one on your desk ASAP.

In this tutorial I will describe how to setup gitorious on Ubuntu 11.10. Gitorious – a Ruby on Rails web application – can be used to conclude git projects in an easy to manage user interface. In the README of the gitorious repository I found the evidence “One of the main challenges in Gitorious is its installation process. It is anything but trivial.” – It appears correct During the installation I got some errors by the sphinx search engine and some ruby gems. You will find the workarounds in this tutorial.

Contents

• 1 software installation
  • 1.1 Required packages
  • …

Make sure to leave some room in your suitcase if you’re going to the Percona Live: MySQL Conference and Expo next week. The OurSQL podcast folks – that’s me, current co-host Gerry Narvaja and former co-host Sarah Novotny – will be giving away FREE CD’s and signing them during the book signing on Wednesday night. I will also have a limited number of copies of The MySQL Administrator’s Bible for sale for USD$40 – or you can order it ahead of time from Amazon.com and save yourself about $10.

Mozilla will be having a booth in the Dot Org pavilion this year. Stop by and say hi, let us know what you love (and …

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 testing, so these new optimizations should be now reasonably stable. What is missing is performance testing with real-world queries on real-world data. I expect most of the time you will see a speedup, however, there can also be cases where the new version will be slower. New optimizations make query plan search space much bigger, this means the new optimizer will have lots of room to make errors where previously was none.

Back at MySQL Ab, I could use bugs/support …

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 MySQL. The problems appear with more complex scenarios. What if one needs to terminate all queries running longer than ten seconds? Doing copy&paste repetitively could take a lot of time with twenty or so candidate threads. This can be done much more efficiently.

INFORMATION_SCHEMA to the rescue!

Earlier today we showed “Anohter way to work with MySQL process list”. That post presents how PROCESSLIST table can be used to retrieve any information about connected threads or running queries.

In order to perform …

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 runtime information can be accessed by reading from predefined views in a database called INFORMATION_SCHEMA. The information which can be found there includes lists of threads, tables, user created views, triggers, stored procedures and many, many other things. The newer the MySQL version, the more items can found in there.

This post is about the process list, so it will focus on just one of the tables called PROCESSLIST. Its structure is virtually identical to what SHOW PROCESSLIST command returns.

mysql> DESC …

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 well as adding features to make it better suited to more environments.

The 2.0.0 release contains no changes from the last beta (1.9.2), only the version number has changed.

New since 1.6:

• Percona XtraBackup can now save Galera replication information while performing a backup when given the --galera-info option to innobackupex.
• XtraBackup now supports compressed backups. These backups can be done in a parallel way, thus utilizing multiple …

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 XtraBackup 1.6.6.

This is a minor release and source code and binaries can be downloaded from our downloads site. Our main APT and YUM repositories are now carrying Percona XtraBackup 2.0.0, so you won’t see 1.6.6 there.

We’re also keeping the documentation for the 1.6 series separate, which is now located at: http://www.percona.com/doc/percona-xtrabackup/1.6/

Release notes for 1.6.6 are available in our …

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 needed as part of this process.

Locate your MySQL configuration file

If you don’t know where the configuration file is, you can follow one of my previous posts on “How to find MySQL configuration file?”.

Find the existing logs and check their size

If database is running, you can simply use a tool called lsof:

db01 ~ # lsof -c mysqld | grep ib_logfile
mysqld    15153 mysql    9uW     REG                8,3 5242880 19350809 /var/lib/mysql/ib_logfile0
mysqld    15153 mysql   10uW     REG                8,3 5242880 …