@limitstudios opened this Issue on January 24th 2020 Contributor

Hi,

I've setup quite a few matomo instances at our hosting company and have noticed that as soon as we upgrade a customers PHP to 7.2 or above, the matomo instance starts showing lots of "MySQL has gone away" errors and performance goes down.

As soon as we downgrade back to 7.1 these errors go away and the system functions and performs fine. With PHP 7.1 being end of life, it would probably be a good idea looking to support the newer versions and ensuring performance is on par or better, and that errors like the above don't appear.

I'm a PHP developer myself so happy to work with you guys and provide a test environment to help debug and fix.

@tsteur commented on January 26th 2020 Member

@limitstudios It be great if you look into this and find something. Have you tested if there is again a difference for PHP 7.3? Are you maybe planning to give it a try?

Maybe PHP 7.2 regressed performance in some particular features. It's possible these performance issues only apply when using specific features/configurations. Some issues might only happen on a specific load etc. While we do support newer PHP versions, it's impossible for us to do advanced performance/load tests for different PHP versions unfortunately.

@limitstudios commented on January 27th 2020 Contributor

Hi @tsteur I would imagine there is, from my testing on a live environment it seems to affect 7.2 and 7.3.

I've almost got my profiling working and I'm able to reproduce the performance difference locally so will let you know what I find.

Powered by GitHub Issue Mirror