Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Loading…

Allow disable OPTIMIZE TABLE queries in config file #3657

Closed
mattab opened this Issue · 1 comment

1 participant

@mattab
Owner

Some very high traffic user reports that the OPTIMIZE TABLE query run at the end of the log purge, is causing trouble and sql queries queuing. We should at least allow to disable the OPTIMIZE queries via config file setting,

and the proper ultimate fix will be to have Piwik not require Mysql for tracking anymore SEE #3632

@mattab
Owner

in [7738] fixing #3657 NEW config setting

; By default Piwik runs OPTIMIZE TABLE SQL queries to free spaces after deleting some data.
; If your Piwik tracks millions of pages, the OPTIMIZE TABLE queries might run for hours (seen in "SHOW FULL PROCESSLIST \g")
; so you can disable these special queries here:
enable_sql_optimize_queries = 1

@mattab mattab added this to the 1.10 - Piwik 1.10 milestone
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.