• We have a query that is maxing out our MySQL CPU.

    UPDATE wp_options SET option_value = ‘massive amount of data’ WHERE option_name = autoptimize_ccss_queue

    We ran the cron for ao_ccss_maintenance but the query is still massive.

    “Force path-based rules to be generated for pages?” is turned off, but we can see rules in the queue that are path based. Example:

    “\/colleges\/salter-school-cambridge-campus”:{“ljid”:”j-0ma2ko”,”rtarget”:”types|is_page”,”ptype”:”is_page”,”hashes”:[“381e2527672058081e156cc20ccefd4a”],”hash”:”381e2527672058081e156cc20ccefd4a”,”file”:null,”jid”:”63137724EDuEm59F96″,”jqstat”:”JOB_UNKNOWN”,”jrstat”:”NONE”,”jvstat”:”NONE”,”jctime”:1605814783.989657,”jftime”:1605815702.26596},”\/colleges\/cuny-bernard-m-baruch-college\/reviews\/is-the-stereotype-of-students-at-your-school-accurate”:{“ljid”:”j-0odkly”,”rtarget”:”types|”,”ptype”:false,”hashes”:[“35380d4932c070e94a00bc392276f9eb”],”hash”:”35380d4932c070e94a00bc392276f9eb”,”file”:null,”jid”:”63446618QwwFe2M9KO”,”jqstat”:”JOB_UNKNOWN”,”jrstat”:”NONE”,”jvstat”:”NONE”,”jctime”:1606202484.839797,”jftime”:1606203302.578059}

    Which looks to be a rule for this page: https://www.unigo.com/colleges/salter-school-cambridge-campus

    How can we fix this?

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Optimizing Matters

    (@optimizingmatters)

    the job you mention indeed is not a path-based one; it’s an is_page job for that path.

    OK, some questions:
    * are you still using the power-up? best would be to disable it, AO has CCSS built-in now (with several improvements) and disabling the power-up allows AO to take over.
    * how many jobs are in the queue (approximately)?
    * is the queue getting processed (is ao_ccss_queue getting triggered every 10 minutes)?
    * what is the “request limit” under settings -> autoptimize -> critical css -> advanced settings?
    * is “also aggregate inline CSS” on?

    frank

    Thread Starter joefitzgerald39

    (@joefitzgerald39)

    No to power-up. Only Autoptimize plugin is installed.
    How many jobs in the queue? 2,369
    Is ao_ccss_queue being triggered every 10 mins? Yes
    What is request limit? 5
    Aggregate? Yes.

    Thanks for your help.

    Thread Starter joefitzgerald39

    (@joefitzgerald39)

    No jobs show in the plugin settings queue.
    just the wp_options row

    Plugin Author Optimizing Matters

    (@optimizingmatters)

    ah, so the queue is not shown on the settings page? afraid you’ll have to clear the autoptimize_ccss_queue option manually in that case with something like

    UPDATE wp_options SET option_value = ‘’ WHERE option_name = autoptimize_ccss_queue

    and disable “also aggregate inline CSS” (which causes the hashes the critical CSS logic keeps per job to change between pages, so you get multiple is_page jobs) to keep the number of jobs under control.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Path-Based rules and huge wp_options for autoptimize_ccss_queue’ is closed to new replies.