http://www.mysqlperformanceblog.com Everything about MySQL Performance Fri, 06 Nov 2009 06:21:03 +0000 http://backend.userland.com/rss092 en This is next post in series Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB Air traffic queries in InfiniDB: early alpha Let me explain the reason of choosing these engines. After initial three posts I am often asked "What is baseline ? Can we compare results with standard ... http://www.mysqlperformanceblog.com/2009/11/05/air-traffic-queries-in-myisam-and-tokutek-tokudb/ We've been busy expanding our training curriculum to include training for developers building applications with MySQL.  We have reached the point where we're ready for a pilot teach - and it brings me great pleasure to announce that we're opening it up for blog readers to attend, free of charge. The ... http://www.mysqlperformanceblog.com/2009/11/05/new-developers-training-course-is-almost-ready/ One problem made me puzzled for couple hours, but it was really interesting to figure out what's going on. So let me introduce problem at first. The table is [code] CREATE TABLE `c` ( `tracker_id` int(10) unsigned NOT NULL, `username` char(20) character set latin1 collate latin1_bin NOT NULL, `time_id` ... http://www.mysqlperformanceblog.com/2009/11/05/innodb-look-after-fragmentation/ As Calpont announced availability of InfiniDB I surely couldn't miss a chance to compare it with previously tested databases in the same environment. See my previous posts on this topic: Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries in LucidDB I could not run all queries against InfiniDB and I met ... http://www.mysqlperformanceblog.com/2009/11/02/air-traffic-queries-in-infinidb-early-alpha/ A recent photo from Highload.ru I said in my last post, that we're interested in speaking at MySQL meetups, and I'm happy to say that the Los Angeles MySQL Meetup has taken us up on the offer. On November 18th, I'll be giving an introductory talk on InnoDB/XtraDB Performance Optimization.  I will ... http://www.mysqlperformanceblog.com/2009/11/01/speaking-at-the-la-mysql-meetup-18th-november/ MariaDB project kept development going in the repository only not providing any binary releases since April, so release was well over due and it is here now. If you're wondering how this release of MariaDB is different from MySQL you should read this FAQ http://www.mysqlperformanceblog.com/2009/10/30/new-mariadb-release-is-out/ I'm going to give a talk on Goal Driven Performance Optimization next Tuesday. This is one of my favorite talks as it goes beyond MySQL to the principles you can apply to performance optimizations of the complex systems, especially when you have to do a lot in limited ... http://www.mysqlperformanceblog.com/2009/10/30/giving-a-talk-in-palo-alto-november-3rd/ First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting "Galera: Multi-Master Synchronous MySQL Replication Clusters". It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the bottom of the list, as this is very hard to ... http://www.mysqlperformanceblog.com/2009/10/27/state-of-the-art-galera-synchronous-replication-for-innodb/ After my first post Analyzing air traffic performance with InfoBright and MonetDB where I was not able to finish task with LucidDB, John Sichi contacted me with help to setup. You can see instruction how to load data on LucidDB Wiki page You can find the description of benchmark in original ... http://www.mysqlperformanceblog.com/2009/10/26/air-traffic-queries-in-luciddb/ For those who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How to use it. First make sure it is avaiable. [code]$ ec2-describe-images ami-4701e22e IMAGE   ami-4701e22e    xtradb/centos-5.3-x86_64.fs.manifest.xml        834362721059    available       ... http://www.mysqlperformanceblog.com/2009/10/25/xtradb-amazon-image/