We made new patches, improved previous and want to announce new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two branches.
First, just “-percona” release is more stable and contains only stable and proven on many installation patches. Second is “-percona-highperf” release, which contains experimental patches that can improve performance significantly. On this stage “percona-highperf” contains patches from Yasufumi Kinoshita (more info on Maximum performance of OLTP benchmark is not so scalable on multi-cpu.
Most important patch “split_buf_pool_mutex” to separate InnoDB buffer->pool mutex into several, and it allows to get 1.5x – 2.5x improvements in DBT2 benchmarks on 8cores boxes (benchmark results is coming and will be published)
For all three versions we added SHOW PATCHES command, which is based on Jeremy Cole’s patch
|
1 2 3 4 5 6 7 8 9 10 11 12 |
mysql> show patches; +--------------------------------------------------+--------------------------------------------------------+---------+----------------------------+---------+---------------------------------------+ | File | Name | Version | Author | License | Comment | +--------------------------------------------------+--------------------------------------------------------+---------+----------------------------+---------+---------------------------------------+ | control_flush_and_merge_and_read.patch | InnoDB patch to control insert buffer and flushing | 1.0 | Yasufumi Kinoshita | BSD | | | mysqld_safe_syslog.patch | Patch allows redirect output of error.log to syslog-ng | 1.0 | Percona <info@percona.com> | GPL | Ported from Debian | | microslow_innodb.patch | Extended statistics in slow.log | 1.0 | Percona <info@percona.com> | GPL | | | split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | | | control_io-threads.patch | InnoDB patch to control count of IO threads | 1.0 | Yasufumi Kinoshita | BSD | | | userstats.patch | SHOW USER/TABLE/INDEX statistics | 1.0 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole | N/A | | +--------------------------------------------------+--------------------------------------------------------+---------+----------------------------+---------+---------------------------------------+ |
Next, we added tables USER_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS to INFORMATION_SCHEMA
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
mysql> select * from information_schema.table_statistics; +-------------------------+-----------+--------------+----------------------+ | TABLE_NAME | ROWS_READ | ROWS_CHANGED | ROWS_CHANGED_INDEXES | +-------------------------+-----------+--------------+----------------------+ | art86.forum86 | 469084 | 54 | 162 | | mysql.db | 36 | 0 | 0 | | art57.link_out57 | 59336163 | 82549 | 577843 | | art116.author116 | 1921596 | 1581 | 3162 | | art54.link_out54 | 36879450 | 23830 | 166810 | | art104.author104 | 1100203 | 2572 | 5144 | | art107.forum107 | 820296 | 56 | 168 | | art104.forum104 | 771121 | 63 | 189 | | art111.article111 | 44100332 | 16411 | 164110 | | art93.thread_stats93 | 442440 | 9495 | 18990 | ... |
For 5.0-percona-highperf release we added:
5.1 release
Contains build-in InnoDB plugin, so there is no more needs to download InnoDB separately, install it and run mysql with option –skip-innodb.
We think InnoDB plugin is stable enough to use it with MySQL 5.1 RC, at least stable to name whole MySQL-5.1-percona release as RC.
Along with previously mentioned patches, to 5.1 we added new column TIME_MS to
INFORMATION_SCHEMA.PROCESSLIST which contains time of query execution with microseconds granularity.
|
1 2 3 4 5 6 7 |
mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; +----+------+-----------+------+---------+------+-----------+----------------------------------------------+---------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | +----+------+-----------+------+---------+------+-----------+----------------------------------------------+---------+ | 1 | root | localhost | NULL | Query | 0 | executing | SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST | 0.607 | +----+------+-----------+------+---------+------+-----------+----------------------------------------------+---------+ 1 row in set (0.00 sec) |
On our release page
you can find links to RPMS for RedHat 4/5, binary tar.gz, source tar.gz (source contains source code with applied patches, so you can just download it and compile) and just raw patches.
Resources
RELATED POSTS
