Cpu goes to 100% and site is not loading when there are alot of users online, the problem is probably with select query from database.
When i disable veronika theme and plugins cpu works at 3% its dedicated server with Xeon E5 1650 cpu

@oscman

How many user do you have online ?
In peak I have 40-60 users online, in last 30 sec - checking, posting, registering etc... , all is working fine....
it is shared server...

i have 500 visitors and about 200-300 users online at that times server works at 100% cpu
also there are 1500 conversation with i don't know how many messages inside in 6 hours

i have 500 visitors and about 200-300 users online at that times server works at 100% cpu

200-300 users online  in what time?

live time at peak hours, every second

what is your web site?

i sent u pm

did you try with theme but without plugins ?

did you try with theme but without plugins ?

i have only veronika plugins installed nothing elese

Quote from: Ivanko on March 20, 2017, 03:43:55 AM

did you try with theme but without plugins ?

i have only veronika plugins installed nothing elese

so , means the problem with plugins not with theme right ?

lets work and get off one by one plugins to find out which of them is creating a problem ...?

can you provide a list of all extra plugins are installed  on your nicely dedicated server?

oh sorry i confused the threat i thought we was talking about pagination not going up
No i didn't try without plugins i suspect its messenger as in my old site it was another messenger fault for going slow

@oscman
Messenger has pagination that should guarantee no extra SQL load.
Also question is if your database or server is slow. For database you can allow sql debug mode and check how much each query loads.

Changing to mariadb fixed it mysql apparently sucks.

@oscman
Thanks for your feedback, intresting resolution

The problem is back cpu usage with 8 cores is at 90% with the messenger enabled, site takes 10 seconds to load. Please need a solution