Howard L Martinez Posted September 1, 2022 Author 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?
Jim M Posted September 1, 2022 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.
Howard L Martinez Posted September 2, 2022 Author 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
Steve Bullman Posted September 2, 2022 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
Jim M Posted September 2, 2022 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
Howard L Martinez Posted September 3, 2022 Author 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
Marc Posted September 5, 2022 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.
Recommended Posts