Percona Server release 5.5.10-20.1 is now available for download. This is a release candidate for the Percona Server 5.5 series. In addition to MySQL 5.5.10 now being the base version, here are the changes that have been made since Percona Server beta release 5.5.8-20.0:
Percona Server and XtraBackup weekly news, March 12th
March 13, 2011 By Leave a Comment
Welcome to the weekly roundup and progress report. What’s new this week in Percona Server:
How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
Among the many things that can cause a “server stall” is a long-running transaction. If a transaction remains open for a very long time without committing, and has modified data, then other transactions could block and fail with a lock wait timeout. The problem is, it can be very difficult to find the offending code [...]
Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my newest Firefox toolbar bookmark: an option and [...]
Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
Dear Community, Starting with this release, we introduce a new release model for Percona Server. From now on, we will have both Stable and Release Candidate releases. Release Candidates will introduce new features not yet available in Stable releases. Along with new features, our new 5.1.49-12.0 RC contains a couple of patches from the Facebook-MySQL [...]
Cache Miss Storm
September 10, 2010 By 30 Comments
I worked on the problem recently which showed itself as rather low MySQL load (probably 5% CPU usage and close to zero IO) would spike to have hundreds instances of threads running at the same time, causing intense utilization spike and server very unresponsive for anywhere from half a minute to ten minutes until everything [...]
Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
Dear Community, Percona Server version 5.1.49-rel11.3 is now available for download. The changes in this release include: New features Percona Server 5.1.49-rel11.3 is based on MySQL 5.1.49. A new variable was introduced: innodb_use_sys_stats_table. If ON, the table’s statistics are stored statically in the internal table SYS_STATS. The table is populated with the ANALYZE TABLE command. [...]
Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores and hard drives the get the larger the difference becomes, as long as replication remains single thread process. At the same time it is a lot easier to optimize your system when your replication runs [...]
How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
A week or so ago at the MySQL conference, I visited one of the backup vendors in the Expo Hall. I started to chat with them about their MySQL backup product. One of the representatives told me that their backup product uses FLUSH TABLES WITH READ LOCK, which he admitted takes a global lock on [...]
The feature I love in TokuDB
June 11, 2009 By 4 Comments
Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State.
1 2 3 4 5 6 7 8 9 10 11 12 | mysql> show processlist; +----+------+-----------+--------+---------+------+---------------------------+-----------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+--------+---------+------+---------------------------+-----------------------------+ | 3 | root | localhost | sbtest | Query | 30 | Updated about 764000 rows | update sbtest set email=zip | ... mysql> show processlist; +----+------+-----------+--------+---------+------+----------------------------+-----------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+--------+---------+------+----------------------------+-----------------------------+ | 3 | root | localhost | sbtest | Query | 79 | Updated about 1900000 rows | update sbtest set email=zip | ... |
(Do not look in stupid UPDATE query, it’s just for testing ) So looking in SHOW PROCESSLIST you can see progress of query execution. I would want to see it in standard MySQL and InnoDB more than all these triggers and [...]
