SQL Optimization

swsemnto

Question regarding optimization of sql with 16gb ram, currently have 100% load status if I have 600+ active users on my website.

Should I leave the default setting of it?

I have max 600 active user according to g analytics should I also increase my Max connections to 600? default is 400.
and do I have to make 16gb of Max RAM usage to fully use my ram of 16gb?

Sorry for dumb question.

Thanks

aapanel_power

swsemnto Hello, your maximum concurrency is 600, I think the configuration of your server is enough, you can optimize the SQL statement, of course, the configuration of your screenshot of MySQL can be dynamically adjusted, if not enough, you can adjust the parameters to a multiple of 8.

idflorin

swsemnto I have 600+ active users on my website.

Logged in users? at the same time?
Nginx or Apache?

swsemnto

aapanel_power
Will it handle 1k active user on my server, if I set max connection to 1k? I have 16gb ram. Thanks

swsemnto

idflorin Visitors only

idflorin

try https://wordpress.org/plugins/w3-total-cache/