You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello.
My motomo version 3.3.0 and PHP 7.1.24
My matomo mysql db size is 400GB. I want clear a part of my db. I need delete 2015 year and part of 2016.
I go to console and do next command: ./console core:delete-logs-data --dates=2016-02-01,2016-02-31
and view next result:
Preparing to delete all visits belonging to ALL websites between 2015-01-01 00:00:00 and 2016-03-02 00:00:00.
You are about to delete log data. This action cannot be undone, are you sure you want to continue? (Y/N) y
.......................................................................................................................
Successfully deleted 168381 visits. Time elapsed: 899.281s
But my bd do no reduce size.
If I repeat ./console core:delete-logs-data --dates=2016-02-01,2016-02-31
I view
Preparing to delete all visits belonging to ALL websites between 2015-01-01 00:00:00 and 2016-03-02 00:00:00.
You are about to delete log data. This action cannot be undone, are you sure you want to continue? (Y/N) y
Successfully deleted 0 visits. Time elapsed: 487.321s
Why? How can I purge my db?
P.S. When delete process is working, I start strace and view next:
You may need to run optimize table (can take a long time on big size). This is not quite a Matomo related question but MySQL. I recommend you ask in our forum: https://forum.matomo.org or search for something like "mysql reduce disk space after deleting data" or "mysql reclaim disk space"
Hello.
My motomo version 3.3.0 and PHP 7.1.24
My matomo mysql db size is 400GB. I want clear a part of my db. I need delete 2015 year and part of 2016.
I go to console and do next command:
./console core:delete-logs-data --dates=2016-02-01,2016-02-31
and view next result:
But my bd do no reduce size.
If I repeat
./console core:delete-logs-data --dates=2016-02-01,2016-02-31
I view
Why? How can I purge my db?
P.S. When delete process is working, I start strace and view next:
The text was updated successfully, but these errors were encountered: