I was trying to update to Matomo 4.0.5 in a self hosted server by clicking the button “Continue to Matomo”.
It crashed the server with too many ‘max_user_connections’ active connections through
piwik_log_visit MODIFY COLUMN
referer_url VARCHAR(1500) NULL;
Then I increased ‘max_user_connections’ from 50 to 150, but still the update process crashed the server again when it produced more 147 /analytics/piwik.php processes seen with “ps”.
My piwik_log_visit is 1,732,368 rows, Index Length 155.75 MB Data Length 225.50 MB. There are much bigger piwik tables in the database.
Seems something goes rogue, any idea?