by Peter Zaitsev | Oct 30, 2009 | Percona Events
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...
by Vadim Tkachenko | Oct 27, 2009 | Insight for DBAs, MySQL
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...
by Vadim Tkachenko | Oct 26, 2009 | Benchmarks, MySQL
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...
by Aleksandr Kuzminsky | Oct 25, 2009 | MySQL, Percona Software
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. $...
by Aleksandr Kuzminsky | Oct 24, 2009 | MySQL, Percona Software
Dear Community, As of today release 0.9.5rc is available. In this release there are following changes: Changelog: Option –no-lock is added to innobackupex-1.5.1. Use it only while ALL your tables are InnoDB and you DO NOT CARE about binary log position of backup...
by Baron Schwartz | Oct 23, 2009 | MySQL, Percona Events
It’s time to announce our plans for Percona Performance Conference 2010. We will hold the event on April 12th and 13th in Santa Clara, California. In the months to come we will announce the theme, the exact location (we have it reserved, but it’s subject...
by Vadim Tkachenko | Oct 20, 2009 | Percona Events
After many complains we removed captcha in comments and replaced to Anti-Captcha ( http://wordpress.org/extend/plugins/anti-captcha/). Now you need enabled JavaScript in your browser to post comments.
by Matt Yonkovit | Oct 19, 2009 | Benchmarks, Cloud, MySQL
This is part 3 of our series. In part 1 we talked about boosting performance with memcached on top of MySQL, in Part 2 we talked about running 100% outside the data with memcached, and now in Part 3 we are going to look at a possible solution to free you from the...
by Tokutek | Oct 16, 2009 | MySQL
At Tokutek, Rich Prohaska used Gearman to automate our nightly build and test process for TokuDB for MySQL. Rich is busy working on TokuDB, so I’m writing up an overview of the build and test architecture on his behalf. Build and Test Process Rich created a...
by Yves Trudeau | Oct 16, 2009 | Insight for DBAs, MySQL
After having reviewed the definition my the previous post (The definitions), the next step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it is skipped. It can also be formulated “What is the...
by Morgan Tocker | Oct 16, 2009 | MySQL, Percona Events
I wanted to provide an update on two things: Firstly, we have opened registration for InnoDB/XtraDB training in Los Angeles (Nov 18th). The second is that while I am in New York City for training (Oct 29th), I’ll be giving a (free) talk at the MySQL Meetup group...
by Morgan Tocker | Oct 16, 2009 | Insight for DBAs, MySQL
I’ve seen a few people link to an INFORMATION_SCHEMA query to be able to find any indexes that have low cardinality, in an effort to find out what indexes should be removed. This method is flawed – here’s the first reason why: CREATE TABLE `sales`...
by Matt Yonkovit | Oct 16, 2009 | Benchmarks, Cloud, MySQL
Part 1 of our series set-up our “test” application and looked at boosting performance of the application by buffer MySQL with memcached. Our test application is simple and requires only 3 basic operations per transaction 2 reads and 1 write. Using...
by Matt Yonkovit | Oct 15, 2009 | Benchmarks, Cloud, MySQL
All to often people force themselves into using a database like MySQL with no thought into whether if its the best solution to there problem. Why? Because their other applications use it, so why not the new application? Over the past couple of months I have been...
by Yasufumi Kinoshita | Oct 14, 2009 | Benchmarks, Insight for DBAs, MySQL
For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, <tuning...
by Baron Schwartz | Oct 14, 2009 | MySQL, Percona Events
On the heels of our earlier announcement of Fernando and Yves, I’m happy to welcome Devananda van der Veen to our team. Devananda, also known as Deva, is a talented, detail-oriented MySQL expert and systems administrator. His previous job was at Hydra, an...
by Peter Zaitsev | Oct 14, 2009 | Insight for DBAs, MySQL
Resolving extreme database overload for the customer recently I have found about 80 copies of same cron job running hammering the database. This number is rather extreme typically the affect is noticed and fixed well before that but the problem with run away cron jobs...
by Aleksandr Kuzminsky | Oct 12, 2009 | MySQL, Percona Software
Dear Community, We are glad to present you release 8 of XtraDB. The release includes following new features: The release is base on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4 MySQL...
by Aleksandr Kuzminsky | Oct 12, 2009 | MySQL, Percona Software
Dear Community, As of today the 19-th build of MySQL server with Percona patches is available. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.86 Fix from Neil Katin to userstatv2.patch fix InnoDB slowness with large...
by Ryan Lowe | Oct 12, 2009 | Percona Events
Videos from the 2009 Percona Performance Conference are now available on Percona Videos. Let us know which you like best so we can have some ideas for the 2010 conference!
