MySQL Binaries Percona build10

December 12, 2008

Author

Vadim Tkachenko

Percona Software

Share this Post:

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
and 
| userstat_running                | OFF                                          | 
to control gathering of user statistics.

| slow_query_log | ON |

| slow_query_log_file | /var/lib/mysql/slow_query.log |

for compatibility with MySQL 5.1

and

| 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 &lt;info@percona.com&gt;       | 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 &lt;info@percona.com&gt;       | GPL     |                                                                                                  | 
| innodb_io_pattern.patch                          | Information schema table of InnoDB IO counts for each datafile pages                     | 1.0     | Percona &lt;info@percona.com&gt;       | GPL     | INFORMATION_SCHEMA.INNODB_IO_PATTERN                                                             | 
| microsec_process.patch                           | Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column                                   | 1.0     | Percona &lt;info@percona.com&gt;       | GPL     |                                                                                                  | 
| innodb_locks_held.patch                          | Add locks held, remove locked records in SHOW INNODB STATUS                              | 1.0     | Baron Schwartz &lt;baron@xaprb.com&gt; | GPL     | Bug #29126 fix                                                                                   | 
| microslow_innodb.patch                           | Extended statistics in slow.log                                                          | 1.1     | Percona &lt;info@percona.com&gt;       | GPL     |                                                                                                  | 
| mysqld_safe_syslog.patch                         | Patch allows redirect output of error.log to syslog-ng                                   | 1.0     | Percona &lt;info@percona.com&gt;       | 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 &lt;info@percona.com&gt;       | 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     |

1 2	\| 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 \|