Skip to content

Improve autoloaded options check by highlighting largest autoloaded options #353

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
mukeshpanchal27 merged 8 commits into from
Sep 14, 2022
Merged

Improve autoloaded options check by highlighting largest autoloaded options #353

Changes from all commits
Commits
Show all changes
8 commits
Select commit Hold shift + click to select a range
9d2539d
Implement autoload explanation table
rytisder Jun 2, 2022
dfce948
Fix PHPDoc, HTML table, add translations and remove #column
rytisder Jun 16, 2022
b049a60
Fix function call
rytisder Jun 16, 2022
24d063b
Display size in MB
rytisder Sep 11, 2022
bbbbe52
Merge branch 'trunk' into feature/implement-autoload-explanation-table
felixarntz Sep 12, 2022
2d52a81
Update the escaping
mukeshpanchal27 Sep 13, 2022
3b05c2e
Remove var_dump
mukeshpanchal27 Sep 13, 2022
9f69812
Add missing document for the filter.
mukeshpanchal27 Sep 14, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
53 changes: 52 additions & 1 deletion modules/site-health/audit-autoloaded-options/load.php
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -76,7 +76,7 @@ function perflab_aao_autoloaded_options_test() {
'<p>' . esc_html( $base_description ) . ' ' . __( 'Your site has %1$s autoloaded options (size: %2$s) in the options table, which could cause your site to be slow. You can reduce the number of autoloaded options by cleaning up your site\'s options table.', 'performance-lab' ) . '</p>',
$autoloaded_options_count,
size_format( $autoloaded_options_size )
);
) . perflab_aao_get_autoloaded_options_table();

/**
* Filters description to be shown on Site Health warning when threshold is met.
Expand Down Expand Up @@ -116,3 +116,54 @@ function perflab_aao_autoloaded_options_size() {
global $wpdb;
return (int) $wpdb->get_var( 'SELECT SUM(LENGTH(option_value)) FROM ' . $wpdb->prefix . 'options WHERE autoload = \'yes\'' );
}

/**
* Fetches autoload top list.
*
* @since n.e.x.t
*
* @return array Autoloaded data as option names and their sizes.
*/
function perflab_aao_query_autoloaded_options() {
global $wpdb;

/**
* Filters the threshold for an autoloaded option to be considered large.
*
* The Site Health report will show users a notice if any of their autoloaded
* options exceed the threshold for being considered large. This filters the value
* for what is considered a large option.
*
* @since n.e.x.t
*
* @param int $option_threshold Threshold for an option's value to be considered
* large, in bytes. Default 100.
*/
$option_threshold = apply_filters( 'perflab_aao_autoloaded_options_table_threshold', 100 );

return $wpdb->get_results( $wpdb->prepare( "SELECT option_name, LENGTH(option_value) AS option_value_length FROM {$wpdb->options} WHERE autoload='yes' AND LENGTH(option_value) > %d ORDER BY option_value_length DESC LIMIT 20", $option_threshold ) );
}

/**
* Gets formatted autoload options table.
*
* @since n.e.x.t
*
* @return string HTML formatted table.
*/
function perflab_aao_get_autoloaded_options_table() {
$autoload_summary = perflab_aao_query_autoloaded_options();

$html_table = sprintf(
'<table class="widefat striped"><thead><tr><th scope="col">%s</th><th scope="col">%s</th></tr></thead><tbody>',
__( 'Option Name', 'performance-lab' ),
__( 'Size', 'performance-lab' )
);

foreach ( $autoload_summary as $value ) {
$html_table .= sprintf( '<tr><td>%s</td><td>%s</td></tr>', $value->option_name, size_format( $value->option_value_length, 2 ) );
}
$html_table .= '</tbody></table>';

return $html_table;
}