diff options
| author | Thomas Steur <tsteur@users.noreply.github.com> | 2019-08-16 05:47:33 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-08-16 05:47:33 +0300 |
| commit | 48c9f2c676b4178d8526197af0059bdd7a0f6a72 (patch) | |
| tree | 741dc690fc064d82e5b5ac9e9791518e6468b22c /config | |
| parent | 96b2da83ea4aaa490574cc793e59f38c329b2d3e (diff) | |
Faster segment archiving (#14761)
* use temporary table when segmenting
* still apply original where
* do not apply where twice
* make sure to sort tables correctly
* performance tweak, no longer a where needed in most queries
* fix notice
* have a better cache per date
* small tweaks
* potentially fix an error where we received too many rows
* do not apply any custom force group by
* better handling of log tables to fix some tests
* enable new feature through config
* remove comment
* fix some system tests
* drop table before starting to archive in case archiving fails
* fix more tests
* trying to fix ui test
* save the config change
* use reader when executing ranking queries
* apply review feedback
* drop table only if it actually exists to prevent problems on a reader
* Update JoinGenerator.php
Diffstat (limited to 'config')
| -rwxr-xr-x | config/global.ini.php | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/config/global.ini.php b/config/global.ini.php index 56fd553f2d..663e19f317 100755 --- a/config/global.ini.php +++ b/config/global.ini.php @@ -208,6 +208,12 @@ enable_processing_unique_visitors_multiple_sites = 0 enabled_periods_UI = "day,week,month,year,range" enabled_periods_API = "day,week,month,year,range" +; whether to enable segment archiving cache +; Note: if you use any plugins, this need to be compliant with Matomo and +; * depending on the segment you create you may need a newer MySQL version (eg 5.7 or newer) +; * use a reader database for archiving in case you have configured a database reader +enable_segments_cache = 1 + ; whether to enable subquery cache for Custom Segment archiving queries enable_segments_subquery_cache = 0 ; Any segment subquery that matches more than segments_subquery_cache_limit IDs will not be cached, |