Thank you for providing that slow query log. Unfortunately, I am seeing a lot of references to the advanced tag and prefixes third party application. Please disable that and other third party applications/plugins then please re-run and please limit the slow query log to queries running longer than 10 seconds.

You mean to limit queries running  longer than 10 seconds to be killed?

 

You mean to limit queries running  longer than 10 seconds to be killed?

No, please only log in the slow query log queries taking longer than 10 seconds. 

 

No, please only log in the slow query log queries taking longer than 10 seconds. 

hi, can u please right the query to run , 

because my hosting team didn't understand what we want :-s 

My advice would be to get a host that understands invision community. More your hosting to @ASTRAPI and all your problems will disappear 

 

hi, can u please right the query to run , 

because my hosting team didn't understand what we want :-s 

Sorry this is a server configuration, not a query. I would advise them to read documentation about Slow Query log configuration in MySQL: https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html

long_query_time is generally what is required here: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_long_query_time

 

 

Sorry this is a server configuration, not a query. I would advise them to read documentation about Slow Query log configuration in MySQL: https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html

long_query_time is generally what is required here: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_long_query_time

 

i provide the slow query log , some one hid it and didn't reply me :-s 

 

i provide the slow query log , some one hid it and didn't reply me :-s 

These were hidden so as to hide sensitive information. We have the details, dont worry.

The queries where its showing issues are nothing special in terms of how they query the database there. They are quite simple queries. Unfortunately, this is more a hosting issue than one with the software. What I would say is you still have issues with tables and not being INNODB, as shown in the support section of your admin CP, along with the software not being on the latest release. You should address both of those first of all.