We made new binaries for MySQL 5.0.67 build 10 which include next fixes:
- We addressed concerns about potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime.
Next variables were added:
| slow_query_log | ON |
| slow_query_log_file | /var/lib/mysql/slow_query.log |
for compatibility with MySQL 5.1
| userstat_running | OFF |
to control gathering of user statistics.
With both slow_query_log = OFF and userstat_running = OFF we have no performance penalties of using of patches.
- Also we fixed potential memory leaks in microslow and userstats patches, the leak appeared under some workloads.
The -percona release includes:
| innodb_check_defrag.patch | Session status to check fragmentation of the last InnoDB scan | 1.0 | Percona <email@example.com> | GPL | The names are Innodb_scan_* |
| userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS |
| show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole | N/A | |
| innodb_io_patches.patch | Cluster of past InnoDB IO patches | 1.0 | Percona | GPL | This patch contains fixed (control_flush_and_merge_and_read, control_io-threads, adaptive_flush) |
| innodb_show_hashed_memory.patch | Adds additional information of InnoDB internal hash table memories in SHOW INNODB STATUS | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
| innodb_io_pattern.patch | Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona <email@example.com> | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN |
| microsec_process.patch | Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
| innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz <email@example.com> | GPL | Bug #29126 fix |
| microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona <firstname.lastname@example.org> | GPL | |
| mysqld_safe_syslog.patch | Patch allows redirect output of error.log to syslog-ng | 1.0 | Percona <email@example.com> | GPL | Ported from Debian |
| innodb_fsync_source.patch | Information of fsync callers in InnoDB | 1.0 | Google | GPL | |
| innodb_show_bp.patch | show innodb buffer pool content | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
and -percona-highperf release additionaly includes
| split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | |
| innodb_rw_lock.patch | Fix of InnoDB rw_locks | 1.0 | Yasufumi Kinoshita | BSD |
You can download RPMs for RedHat / CentOS 4.x and 5.x for x86_64, binaries, sources and patches there
OurDelta builds of this should becoming soon.