As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had… if I convert table to MyISAM, disable concurrent inserts and run long reporting query on the log file query execution is still proceeds… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… longer to close than MyISAM), database configuration, load, etc. Configuration There are several parameters related to slow log you can …slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the client is doing queries like “… WHERE… 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…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… Slave expect lag spike. For example MyISAM slaves used for long reporting queries can have queries running for hours which stalls replication progress… MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can get with our Slow Query Log…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…storage engines transaction logs, slow query log or general log. flush, flush_time Flushing (closing) of tables after query is complete or every… ft_query_expansion_limit, ft_stopword_file FullText search related variables. As FullText currently works with MyISAM tables these are MyISAM related. join…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…) Could you explain the difference between MyISAM and InnoDB table cache? 3) Would converting the MyISAM tables to InnoDB fix or help… = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql…_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… set to 40000? 2) Could you explain the difference between MyISAM and InnoDB and the difference in how the OS handles… = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql…_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… are specifics from one system. It has exactly one table. MYISAM table with the following activity: Per day: 1. INSERTS: 1…=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…_size = 80 query_cache_size = 32M thread_concurrency = 8 query_cache_type = 1 query_cache_limit = 32M thread_stack=256K myisam_data_pointer_size=6 net_buffer_length = 8K log-slow-queries=/var/lib/mysql/astdb01.as.osti.local-slow.log log…
