folamour
Hello,
After reviewing the queries you provided, it seems that they are originating from the Joomla core, so there are no unexpected or unusual queries.
The issue you are experiencing could be due to a full disk on your server. Please ensure that you have enough free disk space to handle the queries and other operations.
Another possible cause could be the queries requiring excessive memory. Increasing the memory size for MySQL might be a solution. You can start by looking at parameters such as key_buffer_size, sort_buffer, read_buffer, and table_cache. Additionally, consider checking innodb_buffer_pool_size .

Hope this help.

    There are not coming from the joomla core ! its your module ! if we disable the module crash stop, check the category listed in the fautly query (who came again again and again ) they are listed in the selection of the module !

      We need fix, we will archive 5K article on monday and give another try

      folamour
      Hmm,
      Could you share admin info to private box, also send me the module id that crashes your site?

        ok, i've a meeting in 30mn will be back in 1hour will give you the admin and the backdoor,

        thanks a lot, the host want to fire us because of these crash

        kind regards,

        f.

          This message is visible to Moderators only
          hidden content

          Also the issue is random we have archived 5K articles on the 15k to reduce the load of the query

          thanks

            folamour
            Hi,
            FTP info doesnt work. Could you check? I need to do some test on your server.
            Regards

                folamour
                Hi,
                After further investigation, i think issue might not because of ja good template. Ja good layouts for mod_articles_category only use joomla module data, no extra db query. You can turn on the module, delete all ja good layout content and monitor this issue again. All layouts you can find at: /templates/ja_good/html/mod_articles_category

                Because of your site have a mount of articles, i prefer mysql needs more memory. I made some tests and the result is:

                SELECT @@key_buffer_size/1024/1024
128.00000000
SELECT @@max_allowed_packet/1024/1024
64.00000000
SELECT @@sort_buffer_size/1024/1024
8.00000000
SELECT @@read_buffer_size/1024/1024
2.00000000

                Could you ask db team to increase key_buffer_size, max_allowed_packet, sort_buffer_size and read_buffer_size to 250M?

                  what this mean i have to delete ja good ? and ask to increase ? without ja good the site don't crash

                    folamour
                    Hi,
                    All queries you sent come from module mod_articles_category. This is a module of joomla core. Ja Good support some layout override for this module. To test out ja good makes your site crash or not, you can open all override layouts of module mod_articles_category, empty them and monitor template ja good again. The folder is /templates/ja_good/html/mod_articles_category.

                    Hope this clear.

                      ok that has to be seen by the level 2 support at hostpoint, but the engineer will be back tomorrow, so i get back in touch with you when he will be back

                      thanks you a lot for your support because our website is at risk and its 15 year of work,

                      kind regards,

                      f.

                      i'm sorry i dont understood that :

                      you can open all override layouts of module mod_articles_category, empty them and monitor template ja good again. The folder is /templates/ja_good/html/mod_articles_category.

                      you want to said to open the file, empty them, save them, and retry ?

                        have you finished with the web site can i re activate admin tools ?

                        You need to Login to view replies.