… MySQL manual, especially the option …Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log….commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona….
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… spend a lot of time looking at this. For one thing, all the values are in big units, so it’s hard… -lt slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
…time (about 160ms). Of course, I wanted to know more about how MySQL executes this query…000035 | | logging slow query | 0.000004 | | cleaning up | 0.000005 | +———————-+———-+ So the unstable response times…query_cache_min_res_unit variable (4KB by default). For the query…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…time recovery, but at the same time you should not have hardware RAID or have one without battery backed up cache (BBU unit…strange behavior on 5.0 of MySQL being slow but few queries being “inside innodb” and … you would normally see single outstanding log write all the time. There are other ways …
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…-generation code seemed very, very slow I just like the randgen (…log/randgen.out: $ tail workdir/bot0/log/randgen.out # 2011-12-21T14:25:02 bindir is mysql… produce the same queries and data (there are unit tests to monitor this… tests that take a –seed=time argument to give wider coverage. However…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…it would only work for one unit of work? A: Yes, if …MySQL database for persistence, but when we measured query load with pt-query-digest, we found that 30% of the database response time…. Q: If a slave is slow because of bandwidth issues, the …, if there are more binary logs yet to download. This can…
