Posted by Maciej Dobrzanski |
Microslow patch has been there for some time, but only for earlier…a lot of internal changes, the
patch had to be written from …_time=n or by setting
MySQL system variable with SET [SESSION|… can be achieved by running
MySQL with startup time parameter –log-…
Posted by Maciej Dobrzanski |
… across this piece of code. msl (
microslow)
patch was developed a few years…=/usr/share’ ‘–localstatedir=/var/lib/
mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr…=/usr/share’ ‘–localstatedir=/var/lib/
mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/…
Posted by
Maciej Dobrzanski @ 5:38 am ::
patch ::
Posted by Vadim |
… added one more RPM to stantard
MySQL RPMs –
MySQL-
microslow-5.0.33-0.glibc23….
microslow binary, the server built with our
microslow patch, which enables microsecound in slow-log.
More info about the
patch
http://www.mysqlperformanceblog.com/2006/09/06…
Posted by Vadim |
…turn on / off query statistics for
microslow patch and user statistics in …slow_query_log_file | /var/lib/
mysql/slow_query.log |
for compatibility … performance penalties of using of
patches.
Also we fixed potential memory …
Posted by Maciej Dobrzanski |
…This is the original functionality offered by
Microslow patch. The new edition is free of a… OF THE REPLICATED STATEMENTS
Normally
MySQL will not write into slow log any …
Important note: Although the
patch was tested and run successfully under …
Posted by Maciej Dobrzanski |
Vadim asked me yesterday to update
Microslow patch for 5.1.21, because … failed to apply correctly on the new
MySQL release. Imagine the expression on my face after I unpacked the sources and found out that
MySQL incorporated the
patch to their release. So …
Posted by
Maciej Dobrzanski @ 11:08 pm ::
patch ::
Posted by Maciej Dobrzanski |
… some functionalities from Mark Callaghan’s
MySQL patch bundle. They were extensions …_transactions: 0
Rollback_transactions: 0
mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’;
… under Other_commands
a few
MySQL performance counters broken down by …
Posted by
Maciej Dobrzanski @ 3:59 am ::
patch ::
Posted by Vadim |
… Percona | GPL | Ported from Debian |
|
microslow_innodb.
patch | Extended statistics in slow.log… of query execution with microseconds granularity.
mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
…
Posted by
Vadim @ 3:32 pm ::
release ::
Posted by Aleksandr Kuzminsky |
…
When people think about Percona’s
microslow patch immediately a question arises how …a second to execute;
logging every query;
MySQL was run with default settings except … here that logging all queries decreases
MySQL’s performance on 6-20% depending …
Posted by
Aleksandr Kuzminsky @ 11:46 am ::
benchmarks ::
Posted by Vadim |
…
- Reimplemented read-write locks
Diagnostic
patches.
– We provide much more statistics in …
patch
Different
patches to help with day to day usage of
MySQL ®…, which alredy fixed in percona-
patches ( and in XtraDB and InnoDB-plugin …
29-30 Jul
del.icio.us
digg