The new year is here and I have moved my (so far quite silent) blog to use WordPress and MySQL 5.5 GA.

Since I am using Ubuntu I downloaded a compressed tar archive. I installed it in a custom directory and for starting I wrote a little upstart script.

$ cat /etc/init/mysql-5.5.conf
start on startup
stop on shutdown

env basedir=/opt/mysql/mysql-5.5
env defaults=/etc/mysql-5.5/my.cnf

script
        cd $basedir
        $basedir/bin/mysqld_safe --defaults-file=$defaults
end script

In wp-config.php I have set:

define('DB_HOST', …

Interested in MySQL on Windows? Join our next Oracle TechCast Live on Tuesday January 11th at 10.00 am PT! MySQL Product Manager Mike Frank will then tell you all about the major MySQL 5.5 performance gains on Windows.

In case you're not familiar with the Oracle TechCast Live events, they're akin to online "fireside chats" with experts about new tools, technologies and trends in application development. They also include live Q&A sessions, and you can ask questions via Twitter & Facebook. You can check out a few archived sessions here.

Get ready to ask your questions to …

Interested in MySQL on Windows? Join our next Oracle TechCast Live on Tuesday January 11th at 10.00 am PT! MySQL Product Manager Mike Frank will then tell you all about the major MySQL 5.5 performance gains on Windows.

In case you're not familiar with the Oracle TechCast Live events, they're akin to online "fireside chats" with experts about new tools, technologies and trends in application development. They also include live Q&A sessions, and you can ask questions via Twitter & Facebook. You can check out a few archived sessions here.

Get ready to ask your questions to …

MySQL 5.5 has created a lot of hype and its not just hype, there are major performance enhancements not only in the MySQL server itself but in the newer InnoDB plugin shipped with MySQL 5.5. That's exactly the reason why I have myself upgraded to MySQL 5.5 (The server running this blog run MySQL 5.5). Now since I haven't come across a guide to help in upgrading to MySQL 5.5, I thought why not make one myself

A bit unorthodox, I normally just write about MySQL Cluster here, but I just wanted to understand how much latency semi-sync replication adds.

The test was very simple:

• two mysql servers, interconnected (same switch) on a 1 Gig-E network
• one table (see below)
• comparing insert performance (one thread) with 'no replication at all' and 'semi sync replication enabled'.
  
• bencher (had to hack it a bit to make it work with vanilla mysql) running one thread, inserting 4B+128B+4B = 136B of data

CREATE TABLE `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data` varchar(255) DEFAULT NULL,
`ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `ts` (`ts`)
) ENGINE=InnoDB 

Test 1 - no replication

src/bencher -t1 -r 30   -q "insert into t1(b) …

It is my pleasure to announce that MySQL 5.5 is now GA and ready for production deployment.  You can read Oracle's official press release here.

I am excited about 5.5 because of the performance and scalability gains, new replication enhancements and overall improved technical efficiencies.  Congratulations and a sincere "Thanks!" go out to the entire MySQL Community and product engineering teams for making 5.5 the best release of MySQL to date.

Please join us for today's MySQL Technology …

It is my pleasure to announce that MySQL 5.5 is now GA and ready for production deployment.  You can read Oracle's official press release here.

I am excited about 5.5 because of the performance and scalability gains, new replication enhancements and overall improved technical efficiencies.  Congratulations and a sincere "Thanks!" go out to the entire MySQL Community and product engineering teams for making 5.5 the best release of MySQL to date.

Please join us for today's MySQL Technology Update …

In its "Insight" Research Report from October 2010 "Messages from Oracle OpenWorld 2010: Exadata Exceeds Expectation and MySQL Thrives", IDC Carl W. Olofson notes:

"Last but not least, Oracle announced the MySQL 5.5 release candidate, which solidifies the commitment the company has made to continuing the development and the independence of MySQL as an open source relational DBMS. This announcement came along with continued assurances that MySQL is and will remain autonomous. Nonetheless, useful MySQL intellectual property may find its way into other Oracle products, and Oracle's database development engineers will almost certainly lend their expertise to helping make MySQL better...

...MySQL users should take heart from the 5.5 release candidate and the ongoing support that Oracle has shown to this important open source RDBMS. It is unlikely that Oracle will …

Mark Callaghan over at Facebook wrote a note recently about InnoDB disk IO counters in SHOW STATUS, with some extra things that he wanted to track. I posted a quick comment over there, but I thought this deserved it’s own write up.

MySQL 5.5’s PERFORMANCE_SCHEMA has had a fair bit written about it in terms of tracking synchronization point contention (mutexes etc.), but it currently tracks two orders within the wait class - these are /wait/synch and /wait/io.

Actually, allow me to detour first, it’s not clear from the documentation, though it is clear in the worklog. Each …

UPDATE: An on-demand replay for the webinar discussed below is available here:
http://mysql.com/news-and-events/on-demand-webinars/display-od-572.html

And there is a new whitepaper for MySQL Replication posted here:
http://mysql.com/why-mysql/white-papers/mysql-wp-replication.php

The recent announcement of the MySQL 5.5 Release Candidate included some pretty staggering increases in performance and scalability. 

Replication is also an area where many enhancements have been made including semi-synchronous replication, replication heartbeating, fsync tuning, relay log recovery, per-server replication filtering, etc.

On Tuesday 12th October, Dr. Lars Thalmann who leads the engineering team responsible for the development and implementation of these …