diff options
author | mattpiwik <matthieu.aubry@gmail.com> | 2013-01-09 08:41:08 +0400 |
---|---|---|
committer | mattpiwik <matthieu.aubry@gmail.com> | 2013-01-09 08:41:08 +0400 |
commit | 0bbfce9c6356f2677bd306ded2d5ea963bd5fad6 (patch) | |
tree | a35bd4a3c6c57f493cfa979a374dbba59db41fac /config | |
parent | 47a9c1f00a3fb91f18a68b64aaed299094688a2e (diff) |
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
git-svn-id: http://dev.piwik.org/svn/trunk@7738 59fd770c-687e-43c8-a1e3-f5a4ff64c105
Diffstat (limited to 'config')
-rw-r--r-- | config/global.ini.php | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/config/global.ini.php b/config/global.ini.php index a85e72aa1f..f1e6f0b2fa 100644 --- a/config/global.ini.php +++ b/config/global.ini.php @@ -147,6 +147,11 @@ enable_browser_archiving_triggering = 1 ; At the moment, this is not needed in core but it can be handy for plugins enable_archive_parents_of_datatable = 0 +; 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 + ; MySQL minimum required version ; note: timezone support added in 4.1.3 minimum_mysql_version = 4.1 |