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 ?

                folamour
                Nvm, please check my second thought, your mysql should be able to use more memory.
                Regards

                  Does archiving 10k will fix the issue the host ask us to purchase a dedicated server to do your requested modification,

                  i've also open a thread on joomla.org

                    folamour
                    I think VPS with 4Gb ram would be enough. On VPS, you can custom your mysql config without asking hosting provider.

                      ok we have a vps under the hand, but at this time i have reactivated the template and the host said the load is correct

                      mahta can you tell me if you have modified something on the template and if this modification will be integrated on future release of ja good or not ?

                      thanks a lot, have a great afternoon

                      f.

                        You need to Login to view replies.