Index WP MySQL For Speed 1.4.1
Does Index WP MySQL For Speed work with WordPress 5.8.3 and PHP 7.4.8? A smoke test was performed on .
Summary
Errors
| 3 | PHP warnings |
| No JavaScript exceptions | |
| All test pages loaded successfully | |
| No resource errors |
Performance
Memory usage: 641.34 KiB
The average PHP memory usage increased by this amount after activating by the plugin.
Page speed impact:
insignificant.
The plugin didn't make the site noticeably slower.
Environment
| WordPress version | 5.8.3 |
|---|---|
| PHP version | 7.4.8 |
| MySQL version | 8.0.21 |
| PHP memory limit | 256M |
Plugin Info
| Last updated | |
|---|---|
| Active installs | 50,000+ |
| WordPress.org page | https://wordpress.org/plugins/index-wp-mysql-for-speed/ |
| Badges |
|
Pages 6
Plugins ‹ Test site — WordPress
| URL | /wp-admin/plugins.php?plugin_status=all&paged=1&s |
|---|---|
| Requested URL | /wp-admin/plugins.php?action=activate&plugin=index-wp-mysql-for-speed%2Findex-wp-mysql-for-speed.php&plugin_status=all&paged=1&s&_wpnonce=f391de5b45 |
| Aspect | after-activation |
| HTTP status | 200 |
| Load time | 0.430 s |
| Memory usage | 4.03 MiB |
| JS errors | None |
| Resource errors | None |
Tools → Index MySQL
| URL | /wp-admin/tools.php?page=imfs_settings |
|---|---|
| Aspect | menu-item |
| HTTP status | 200 |
| Load time | 0.451 s |
| Memory usage | 7.28 MiB |
| JS errors | None |
| Resource errors | None |
Tools → Index MySQL → Help
| URL | https://www.plumislandmedia.net/index-wp-mysql-for-speed/high_performance_keys/ |
|---|---|
| Requested URL | https://plumislandmedia.net/index-wp-mysql-for-speed/high_performance_keys |
| Aspect | menu-item-tab |
| HTTP status | 200 |
| Load time | 2.105 s |
| Memory usage | N/A |
| JS errors | None |
| Resource errors | None |
Tools → Index MySQL → Monitor Database Operations
| URL | /wp-admin/tools.php?page=imfs_settings&tab=monitor_database_operations |
|---|---|
| Aspect | menu-item-tab |
| HTTP status | 200 |
| Load time | 0.463 s |
| Memory usage | 7 MiB |
| JS errors | None |
| Resource errors | None |
Tools → Index MySQL → About
| URL | /wp-admin/tools.php?page=imfs_settings&tab=about |
|---|---|
| Aspect | menu-item-tab |
| HTTP status | 200 |
| Load time | 0.256 s |
| Memory usage | 6.93 MiB |
| JS errors | None |
| Resource errors | None |
Test site – Just another WordPress site
| URL | / |
|---|---|
| Aspect | front-page |
| HTTP status | 200 |
| Load time | 0.227 s |
| Memory usage | 2.91 MiB |
| JS errors | None |
| Resource errors | None |
Benchmark
| URL | Load time | Memory usage | ||||
|---|---|---|---|---|---|---|
| Inactive | Active | Change | Inactive | Active | Change | |
| /wp-admin/index.php | 0.305 s | 0.394 s | +0.089 s | 3.08 MiB | 3.77 MiB | + 705.03 KiB |
| /wp-admin/edit.php | 0.185 s | 0.195 s | +0.010 s | 3.11 MiB | 3.86 MiB | + 768.66 KiB |
| /wp-admin/post-new.php | 0.800 s | 0.973 s | +0.173 s | 5.27 MiB | 5.96 MiB | + 709.3 KiB |
| /wp-admin/upload.php | 0.393 s | 0.302 s | -0.091 s | 3.03 MiB | 3.72 MiB | + 703.9 KiB |
| /wp-admin/options-writing.php | 0.160 s | 0.136 s | -0.024 s | 3.02 MiB | 3.7 MiB | + 687.88 KiB |
| /wp-admin/media-new.php | 0.461 s | 0.199 s | -0.262 s | 3.01 MiB | 3.69 MiB | + 704.07 KiB |
| /wp-admin/edit-tags.php?taxonomy=category | 0.183 s | 0.199 s | +0.016 s | 3.04 MiB | 3.73 MiB | + 705.34 KiB |
| /wp-admin/post-new.php?post_type=page | 0.608 s | 0.616 s | +0.008 s | 5.26 MiB | 5.95 MiB | + 705.28 KiB |
| /wp-admin/options-discussion.php | 0.236 s | 0.404 s | +0.168 s | 3 MiB | 3.69 MiB | + 704.38 KiB |
| /wp-admin/edit-comments.php | 0.210 s | 0.219 s | +0.009 s | 3.04 MiB | 3.73 MiB | + 703.88 KiB |
| / | 0.276 s | 0.219 s | -0.057 s | 2.96 MiB | 2.91 MiB | - 42.96 KiB |
| Average | 0.347 s | 0.351 s | +0.004 s | 3.44 MiB | 4.06 MiB | + 641.34 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 | |
|---|---|---|---|---|---|
| PHP | 98.8% | 17,654 | 2,203 | 171 | |
| CSS | 1.0% | 175 | 0 | 1 | |
| JavaScript | 0.2% | 38 | 4 | 1 | |
| Total | 17,867 | 2,207 | 173 | ||
PHP Code Analysis | More results »
| Lines of code | 18,433 |
|---|---|
| Total complexity | 3,850 |
| Median class complexity | 8.0 |
| Median method complexity | 2.0 |
| Most complex class | Imfs_AdminPageFramework_Parsedown |
| Most complex function | Imfs_AdminPageFramework_Parsedown::lines() |
| Classes | 250 |
|---|---|
| Methods | 1,584 |
| Functions | 24 |
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 1
- ImfsPage
PHP Error Log 3 lines
[19-Jan-2022 15:26:16 UTC] PHP Warning: mysqli_query(): (42000/1227): Access denied; you need (at least one of) the PROCESS privilege(s) for this operation in /wp-includes/wp-db.php on line 2056
[19-Jan-2022 15:26:19 UTC] PHP Warning: mysqli_query(): (42000/1227): Access denied; you need (at least one of) the PROCESS privilege(s) for this operation in /wp-includes/wp-db.php on line 2056
[19-Jan-2022 15:26:20 UTC] PHP Warning: mysqli_query(): (42000/1227): Access denied; you need (at least one of) the PROCESS privilege(s) for this operation in /wp-includes/wp-db.php on line 2056