• Resolved jihirmas

    (@jihirmas)


    Hi there!
    I am a SiteGround hosting client, and I am experiencing problems with my site’s performance. The hosting team investigated and found many SQL queries that take too much time to complete. Many of these queries involve the SiteGround Optimizer plugin. Is there any chance you can help me debug this?

    This are the slow queries:

    
    # Query_time: 8.891236  Lock_time: 4.235332  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 111
    SET timestamp=1695659573;
    SELECT option_value FROM wpzm_options WHERE option_name = 'siteground_optimizer_preload_combined_css' LIMIT 1;
    
    # Query_time: 9.790908  Lock_time: 4.900205  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 111
    SET timestamp=1695659574;
    SELECT option_value FROM wpzm_options WHERE option_name = 'siteground_optimizer_preload_combined_css' LIMIT 1;
    
    # Query_time: 9.893154  Lock_time: 4.235972  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 111
    SET timestamp=1695659574;
    SELECT option_value FROM wpzm_options WHERE option_name = 'siteground_optimizer_preload_combined_css' LIMIT 1;
    
    # Query_time: 10.805986  Lock_time: 4.796637  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 111
    SET timestamp=1695659585;
    SELECT option_value FROM wpzm_options WHERE option_name = 'siteground_optimizer_combine_javascript_exclude' LIMIT 1;
    
    # Query_time: 14.435418  Lock_time: 4.796576  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 111
    SET timestamp=1695659589;
    SELECT option_value FROM wpzm_options WHERE option_name = 'siteground_optimizer_combine_javascript_exclude' LIMIT 1;
    
    # Query_time: 60.449591  Lock_time: 28.984816  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 111
    SET timestamp=1695659662;
    SELECT option_value FROM wpzm_options WHERE option_name = 'siteground_optimizer_optimize_web_fonts' LIMIT 1;
    
    # Query_time: 57.686564  Lock_time: 30.833403  Rows_sent: 0  Rows_examined: 0  Rows_affected: 0  Bytes_sent: 111
    SET timestamp=1695659662;
    SELECT option_value FROM wpzm_options WHERE option_name = 'siteground_optimizer_optimize_web_fonts' LIMIT 1;
    

    Thanks in advanced.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Support Simeon Boev

    (@k3llanved)

    Unfortunately, a single query is not sufficient to provide useful information and insight into the slow performance of your website. I recommend taking a look at a plugin that monitors and provides a complete breakdown of the queries performed by your website. This will give deeper knowledge into the slow performance of the website. Nevertheless, take a look into the size of the database and reduce its size and content as much as possible. The lock time of the sample queries suggests a long wait time before the task is performed.

    Best Regards,

    Simeon Boev

Viewing 1 replies (of 1 total)

The topic ‘Plugin queries time out’ is closed to new replies.