Benchmarks
Plugin footprint 65% from 16 tests
Installer Passed 1 test
🔺 Critical test (weight: 50) | All plugins must install correctly, without throwing any errors, warnings, or notices
The plugin installed gracefully, with no errors
Server metrics [RAM: ▲1.52MB] [CPU: ▲2.53ms] Passed 4 tests
Server-side resources used by Index WP MySQL For Speed
Normal server usage
| Page | Memory (MB) | CPU Time (ms) |
|---|---|---|
| Home / | 3.51 ▲0.05 | 37.12 ▼2.23 |
| Dashboard /wp-admin | 5.31 ▲2.01 | 59.29 ▲6.89 |
| Posts /wp-admin/edit.php | 5.42 ▲2.07 | 55.30 ▲10.94 |
| Add New Post /wp-admin/post-new.php | 7.89 ▲2.01 | 90.45 ▼5.47 |
| Media Library /wp-admin/upload.php | 5.23 ▲2.00 | 45.26 ▲10.98 |
| Index MySQL /wp-admin/tools.php?page=imfs_settings | 9.42 | 92.18 |
Server storage [IO: ▲1.65MB] [DB: ▲0.00MB] 67% from 3 tests
Filesystem and database footprint
Please fix the following
- You have illegally modified 1 file (3.61KB) outside of "wp-content/plugins/index-wp-mysql-for-speed/" and "wp-content/uploads/"
- (new file) wp-content/mu-plugins/index-wp-mysql-for-speed-update-filter.php
Filesystem: 187 new files
Database: no new tables, 8 new options
| New WordPress options |
|---|
| imfsQueryMonitor |
| ImfsPage |
| theysaidso_admin_options |
| widget_recent-posts |
| can_compress_scripts |
| widget_recent-comments |
| widget_theysaidso_widget |
| db_upgraded |
Browser metrics Passed 4 tests
Index WP MySQL For Speed: an overview of browser usage
Normal browser usage
| Page | Nodes | Memory (MB) | Script (ms) | Layout (ms) |
|---|---|---|---|---|
| Home / | 2,819 ▲84 | 13.22 ▼1.15 | 1.65 ▼0.02 | 40.59 ▼7.99 |
| Dashboard /wp-admin | 2,228 ▲40 | 4.83 ▼0.98 | 103.83 ▼12.82 | 41.59 ▼5.76 |
| Posts /wp-admin/edit.php | 2,107 ▲18 | 2.06 ▲0.06 | 38.19 ▼1.13 | 33.30 ▼3.08 |
| Add New Post /wp-admin/post-new.php | 1,546 ▲23 | 23.18 ▼0.15 | 684.64 ▲29.60 | 55.68 ▼7.71 |
| Media Library /wp-admin/upload.php | 1,407 ▲16 | 4.20 ▼0.01 | 99.83 ▲5.37 | 44.67 ▲2.92 |
| Index MySQL /wp-admin/tools.php?page=imfs_settings | 1,214 | 2.35 | 36.71 | 37.63 |
Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 50% from 4 tests
🔸 Tests weight: 35 | The uninstall procedure must remove all plugin files and extra database tables
It is recommended to fix the following
- Uninstall procedure validation failed for this plugin
- > Warning in wp-content/plugins/index-wp-mysql-for-speed/uninstall.php+13
unlink(wp-content/mu-plugins/index-wp-mysql-for-speed-update-filter.php): No such file or directory
- This plugin does not fully uninstall, leaving 6 options in the database
- can_compress_scripts
- db_upgraded
- theysaidso_admin_options
- widget_theysaidso_widget
- widget_recent-posts
- widget_recent-comments
Smoke tests 50% from 4 tests
Server-side errors Passed 1 test
🔹 Test weight: 20 | Just a short smoke test targeting errors on the server (in the Apache logs)
The smoke test was a success, however most plugin functionality was not tested
SRP 0% from 2 tests
🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
Please fix the following
- 1× PHP files perform the task of outputting text when accessed with GET requests:
- > /wp-content/plugins/index-wp-mysql-for-speed/code/assets/mu/index-wp-mysql-for-speed-update-filter.php
- 149× GET requests to PHP files have triggered server-side errors or warnings (only 10 are shown):
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_FrameworkUtility' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/_abstract/_view/AdminPageFramework_TabNavigationBar.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_FieldType' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/form/field_type/AdminPageFramework_FieldType_default.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_FrameworkUtility' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/form/_view/AdminPageFramework_Form_View___Description.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_Form_View___Attribute_FieldContainer_Base' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/form/_view/attribute/AdminPageFramework_Form_View___Attribute_Fields.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_FrameworkUtility' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/admin_page/_model/delegate/AdminPageFramework_Model_Menu__RegisterMenu.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_Model__FormSubmission__Validator_Base' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/admin_page/_model/delegate/validaor/AdminPageFramework_Model__FormSubmission__Validator__Export.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_Input_Base' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/form/input/AdminPageFramework_Input_select.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_FrameworkUtility' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/form/_view/sectionset/AdminPageFramework_Form_View___SectionCaption.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_Factory' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/admin_page/AdminPageFramework.php:7
- > PHP Fatal error
Uncaught Error: Class 'Imfs_AdminPageFramework_FieldType' not found in wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/form/field_type/AdminPageFramework_FieldType_radio.php:7
- > PHP Fatal error
User-side errors Passed 1 test
🔹 Test weight: 20 | Just a short smoke test targeting errors on the browser (console and network errors and warnings)
Everything seems fine on the user side
Optimizations
Plugin configuration Passed 29 tests
readme.txt Passed 16 tests
Don't ignore readme.txt as it is the file that instructs WordPress.org on how to present your plugin to the world
6 plugin tags: performance, database, index, wp-cli, mysql...
index-wp-mysql-for-speed/index-wp-mysql-for-speed.php Passed 13 tests
"Index WP MySQL For Speed" version 1.4.14's main PHP file describes plugin functionality and also serves as the entry point to any WordPress functionality
110 characters long description:
Speed up your WordPress site by adding high-performance keys (database indexes) to your MySQL database tables.
Code Analysis Passed 3 tests
File types Passed 1 test
🔸 Test weight: 35 | Executable files are not allowed as they can serve as attack vectors
No dangerous file extensions were detected18,241 lines of code in 177 files:
| Language | Files | Blank lines | Comment lines | Lines of code |
|---|---|---|---|---|
| PHP | 173 | 1,246 | 3,058 | 17,485 |
| JavaScript | 2 | 58 | 122 | 569 |
| CSS | 2 | 63 | 11 | 187 |
PHP code Passed 2 tests
A brief analysis of cyclomatic complexity and code structure for this plugin
This plugin has no cyclomatic complexity issues
| Cyclomatic complexity | |
|---|---|
| Average complexity per logical line of code | 0.32 |
| Average class complexity | 10.10 |
| ▷ Minimum class complexity | 1.00 |
| ▷ Maximum class complexity | 159.00 |
| Average method complexity | 2.41 |
| ▷ Minimum method complexity | 1.00 |
| ▷ Maximum method complexity | 26.00 |
| Code structure | ||
|---|---|---|
| Namespaces | 1 | |
| Interfaces | 0 | |
| Traits | 0 | |
| Classes | 251 | |
| ▷ Abstract classes | 56 | 22.31% |
| ▷ Concrete classes | 195 | 77.69% |
| ▷ Final classes | 2 | 1.03% |
| Methods | 1,616 | |
| ▷ Static methods | 294 | 18.19% |
| ▷ Public methods | 884 | 54.70% |
| ▷ Protected methods | 239 | 14.79% |
| ▷ Private methods | 493 | 30.51% |
| Functions | 21 | |
| ▷ Named functions | 19 | 90.48% |
| ▷ Anonymous functions | 2 | 9.52% |
| Constants | 26 | |
| ▷ Global constants | 14 | 53.85% |
| ▷ Class constants | 12 | 46.15% |
| ▷ Public constants | 12 | 100.00% |
Plugin size Passed 2 tests
Image compression Passed 2 tests
It is recommended to compress PNG files in your plugin to minimize bandwidth usage
5 compressed PNG files occupy 0.00MB
Potential savings
| Compression of 5 random PNG files using pngquant | |||
|---|---|---|---|
| File | Size - original | Size - compressed | Savings |
| code/assets/datatables/DataTables-1.11.3/images/sort_desc_disabled.png | 0.14KB | 0.25KB | 0.00% |
| code/assets/datatables/DataTables-1.11.3/images/sort_asc_disabled.png | 0.14KB | 0.25KB | 0.00% |
| code/assets/datatables/DataTables-1.11.3/images/sort_desc.png | 0.15KB | 0.25KB | 0.00% |
| code/assets/datatables/DataTables-1.11.3/images/sort_both.png | 0.20KB | 0.29KB | 0.00% |
| code/assets/datatables/DataTables-1.11.3/images/sort_asc.png | 0.16KB | 0.25KB | 0.00% |