You searched for micro slow patch - Page 2 of 4

MySQL Binaries Percona build10

December 11, 2008 By Vadim Tkachenko 12 Comments

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 [...]

Filed Under: Percona Software Tagged With: Patches, Percona

How Percona does a MySQL Performance Audit

November 24, 2008 By Baron Schwartz 17 Comments

Our customers or prospective customers often ask us how we do a performance audit (it’s our most popular service). I thought I should write a blog post that will both answer their question, so I can just reply “read all about it at this URL” and share our methodology with readers a little bit. This [...]

Filed Under: Insight for Developers Tagged With: Tuning

Percona build7 with latest patches

November 14, 2008 By Vadim Tkachenko 26 Comments

We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes:

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

You can download RPMs for RedHat / CentOS 4.x and 5.x for x86_64, binaries, sources and patches there

Filed Under: Percona Software Tagged With: Patches, Percona, Release

Four ways to optimize paginated displays

September 24, 2008 By Baron Schwartz 27 Comments

A paginated display is one of the top optimization scenarios we see in the real world. Search results pages, leaderboards, and most-popular lists are good examples. You know the design pattern: display 20 results in some most-relevant order. Show a “next” and “previous” link. And usually, show how many items are in the whole list [...]

Filed Under: Insight for Developers Tagged With: Tips

Finding what Created_tmp_disk_tables with log_slow_filter

September 22, 2008 By Ewen Fortune 3 Comments

Whilst working with a client recently I noticed a large number of temporary tables being created on disk.

show global status like 'Created_tmp%'
| Created_tmp_disk_tables           | 91970        |
| Created_tmp_files                 | 19624        |
| Created_tmp_tables                | 1617031      |

show global status like 'Created_tmp%'

| Created_tmp_disk_tables | 91970 |

| Created_tmp_files | 19624 |

| Created_tmp_tables | 1617031 |

Filed Under: Percona Software Tagged With: Production

New patches, new builds

September 5, 2008 By Vadim Tkachenko 24 Comments

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 [...]

Filed Under: Percona Software Tagged With: Release

Percona RPMS for RedHat 5 / CentOS 5 x86_64

July 31, 2008 By Vadim Tkachenko 4 Comments

We prepared RPMs of our release for RedHat 5 / CentOS 5 x86_64 platform. http://www.mysqlperformanceblog.com/mysql/RPM/RHEL5/5.0.62/ There was question what patcheset includes and if there is manuals. We have: microsecond resolution in slow-log extended query plan in slow-log and InnoDB statistics. You can read more here http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/ User / Table / Index statistics (Google’s patch). More [...]

Filed Under: Percona Software Tagged With: InnoDB, Percona, Production

Percona builds with Percona patchsets

July 16, 2008 By Vadim Tkachenko 35 Comments

Percona has a strong team of MySQL developers and consultants on board, so we decided to prepare builds with our patches and third-party patches which we think are very useful. We actually use these internally and for our customers. Current releases include: microslow patch (enables microsecond resolution in slow logs) execution plan (show info about [...]

Filed Under: Percona Software Tagged With: Percona, Production

MySQL extensions for hosting

April 24, 2008 By Maciej Dobrzanski 11 Comments

A few weeks ago I was asked to isolate some functionalities from Mark Callaghanâ€™s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically check what data [...]

Filed Under: Percona Software Tagged With: Patches

Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By Maciej Dobrzanski 17 Comments

For a couple of months there have been no updates to our msl patch, however recently I managed some time to change this. The functionality was extended a little bit and whatâ€™s even more important the patch is available for all the recent MySQL releases. To remind anyone who has not yet come across this [...]

Filed Under: Percona Software Tagged With: Patches

MySQL Binaries Percona build10

How Percona does a MySQL Performance Audit

Percona build7 with latest patches

Four ways to optimize paginated displays

Finding what Created_tmp_disk_tables with log_slow_filter

New patches, new builds

Percona RPMS for RedHat 5 / CentOS 5 x86_64

Percona builds with Percona patchsets

MySQL extensions for hosting

Updated msl (microslow) patch, installation walk-through!

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA