by Kenny Gryp | Oct 25, 2011 | MySQL, Percona Events
Even if you didn’t make it to Percona Live London, you can get the chance to hang out with us. We’re giving a reception at the Revolution Bar America Square just a few meters walk from the Tower Hill Underground between 17:30 and 19:30 today (Tuesday 25...
by Baron Schwartz | Oct 21, 2011 | Insight for DBAs, MySQL
Percona Live London starts on Monday, so this is the last in the series of free-Percona-Live tickets we’ll give away. But first — have you ever wondered what servers are in your MySQL replication hierarchy? We have, too. As consultants, a lot of times we...
by Tim.Callaghan | Oct 20, 2011 | MySQL
I’ve been benchmarking and testing TokuDB for a few months now. One goal of benchmarking is to understand what is limiting the performance of a particular configuration. I frequently use “show engine [innodb/tokudb] status;” from within the MySQL...
by Stewart Smith | Oct 16, 2011 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server 5.1.59-13.0 on October 15, 2011 (Downloads are available here). Based on MySQL 5.1.59, including all the bug fixes in it, Percona Server 5.1.59-13.0 is now the current stable release in the 5.1 series. All of...
by Stewart Smith | Oct 16, 2011 | MySQL
Percona is glad to announce the release of Percona Server 5.5.16-22.0 on October 14, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-22.0 is now the current...
by Tokutek | Oct 14, 2011 | MySQL
Review of Thursday’s Cloud Events in Boston Everyone is well aware by now of the EC2 outage that Amazon had back in April and it would have surprised no one if that high profile had put a damper on cloud adoption. But judging what we heard yesterday at Boston’s two...
by Vadim Tkachenko | Oct 13, 2011 | Benchmarks, Insight for DBAs, MySQL, Percona Software
When I mention Galera replication as in my previous post on this topic, the most popular question is how does it affect performance. Of course you may expect performance overhead, as in case with Galera replication we add some network roundtrip and certification...
by Ovais Tariq | Oct 13, 2011 | MySQL
I have been working with a few customer cases and one interesting case popped up. The customer was facing a peculiar problem where the rows column in the EXPLAIN output of the query was totally off. The actual number of rows was 18 times more than the number of rows...
by Vadim Tkachenko | Oct 10, 2011 | Benchmarks, MySQL
As part of work on “High Performance MySQL, 3rd edition”, Baron asked me to compare different MySQL version in some simple benchmark, but on decent hardware. So why not. I took our Cisco UCS C250 and ran simple sysbench oltp read-write all data fits into...
by Frederic Descamps | Oct 10, 2011 | MySQL
Last week I helped 2 different customers with infinite replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them. An infinite...
by Vadim Tkachenko | Oct 7, 2011 | Benchmarks, Insight for DBAs, MySQL, Percona Software
It is known that MySQL due internal limitations is not able to utilize all CPU and IO resources available on modern hardware. Idea is to run multiple instances of MySQL to gain better performance on Fusion-io ioDrive card. Full report is available in PDF For tests we...
by Zardosht.Kasheff | Oct 7, 2011 | MySQL
At next week’s NY Effective MySQL Meetup, I will give a talk: “Understanding Indexing: Three rules on making indexes around queries to provide good performance.” The meetup is 7 pm Tuesday, October 11th, and will be held at Hive at 55 (55 Broad Street, New York, NY)....
by Jervin Real | Oct 6, 2011 | Insight for DBAs, Insight for Developers, MySQL
InnoDB table statistics are used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If a table’s statistics or index cardinality becomes outdated, you might see queries which previously performed well suddenly show...
by Leif.Walsh | Oct 4, 2011 | MySQL
In my last post, we talked about the read/write tradeoff of indexing data structures, and some ways that people augment B-trees in order to get better write performance. We also talked about the significant drawbacks of each method, and I promised to show some more...
by Vadim Tkachenko | Oct 3, 2011 | Insight for DBAs, MySQL, Percona Software
Codership team published beta2 of MySQL 5.5.15 with Galera replication https://launchpad.net/codership-mysql and we made port to Percona Server: source code: lp:~percona-dev/percona-server/percona-server-galera-5.5.15 binaries for RedHat/CentOS 6:...
by Stewart Smith | Oct 3, 2011 | Benchmarks, MySQL, Percona Software
I am very happy to welcome Patrick Crews to the Percona development team. Patrick joins Percona at a very exciting time for the development team. We are getting regular releases of Percona Server and Percona Xtrabackup out the door, we have been heavily using the...
by Stewart Smith | Oct 3, 2011 | Percona Software
We’ve just gone live with a new way of publishing and maintaining documentation for Percona Server and Percona XtraBackup. We are now using Sphinx to generate the documentation that we publish on the web site. Sphinx was originally created for the new Python...
by kuszmaul | Oct 1, 2011 | MySQL
Challenges of Big Databases with MySQL Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes;...
by Peter Zaitsev | Sep 30, 2011 | MySQL, Percona Events
I’m going to be speaking on Highload++ conference October 3,4 in Moscow, Russia. This is a great conference which gathers amazing quality of speakers from Russia and around the world and I usually learn a lot and enjoy talking to a lot of great people on this...
by Baron Schwartz | Sep 30, 2011 | MySQL, Percona Events
It’s Friday again (already?) and as usual, we have a free ticket for Percona Live London. This time Tokutek is doing the honors of running the contest and selecting the winner. Instructions for entering the contest are on their blog, at the top of my recent...
