Howard L Martinez Posted September 1, 2022 Author Share Posted September 1, 2022 16 hours ago, Jim M said: 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? Link to comment Share on other sites More sharing options...
Jim M Posted September 1, 2022 Share Posted September 1, 2022 3 minutes ago, Howard L Martinez said: 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. Link to comment Share on other sites More sharing options...
Howard L Martinez Posted September 2, 2022 Author Share Posted September 2, 2022 22 hours ago, Jim M said: 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 Link to comment Share on other sites More sharing options...
Steve Bullman Posted September 2, 2022 Share Posted September 2, 2022 My advice would be to get a host that understands invision community. More your hosting to @ASTRAPI and all your problems will disappear Link to comment Share on other sites More sharing options...
Jim M Posted September 2, 2022 Share Posted September 2, 2022 2 hours ago, Howard L Martinez said: 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 Link to comment Share on other sites More sharing options...
Howard L Martinez Posted September 3, 2022 Author Share Posted September 3, 2022 On 9/2/2022 at 5:01 PM, Jim M said: 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 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted September 5, 2022 Share Posted September 5, 2022 On 9/3/2022 at 4:40 PM, Howard L Martinez said: 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. Link to comment Share on other sites More sharing options...
Recommended Posts