Return to previous page

Oversize wp_options autoload row – et_studio_data how to fix?

This topic has 21 replies, 2 voices, and was last updated 2 years, 5 months ago ago by Olga Barlow

bnourse

Participant

June 8, 2022 at 21:46

Hello,
We are doing some database cleanup and our developer has turned up an oversize autoload row in our wp_options (see screenshot below). It seems to contain the XStore demo templates. Our developer states:

“This is an oversized wp_options autoload row. It contains templates from XStore. They should offer a way to remove or set it to not autoload such a huge payload 10x a maximum row size. Wastes RAM. Causes object caching key rejections.”

Can you please advise how we can fix this??

Thanks for your assistance.

#325436 Copied Theme version: 8.1.6 WooCommerce version: 6.5.1

20 Answers

Olga Barlow

Support staff

June 9, 2022 at 09:58

Hello,

System loads that only if you click the XStore Studio icon to import studio sections. Anyway, provide us with WP Dashboard and FTP access to your site and we’ll disable autoloading.

Regards

#325471 Copied

bnourse

Participant

June 9, 2022 at 12:39

Hello,
That would be appreciated. Please let me know what you have changed, so I can adjust in the future if needbe.
Thank you for your assistance.
Ben

Please contact administrator
for this information.

#325502 Copied

Olga Barlow

Support staff

June 9, 2022 at 14:58

Hello,

Thank you. I have passed the issue to our developers. I’ll inform you once they fix the problem.

Regards

#325522 Copied

bnourse

Participant

June 10, 2022 at 00:26

Thank you for your help with this. I’ll watch for your message back.

Ben

#325546 Copied

Olga Barlow

Support staff

June 10, 2022 at 10:32

Hello,

Yes, sure. We need 1-2 days for this.

Regards

#325584 Copied

Olga Barlow

Support staff

June 13, 2022 at 10:40

Hello,

Fixed. Check now, please.

Regards

#325762 Copied

bnourse

Participant

June 13, 2022 at 13:47

Good morning,
Still seems to be there……
Please advise.

#325806 Copied

bnourse

Participant

June 13, 2022 at 13:55

This is the query:
SELECT
‘Autoload KB’ as name, ROUND( SUM( LENGTH( option_value ) ) / 1024 ) as size, null as autoload
FROM wp_qfda_options
WHERE autoload = ‘yes’
UNION
SELECT ‘Autoload count’, count( * ), null as autoload
FROM wp_qfda_options
WHERE autoload = ‘yes’
UNION (
SELECT option_name, length( option_value ), autoload
FROM wp_qfda_options
WHERE autoload = ‘yes’
ORDER BY length( option_value ) DESC
LIMIT 20
)
UNION (
SELECT option_name, length( option_value ), autoload
FROM wp_qfda_options
WHERE autoload = ‘no’
ORDER BY length( option_value ) DESC
LIMIT 20
)

#325809 Copied

bnourse

Participant

June 13, 2022 at 14:05

also wondering about “et_multiple_single_product” is that a needed autoload row? I understand some may be necessary for plugin performance.

#325812 Copied

bnourse

Participant

June 14, 2022 at 14:12

Good morning,
Any progress with this??
FYI we are trying to get decrease our autoloads, and that et_studio_data is a big one. Our hosting provider, WP Engine recommends keeping autoloads to less than 800K for object caching to work properly: https://wpengine.com/support/wp-engines-object-caching/
We have had to disable object caching until we can get our autoloads reduced.

Thanks for all of your help.
Ben

#325935 Copied

Olga Barlow

Support staff

June 15, 2022 at 14:45

Hello,

Sorry for the delay in answering. Could you, please, provide us with phpMyAdmin access to your DB. We need to make code improvements and check if that works.

Regards

#326053 Copied

bnourse

Participant

June 15, 2022 at 15:13

Good morning,
I will need to set you up as a user on our WP Engine account. Can you please provide email address to send the invitation?
Thanks,
Ben

Please contact administrator
for this information.

#326054 Copied

Olga Barlow

Support staff

June 15, 2022 at 15:30

Hello,

It redirects us to this form https://prnt.sc/O0wiGGxJdOGX
What credentials should we use there?

Regards

#326057 Copied

bnourse

Participant

June 15, 2022 at 15:45

I believe that you must set your own password to access this. Please provide me with an email address so that I can have an invitation sent to you, so you can establish credential.
Ben

#326061 Copied

bnourse

Participant

June 15, 2022 at 16:09

OK, lets’s do it like this. I have established credential for you.

Please contact administrator
for this information.

#326065 Copied

Olga Barlow

Support staff

June 16, 2022 at 10:28

Hello,

Check autoload now.

Regards

#326117 Copied

bnourse

Participant

June 16, 2022 at 13:25

Good morning,
The large row is gone – thank you!
Can you tell me, with this change persist in future releases of the theme?
Regards,
Ben

#326141 Copied

Olga Barlow

Support staff

June 16, 2022 at 14:30

Hello,

Yes. We’ll disable autoload for the studio in the next update.

Regards

#326154 Copied

bnourse

Participant

June 16, 2022 at 14:55

Hello,
Perfect! Thank you for your help taking care of this!
We appreciate the support.
Regards,
Ben

#326161 Copied

Olga Barlow

Support staff

June 16, 2022 at 15:16

Hello,

You are welcome.

Regards

#326165 Copied
Tagged: autoload, et_studio_data, oversize, templates, woocommerce, wordpress
Viewing 21 results - 1 through 21 (of 21 total)

The issue related to '‘Oversize wp_options autoload row – et_studio_data how to fix?’' has been successfully resolved, and the topic is now closed for further responses

Oversize wp_options autoload row – et_studio_data how to fix?

Recent Topics

Helpful Topics

Useful links WooCommerce & WordPress

Browse by popular tags:

Explore our best WordPress WooCommerce Themes collection