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 in theory this benefit comes […]Read more
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 Bug #539190 Percona-XtraDB package doesn’t allow libmysqlclient15off
Fixed Bug #479106 mysql-5.0.87 + patches-5.0.86 compile fail in ubuntu 9.10 (karmic)
Fixed tests mysql, mysql_upgrade, ssl*
See release notes for earlier changes.
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 log entries will be written in a row-based fashion instead of […]Read more
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 restrict that limit.
So how much […]
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 query_database(connection, sql)
if !connection.is_alive() and !connection.reconnect() then
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 use to solve problems as quickly and efficiently as possible. We’ve just posted this […]Read more