Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • May 7, 2015 at 3:34 pm #440999
    kriru

    My website slow down in every 3 or 4 days.
    when my website slow down it shows the maximum thread of sql queries.
    and below is the queries

    SELECT option_value FROM s8u2p0u_options WHERE option_name = 'avia_options_enfold_dynamic_pages' LIMIT 1
		117294 Query	SELECT option_value FROM s8u2p0u_options WHERE option_name = 'avia_options_enfold_dynamic_elements' LIMIT 1
		117294 Query	SELECT option_value FROM s8u2p0u_options WHERE option_name = 'avia_sidebars' LIMIT 1

    This query runs and use the maximum memory and it cause my website performance
    so please help me regarding this issue.

    May 8, 2015 at 4:57 pm #441641
    Elliott

    Hey kriru!

    Have you contacted your hosting provider about this? They should be able to switch your server settings around to fix it.

    Best regards,
    Elliott

    May 9, 2015 at 12:37 pm #441939
    kriru

    I spoke to my Sever Guys

    They are asking me “what” settings should they change?

    Please guide

    This issue is super important for me to continue using your theme because I would like my site to work 24×7

    May 11, 2015 at 7:33 am #442222
    kriru

    The site went down again

    I am waiting for an answer… Is this your best support?

    May 12, 2015 at 6:35 am #442802
    Rikard

    Hey!

    I’m not sure I understand the issue, are sql queries causing your site to crash or is it a lack of memory?

    Cheers!
    Rikard

    May 12, 2015 at 8:58 am #442850
    kriru

    It is due to spike in SQL queries

    These queries are periodic and do NOT correspond to high traffic load on the site

    When we check the mysql log, most of the queries are from avia

    Its a 16GB server and the memory get used up because of these queries

    The normal memory usage is 2-3GB

    May 13, 2015 at 8:18 am #443596
    Josue

    Hi!

    This could be solved by caching the database (you can use this plugin) so WP doesn’t have to call MySQL so often.

    Regards,
    Josue

    May 13, 2015 at 8:34 am #443618
    kriru

    We were already using W3 Total Cache but it create problems of its own

    So we switched to http://wp-rocket.me/

    Its gives better performance that W3 Total Cache but the issue with large number of avia queries and subsequemtly server going down remains

    May 17, 2015 at 5:49 am #445340
    Josue

    Hi,

    Can you post the link to your website please?

    Regards,
    Josue

    May 17, 2015 at 10:59 am #445371
    kriru

    The link is http://career.guru99.com

    May 18, 2015 at 3:17 am #445481
    Josue

    Hey!

    Do you have many users in your WordPress install? those two options (_dynamic_pages and _dynamic_elements) get called in the backend.

    Best regards,
    Josue

    May 18, 2015 at 9:10 am #445528
    kriru

    We have just 2 admin users

    We do not login that frequently into wordpress

    May 25, 2015 at 5:24 am #449344
    Ismael

    Hey!

    This is the first time this kind of question has been asked in the forum. We are not really sure what’s causing it and why it would happen on your installation but not from other enfold installations. Can you please provide any reference material related to the issue that we can check?

    Regards,
    Ismael

    May 27, 2015 at 8:17 am #450459
    kriru

    Hello,
    I have sent you sample query as mentioned above in discussion
    I am sending you log file for reference.
    please download this log file from this link->https://drive.google.com/uc?export=download&id=0B_vqvT0ovzHcMGt2ZXRvTnNpNWs

    June 2, 2015 at 11:33 pm #453420
    Basilis

    Hey!

    I have done a search on your web site, and seems that the memory is low, that is why it correspond low.

    Speed / Cache related you are almost perfect. http://gtmetrix.com/reports/career.guru99.com/mmW5WX7q
    Some small thing that can be done, but those it is possible through some plugins, to be achived completly.

    Cheers!
    Basilis

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 15 total)
  • You must be logged in to reply to this topic.