CI runs slow with Nginx + PHP 7.1 + MariaDB |
Downgrading PHP can't possibly help, not just with this but with anything.
Looks like you're handling concurrent requests from the same user (AJAX-heavy website?), which when combined with sessions ... Well, it's explained in the manual. Also, that query explain plan shows that you didn't have an index on the `id` field (which you should, again per the same manual page) and that has slowed it further down. |
Messages In This Thread |
CI runs slow with Nginx + PHP 7.1 + MariaDB - by travisbotello - 11-13-2017, 05:10 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by Narf - 11-13-2017, 10:50 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by travisbotello - 11-13-2017, 10:59 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by travisbotello - 11-14-2017, 12:57 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by Narf - 11-14-2017, 02:03 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by travisbotello - 11-14-2017, 02:11 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by Narf - 11-14-2017, 03:02 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by InsiteFX - 11-14-2017, 10:55 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by travisbotello - 11-21-2017, 04:49 AM
RE: CI runs slow with Nginx + PHP 7.1 + MariaDB - by travisbotello - 11-28-2017, 10:31 AM
|