… There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_…tools to detect memory leaks like valgrind are too slow to run in production. So the best thing … leak and when it can be found and fixed. This is where your MySQL Support contract can …
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… last week, so we are a little slow to blog about this and acknowledge the …much faster with the binary log enabled Faster queries through speedier joins, faster subqueries, and elimination …example, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log… 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: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had… this feature as it is incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying 100% compatible… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time… 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… created because of blob columns being accessed by the query. So a quick fix here could be to instead of selecting every…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew… be fixed first to make the greatest impact to this page response time. I can also convert that into a slow query log that lists all the queries that were executed during this session in the order they were executed: mk-query-digest…
Post: Finding what Created_tmp_disk_tables with log_slow_filter
September 22, 2008 By 3 Comments
… feature, the ability to log queries by execution plan. log_slow_filter=name Log only the queries that followed certain execution plan. Multiple… collection. SET GLOBAL log_slow_filter:=”"; Then it was just a question of examining the slow query log and fixing the queries. More information about…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… on the system as a whole. The queries the system runs, and hence the slow query log, is one of the more fruitful… 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… so they can decide which things to have us fix, which to fix themselves, and which to just ignore. The above process…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… 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… both slow_query_log = OFF and userstat_running = OFF we have no performance penalties of using of patches. Also we fixed potential memory…
Post: mk-query-digest, query comments and the query cache
… files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, including mk-query-digest. This tool, in… every query is unique and the query cache will use additional resources for no effective benefit. Luckily the problem is mostly* fixed in…