…user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or … option, or between using the plugin or enabling the general log. Bear in mind these …”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… you have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02… pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option ….commanual enable_lockingblogpercona.commanual enable_named_pipeblogpercona.commanual enable_…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… option to enable logging queries which do not use indexes even if they take less time (–log-queries-not-using-indexes) Slow query log is… log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log by… across same slow query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
…-of-queries=1000000 –concurrency=64″ on my laptop) come out at the following: straight MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15 seconds straight Drizzle (no slow query log): 8…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… do in MySQL 5.0 and below ? Use Our Patch – With this patch you can get all queries logged as slow queries (with times) and as you can change long-query-time online you can effectively enable and disable… connects or queries with syntax errors will not be logged. Enable logging to /dev/null You can enable queries to say “all_queries” log and…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query: mysql [localhost] …| INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes… Very welcome change ! thread_cache_size is enabled by default, though I wonder why …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL… | | query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query …Query Cache How does metadata locking behave with query_cache? That is an important question. If Query Cache is enabled…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
…response time of their top slow query according to pt-query-digest’s report. This query was run very frequently…, I wanted to know more about how MySQL executes this query. So I used commands you’re …for contention issues was the query cache as it was enabled. Contention on the query cache mutex when …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated… get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018… Server, enabled full query logging and log_slow_verbosity=full you can also get great amount of related data from mk-query-digest report…
