…. Doing so however may affect your performance – updating table with a lot of indexes may … table to MyISAM, disable concurrent inserts and run long reporting query on the log file query execution … entirely in SQL finding most frequent slow query types or queries which load server the most. The …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…example MyISAM slaves used for long reporting queries can have queries running …query chopping making sure all your update queries are short. If you need to update…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…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…have been no updates to our msl patch, …MyISAM), database configuration, load, etc. Configuration There are several parameters related to slow…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…
Comment: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 6, 2009 By 26 Comments
… MyISAM. 2) Given that the indexes were built with a single bulk load, the MyISAM indexes are not fragmented. That makes the MyISAM…-all, and then performs queries. Most workloads involve quite a few insertions or updates. For MyISAM, incremental insertions are slow and produce fragmented indexes…
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: 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… general. Currently MyISAM and Innodb. Some SQL level items as Query Cache also could use this feature. low_priority_updates If enabled selects…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…=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_priority_updates=1 The problem was…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… than MyISAM ? You probably forgot to adjust this value. Default value of 1 will mean each update transaction … not set it too large as it may slow things down as its maintenance may get expensive…. are typically workload specific. If you have simple queries there is no reason to increase sort_buffer…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…_truncate’, ’0′ ‘Com_unlock_tables’, ’102′ ‘Com_update‘, ’15146253′ ‘Com_update_multi’, ’0′ ‘Connections’, ’263413′ ‘Created_tmp_…=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 …=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M …
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…in memory much more records then InnoDB / MyISAM. Actually in internal cache records are stored…queries, as in this case TokuDB has to read and decompress big portion of data. – Despite Inserts and Deletes are fast, updates…random IO, waste of RAM memory and slow inserts. This is where I think Tokutek…
