by Maciej Dobrzanski | May 17, 2010 | Insight for Developers, MySQL
The problem I am going to describe is likely to be around since the very beginning of MySQL, however unless you carefully analyse and profile your queries, it might easily go unnoticed. I used it as one of the examples in our talk given at phpDay.it conference last...
by Peter Zaitsev | May 14, 2010 | Insight for DBAs, MySQL
Upgrading from MySQL 5.0 to MySQL 5.1 or Percona Server 5.1 you may run into issues with mysql_upgrade – it will identify some tables to be upgraded and will attempt to run REPAIR TABLE for them. This will fail with “The storage engine for the table...
by kuszmaul | May 11, 2010 | MySQL
I just spotted the youtube video of my OpenSQL Camp (Portland 2009) talk on An Open Storage Engine API. I talked about some of technical issues for implementing storage engines across many SQL front ends, not just MySQL. You can find this talk and other mostly...
by Peter Zaitsev | May 10, 2010 | Insight for Developers, MySQL
In comments to my previous post I got number number of comments saying if MySQL would not have multiple storage engine interface it would not allow people to do various very cool stuff. And I agree with this. The question is how cool you want your database operation...
by Vadim Tkachenko | May 10, 2010 | Benchmarks, Hardware and Storage, MySQL
I wrote about FlashCache there, and since that I run couple benchmarks, to see what performance benefits we can expect. For initial tries I took sysbench oltp tests ( read-only and read-write) and case when data fully fits into L2 cache. I made binaries for FlashCache...
by Peter Zaitsev | May 8, 2010 | Insight for DBAs, MySQL
One of the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view it is indeed great to provide users with same top level SQL interface allowing them to store their data many different way. As nice as it sounds the...
by Aleksandr Kuzminsky | May 7, 2010 | MySQL, Percona Software
Dear Community, Percona Server 5.0.90, release 21 is available for use. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.90 Fixed bugs: Fixed Bug #539190 Percona-XtraDB package doesn’t allow libmysqlclient15off...
by Justin Swanhart | May 6, 2010 | Insight for DBAs, MySQL
MySQL 5.1 introduces row-based binary logging. In fact, the default binary logging format in GA versions of MySQL 5.1 is ‘MIXED’ STATEMENT*; The binlog_format variable can still be changed per sessions which means it is possible that some of your binary...
by Peter Zaitsev | May 6, 2010 | Insight for DBAs, MySQL
The amount of memory Innodb will require for its data dictionary depends on amount of tables you have as well as number of fields and indexes. Innodb allocates this memory once table is accessed and keeps until server is shut down. In XtraDB we have an option to...
by Baron Schwartz | May 5, 2010 | Insight for Developers, MySQL
It is very common for me to look at a customer’s database and notice a lot of overhead from checking whether a database connection is active before sending a query to it. This comes from the following design pattern, written in pseudo-code: function...
by kuszmaul | May 4, 2010 | MySQL
Here are the slides and video for my MySQL UC ignite talk on measuring the performance of SSDs. You can find this talk and other mostly technical material here. This research was funded in part by the National Science Foundation.
by Baron Schwartz | May 4, 2010 | MySQL, Percona Events
If you were at last month’s MySQL conference, you might have seen a small flyer we were distributing, titled “A brief introduction to Goal-Driven Performance Optimization.” This is a super-compressed technical introduction to one of the methods we...
by Peter Zaitsev | Apr 30, 2010 | Cloud, MySQL
Another thing I find interesting about MongoDB is its approach to Durability, Data Consistency and Availability. It is very relaxed and will not work for some applications but for others it can be usable in current form. Let me explain some concepts and compare it to...
by Peter Zaitsev | Apr 30, 2010 | Cloud, MySQL
I went to MongoSF today – quite an event, and I hope to have a chance to write more about it. This post is about one replication problem and how MongoDB solves it. If you’re using MySQL Replication when your master goes down it is possible for some writes...
by kuszmaul | Apr 30, 2010 | MySQL
I recently discovered that there’s a youtube video of the talk I gave at OpenSQL Camp in Portland in 2009. This is a whiteboard presentation and is less well developed than the talk I gave a the MySQL conference (I posted those slides two days ago. But since it...
by Vadim Tkachenko | Apr 29, 2010 | MySQL, Percona Events
Percona wants to upgrade our documentation to improve its readability and to make it more useful for you, our clients and partners. We are so busy developing software and handling your needs that we have trouble finishing all the documentation! We think you can help....
by Michael Rikmas | Apr 29, 2010 | Percona Events
The Percona team participated at this year’s O’Reilly MySQL Conference & Expo held April 12-15, 2010 in Santa Clara, California. We gave a lot of talks on various topics and all of those presentations are now available. Here’s the list: Achieving...
by kuszmaul | Apr 28, 2010 | MySQL
Here’s the talk I presented at the MySQL User Conference. This talk is a fairly technical talk on how fractal trees work. You can find this talk and other mostly technical material at http://www.tokutek.com/technology/.
by Vadim Tkachenko | Apr 27, 2010 | Hardware and Storage, MySQL
As I mentioned in my talk An Overview of Flash Storage for Databases I see in the near and middle term future a lot of interest for using Flash storage in Level 2 caching level. The price-capacity trade-off makes Flash as the very good fit for a cache layer. Actually...
by Vadim Tkachenko | Apr 26, 2010 | MySQL, Percona Software
I did some drawing exercise and put XtraDB / InnoDB internals in Visio diagram: The XtraDB differences and main parameters are marked out. PDF version is there https://www.percona.com/docs/wiki/percona-xtradb:internals:start.
