Working with customer, I faced pretty nasty bug, which is actually not rare situation , but in this particular there are some lessons I would like to share. The case is pretty much described in bug 55981, or in pastebin. Everything below is related to InnoDB-plugin/XtraDB, but not to regular InnoDB ( i.e in MySQL [...]
Speaking on San Francisco Meetup 14-Dec : What’s new in XtraDB/InnoDB-plugin 5.1+
November 29, 2010 By Leave a Comment
Erin and Mike, organizers of SF Meetup generously invited me to talk on coming SF Meetup on Dec-14 about new features in InnoDB in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0. Although I personally mostly in 5.1->5.5 upgrade area, Erin insured me that upgrade from MySQL [...]
Percona Server 5.1.50-rel11.4
September 27, 2010 By 1 Comment
Dear Community, Percona Server version 5.1.50-rel11.4 is now available for download. The changes in this release include: New features The primary purpose of this release is to update to the latest version of MySQL 5.1. Percona Server 5.1.50-rel11.4 is now based on MySQL 5.1.50. Fixed bugs innodb_use_sys_stats_table – The
1 | SYS_STATS |
table is now used only [...]
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 [...]
How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
How long it may take MySQL with Innodb tables to shut down ? It can be quite a while. In default configuration innodb_fast_shutdown=ON the main job Innodb has to do to complete shutdown is flushing dirty buffers. The number of dirty buffers in the buffer pool varies depending on innodb_max_dirty_pages_pct as well as workload and [...]
Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
Dear Community, Percona Server version 5.1.47-rel11.0 is available for download now. The changes in this release include: New features Percona Server is now based on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8. XtraDB now uses the fast recovery code released in InnoDB Plugin version 1.0.8, instead of Percona’s earlier fast-recovery code. [...]
MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in tpcc-like workload. The full details are on Wiki page http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data), InnoDB log files are 3.8GB size, and run with different buffer pools from 20GB to [...]
xtrabackup-1.2
April 13, 2010 By 2 Comments
Dear Community, The notice is hereby given that next version 1.2 of XtraBackup software is released. The list of changes in this version includes: Changelog: XtraBackup supports now XtraDB 10 tar4ibd supports variable page size and fast_checksum of XtraDB Supported 32bit platform for Centos 5, Centos 4, Debian lenny and etch, Ubuntu Karmic, Jaunty, Intrepid, [...]
Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
Recently Alexandr announced new Percona-XtraDB-9.1 release, and now it is good time to summarize features we have and what is expected soon. This release contains long waited features from 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10) Extended slow.log is now even more extended, there is additional information for each query:
1 | # Bytes_sent: 4973 Tmp_tables: 1 Tmp_disk_tables: 1 Tmp_table_sizes: 7808 |
That [...]
How many fsync / sec FusionIO can handle
March 4, 2010 By 13 Comments
I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on FusionIO card. It should be easy to test, let’s take sysbench fileio benchmark and run, the next command should make it:
1 | ./sysbench --test=fileio --file-num=1 --file-total-size=50G --file-fsync-all=on --file-test-mode=seqrewr --max-time=100 --file-block-size=4096 --max-requests=0 run |
1 2 3 | Operations performed: 0 Read, 922938 Write, 922938 Other = 1845876 Total Read 0b Written 3.5207Gb Total transferred 3.5207Gb (36.052Mb/sec) 9229.35 Requests/sec executed |
So that’s 9229.35 req/sec, which is pretty impressive. For comparison the same [...]
