Centova Technologies Forum

Centova Cast v3 => General discussion => Topic started by: alex46 on October 28, 2012, 12:13:28 pm

Title: mysql tuning?
Post by: alex46 on October 28, 2012, 12:13:28 pm

Hello. we have load Mysql server: centovacast has 800 queries per minute , can anybody have ideas optimize it?

Title: Re: mysql tuning?
Post by: alex46 on December 03, 2012, 11:41:17 am

Up ...
http://s4.hostingkartinok.com/uploads/images/2012/11/c62fd27b88852d64048631d8c2cca72c.png

Centova generate over 500 queries per minute (peak 2 000 queries)  all time (24/7)
60% queries: select

Title: Re: mysql tuning?
Post by: Centova - Steve B. on December 05, 2012, 04:14:23 pm

I don't speak Russian so the screenshot unfortunately doesn't tell me anything, but nothing in Centova Cast should be generating 500-2000 queries per minute unless your users are hammering the server while logged in.   The caching we perform on the public-facing content should prevent this kind of impact on MySQL even if your widgets/start pages are getting slammed.

The first thing I'd suggest is making sure this actually has something to do with Centova Cast.  The screenshot you provided definitely doesn't do this -- you'd want to check the MySQL process list to see what queries are being executed.

If you confirm that the queries are coming from Centova Cast, then something must be going wrong on your CC installation, in which case we'd need to know which queries are forming the bulk of the load on your server in order to diagnose the problem.