Tagged: database
-
AuthorPosts
-
February 11, 2020 at 12:43 pm #1183420
Hi,
Our website is running slow. When I evaluated I concluded that the autopoaded from _option is very big.
When running 1 querry I found the following tables are hugeaviaAsset_avia-head-scripts 31176257
aviaAsset_avia-footer-scripts 5751650
aviaAsset_css_filecontent 509679
aviaAsset_js_filecontent 227916This aviaAsset_avia-head-scripts has 31mb.
what should I do?- This topic was modified 4 years, 10 months ago by emanar.
February 12, 2020 at 3:07 am #1183725I am also having this same issue!!
When I looked at the aviaAsset_avia-head-scripts option value, it was filled with 7 megabytes of
s:21:\"error-generating-file\";s:66:\"avia-head-scripts-593c1b88ec833ab2d...
repeatedI ran this query monitor plugin https://wordpress.org/plugins/query-monitor/
and noticed that WordPress was running a massive update script on every page load to set this massive 7mb value.
This was why my site was running slow.I updated to the latest Enfold theme (4.7.3) and cleared out the aviaAsset_avia-head-scripts value in the wp_options table.
This brought my website back to full speed, but the aviaAsset_avia-head-scripts value is slowly filling back up with the same error, so I believe I’ve only temporarily fixed the issue.- This reply was modified 4 years, 10 months ago by AWebDeveloper.
February 13, 2020 at 2:55 am #1184030I just find out that if you turn off this features under performance solves the issue :).
– CSS file merging and compression /
– Javascript file merging and compression
– Http security level for checking readability of merged filesI thought this features should improve performance.
Its a bug?February 14, 2020 at 4:50 am #1184373Hi,
Thank you for the inquiry.
Are you using Memcached for your database, or fetching cached data from it? The compression has issues with this method because it returns a database entry with an old timestamp, so the theme doesn’t know the merged files already exist and generates them repeatedly. There is an available filter that you can use to remove this timestamp and prevent duplication of compressed files.
/* * Some server configurations seem to cache WP options and do not return changed options - so we generate a new file again and again * This filter allows to return the same value (or a custom value) for each file. "---" is added to seperate and identify as added value. * Return empty string to avoid adding. * * The following snippet shows what to return. * * @since 4.7.2.1 * @param string $uniqid * @param array $data * @param WP_Scripts $enqueued * @param string $file_group_name * @param array $conditions * @return string */ function avf_custom_merged_files_unique_id( $uniqid, $file_type, $data, $enqueued, $file_group_name, $conditions ) { return ''; } add_filter( 'avf_merged_files_unique_id', 'avf_custom_merged_files_unique_id', 10, 6 );
If this doesn’t work, please disable the compression completely and use an extension like Autoptimize instead.
Best regards,
IsmaelMarch 8, 2020 at 2:03 pm #1191261I have been seeing the same issue since 4.7.3.
Were there changes in the caching algorithm?
- This reply was modified 4 years, 9 months ago by Jason.
March 9, 2020 at 1:16 pm #1191499Hi,
What do you mean by caching algorithm? Did you enable database caching in your server? The database cache causes the file compression feature of the theme to break and in order to fix it, you have to add the filter above to remove the timestamp and prevent the theme from redundantly generating the merged files.
If you need further help or info, please create a new thread and post the necessary details in the private field. We’ll close this one for now.
Best regards,
Ismael -
AuthorPosts
- The topic ‘Cleanup wp_options Table – aviaAsset_avia-head-scripts’ is closed to new replies.