… specify slow query time in microseconds rather than seconds and allows you to log all queries in slow query log by setting long_query_time=0 This… time. Happily you can change long_query_time without restarting server so it is easy to get sample of all queries for some period of time… query log format as well. Update 2009-03-04: most of us at Percona now use mk-query-digest from Maatkit for slow query…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… 5.1.53. Â New Features Added: Precompiled UDFs for Maatkit (FNV and MurmurHash hash functions to provide faster checksums) are…_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev) Bug #673567 – Compiler could produce…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…one while with MySQL Replication you can use Maatkit to merge the changes after all, also you…choice – you’ve got to pick either long recovery time or further degraded performance. In the large …you’re inserting the data at the same time as running reporting queries on last month. All last month…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…, so everything gets bloated and slow. Even simple SELECT queries might have to scan through lots of obsolete, but … back, it will take a Very Long Time to do — I hate to think how long. I’m sure it would … lines at a time from it. The code is pretty simple and I’ve included it in Maatkit just for …
Comment: What time 18446744073709550.000 means
May 19, 2009 By 25 Comments
… accumulate naturally, it will skew things horribly. These times go negative because they’re very small to begin with; … a single negative-gone-huge-positive. Maatkit has handled these for a long time in mk-query-digest by setting them to zero during…
