Percona Performance Patches
Posted by lopeza on November 15, 2008
Can’t wait for MySQL to release features as they are taking too long. Percona is trying to solve problems for customers today.
Sources:
google patches and Percona in house development.
Diagnostic patches:
Microslow – Microsecond resolution for long_query_time and for query timing
- log queries into slow log even executed less than one second.
- log queries from slave thread as well.
Userstats (from google)
- information_schema.index_statisticks;
- innodb_io_pattern shows what part of tables accessed, can be used to determine working set
- innodb_show _hash_memory where memory is allocated to.
- innodb_show_buffer_pool
- split_buffer_pool_mutex
- innodb_io_patches
Replication:
- Mirror binlogs to make switching slaves less of an arduous task.
Resources:
www.percona.com/docs/diki/devplan:start
www.percona.com/docs/wiki/release:start
