I’m running a matomo 3.13.6 over a 10 years database with around 1 TB of data.
This system was abandoned by last IT team and I’m try to resurrect this instance.
When I try to run, through cron, ./console core:archive command returns some errors in some sites with error msg “SQLSTATE[HY000]: General error: 2006 MySQL server has gone away”.
So, my question is: have some way to run this process directly into mysql?
But there have been some more tipps for this issue reported here including switching from MySQLi to PDO (you can do that in the config.ini.php) and using another PHP mysql client:
mysql> show variables like 'innodb_log_file_size';
+----------------------+-----------+
| Variable_name | Value |
+----------------------+-----------+
| innodb_log_file_size | 268435456 |
+----------------------+-----------+
1 row in set (0.00 sec)
mysql> show variables like 'max_allowed_packet';
+--------------------+-----------+
| Variable_name | Value |
+--------------------+-----------+
| max_allowed_packet | 268435456 |
+--------------------+-----------+
1 row in set (0.00 sec)
mysql> show variables like 'wait_timeout';
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| wait_timeout | 115200 |
+---------------+--------+
1 row in set (0.00 sec)
mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
About the adapter, I will try it now. But, I also found problems with PHP 7.2, that is my current env. After to try adapter, i will try to upgrade to 7.3 or 7.4.