1. Home
2. Optimize Database after Deleting Revisions
3. 5.0.6

Optimize Database after Deleting Revisions 5.0.6

Does "Optimize Database after Deleting Revisions" work with WordPress 5.8 and PHP 7.4.8? A smoke test was performed on 2021-07-23 15:25:34 UTC.

Summary

Pages 4

Plugins ‹ Test site — WordPress

Tools → Optimize Database

Settings → Optimize Database

Test site – Just another WordPress site

Benchmark

URL	Load time			Memory usage
	Inactive	Active	Change	Inactive	Active	Change
/wp-admin/index.php	0.343 s	0.285 s	-0.058 s	3.08 MiB	3.1 MiB	+ 21.67 KiB
/wp-admin/edit.php	0.178 s	0.190 s	+0.012 s	3.11 MiB	3.2 MiB	+ 85.67 KiB
/wp-admin/post-new.php	1.049 s	1.139 s	+0.090 s	5.27 MiB	5.29 MiB	+ 26.03 KiB
/wp-admin/upload.php	0.604 s	0.338 s	-0.266 s	3.03 MiB	3.05 MiB	+ 20.54 KiB
/wp-admin/options-writing.php	0.160 s	0.141 s	-0.019 s	3.02 MiB	3.03 MiB	+ 4.52 KiB
/wp-admin/media-new.php	0.268 s	0.202 s	-0.066 s	3.01 MiB	3.03 MiB	+ 20.71 KiB
/wp-admin/edit-tags.php?taxonomy=category	0.186 s	0.350 s	+0.164 s	3.04 MiB	3.06 MiB	+ 21.62 KiB
/wp-admin/post-new.php?post_type=page	0.955 s	0.943 s	-0.012 s	5.26 MiB	5.28 MiB	+ 21.62 KiB
/wp-admin/options-discussion.php	0.245 s	0.316 s	+0.071 s	3 MiB	3.03 MiB	+ 21.34 KiB
/wp-admin/edit-comments.php	0.223 s	0.291 s	+0.068 s	3.04 MiB	3.06 MiB	+ 20.52 KiB
/	0.272 s	0.225 s	-0.047 s	2.91 MiB	2.93 MiB	+ 17.3 KiB
Average	0.408 s	0.402 s	-0.006 s	3.43 MiB	3.46 MiB	+ 25.59 KiB

Code Statistics

Note: Third-party libraries and minified JS/CSS files are excluded from these statistics where possible, so the numbers you see here may be lower than those reported by other tools.

Language		%	Lines of code	Comment lines	Files
	PO File	59.7%	4,421	2,987	14
	PHP	38.2%	2,830	702	8
	CSS	2.1%	155	14	1
Total			7,406	3,703	23

PHP Code Analysis | More results »

Additions

Things that the plugin adds to the site. This section is not intended to be comprehensive. The test tool only looks for a few specific types of added content.

Options wp_options 2

• odb_rvg_excluded_tabs
• odb_rvg_options

PHP Error Log 10 lines

[23-Jul-2021 15:25:50 UTC] WordPress database error Table 'wordpress.wp_odb_logs' doesn't exist for query 
		SELECT COUNT(*) AS logcnt FROM `wp_odb_logs`
		 made by require_once('wp-admin/admin.php'), do_action('tools_page_rvg-optimize-database'), WP_Hook->do_action, WP_Hook->apply_filters, OptimizeDatabase->odb_start_manually, OptimizeDatabase->odb_start, ODB_Displayer->display_start_buttons, ODB_Logger->odb_log_count
[23-Jul-2021 15:25:50 UTC] PHP Notice:  Undefined offset: 0 in /wp-content/plugins/rvg-optimize-database/classes/odb-logger.php on line 191
[23-Jul-2021 15:25:50 UTC] PHP Notice:  Trying to access array offset on value of type null in /wp-content/plugins/rvg-optimize-database/classes/odb-logger.php on line 191
[23-Jul-2021 15:25:50 UTC] WordPress database error Table 'wordpress.wp_odb_logs' doesn't exist for query 
		SELECT COUNT(*) AS logcnt FROM `wp_odb_logs`
		 made by require_once('wp-admin/admin.php'), do_action('tools_page_rvg-optimize-database'), WP_Hook->do_action, WP_Hook->apply_filters, OptimizeDatabase->odb_start_manually, OptimizeDatabase->odb_start, ODB_Displayer->display_start_buttons, ODB_Logger->odb_log_count
[23-Jul-2021 15:25:50 UTC] PHP Notice:  Undefined offset: 0 in /wp-content/plugins/rvg-optimize-database/classes/odb-logger.php on line 191
[23-Jul-2021 15:25:50 UTC] PHP Notice:  Trying to access array offset on value of type null in /wp-content/plugins/rvg-optimize-database/classes/odb-logger.php on line 191

---