Unsupported Screen Size: The viewport size is too small for the theme to render properly.

4.7-3 Slow Query Log Analyzer – Slow From Table?

forums › forums › Monyog › Using Monyog › 4.7-3 Slow Query Log Analyzer – Slow From Table?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • October 3, 2011 at 2:31 pm #12468
      Van Jr
      Member

      Version 4.7-3

      Why does it take so long for the slow query analyzer to analyze from a TABLE vs a FILE?

    • October 3, 2011 at 3:02 pm #32700
      Van Jr
      Member

      I found why:

      See: http://dev.mysql.com/doc/refman/5.5/en/log-destinations.html

      MySQL wrote:

      By default, the log tables use the CSV storage engine that writes data in comma-separated values format. For users who have access to the .CSV files that contain log table data, the files are easy to import into other programs such as spreadsheets that can process CSV input.

      The log tables can be altered to use the MyISAM storage engine. You cannot use ALTER TABLE to alter a log table that is in use. The log must be disabled first. No engines other than CSV or MyISAM are legal for the log tables.

      To disable logging so that you can alter (or drop) a log table, you can use the following strategy. The example uses the general query log; the procedure for the slow query log is similar but uses the slow_log table and slow_query_log system variable.

      There are NO indexes on the log tables. So, I altered mysql.slow_log to be MyISAM and created index START_TIME_IDX on START_TIME.

      That helped some.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.