84% mysql-process-list

Code Review | MySQL Process List

WordPress plugin MySQL Process List scored84%from 54 tests.

About plugin

  • Plugin page: mysql-process-list
  • Plugin version: 1.2
  • PHP compatiblity: 7.2+
  • PHP version: 7.4.16
  • WordPress compatibility: 5.8-6.2
  • WordPress version: 6.3.1
  • First release: Jan 12, 2023
  • Latest release: May 9, 2023
  • Number of updates: 15
  • Update frequency: every 7.8 days
  • Top authors: stefanpejcic (66.67%)pluginsclub (40%)

Code review

54 tests

User reviews

1 review

Install metrics

10+ active /294 total downloads

Benchmarks

Plugin footprint 82% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Verifying that this plugin installs correctly without errors
Installer ran successfully

Server metrics [RAM: ▲0.02MB] [CPU: ▼4.75ms] 75% from 4 tests

Server-side resources used by MySQL Process List
It is recommended to improve the following
  • CPU: Total CPU usage should be kept under 500.00ms (currently 2,909.46ms on /wp-admin/tools.php?page=mysql-process-list)
PageMemory (MB)CPU Time (ms)
Home /3.48 ▲0.0236.44 ▼4.38
Dashboard /wp-admin3.33 ▲0.0248.20 ▼1.55
Posts /wp-admin/edit.php3.38 ▲0.0251.64 ▲4.14
Add New Post /wp-admin/post-new.php5.91 ▲0.0288.48 ▼12.55
Media Library /wp-admin/upload.php3.25 ▲0.0235.71 ▼0.50
MySQL Process List /wp-admin/tools.php?page=mysql-process-list3.242,909.46

Server storage [IO: ▲0.08MB] [DB: ▲0.00MB] Passed 3 tests

Analyzing filesystem and database footprints of this plugin
No storage issues were detected
Filesystem: 4 new files
Database: no new tables, 6 new options
New WordPress options
widget_recent-comments
db_upgraded
can_compress_scripts
widget_theysaidso_widget
theysaidso_admin_options
widget_recent-posts

Browser metrics Passed 4 tests

Checking browser requirements for MySQL Process List
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,804 ▲5813.21 ▼1.541.85 ▲0.1239.44 ▼0.49
Dashboard /wp-admin2,210 ▲225.87 ▼0.0396.13 ▼16.7243.97 ▼0.23
Posts /wp-admin/edit.php2,096 ▲71.99 ▼0.0434.37 ▼4.2835.02 ▲3.42
Add New Post /wp-admin/post-new.php1,536 ▲823.17 ▲4.89649.80 ▼9.4557.56 ▼0.28
Media Library /wp-admin/upload.php1,389 ▲14.22 ▲0.0999.77 ▼3.7645.50 ▼1.49
MySQL Process List /wp-admin/tools.php?page=mysql-process-list9202.2028.6131.79

Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 75% from 4 tests

🔸 Tests weight: 35 | Verifying that this plugin uninstalls completely without leaving any traces
These items require your attention
  • This plugin does not fully uninstall, leaving 6 options in the database
    • widget_recent-comments
    • theysaidso_admin_options
    • widget_recent-posts
    • widget_theysaidso_widget
    • can_compress_scripts
    • db_upgraded

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no server-side errors were triggered
Everything seems fine, however this is by no means an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | It is important to ensure that your PHP files perform no action when accessed directly, respecting the single-responsibility principle
Please take a closer look at the following
  • 1× PHP files trigger server errors when accessed directly:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/mysql-process-list/mysql-process-list.php:12

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, but this is not an exhaustive test

Optimizations

Plugin configuration Passed 29 tests

readme.txt Passed 16 tests

You should put a lot of thought into formatting readme.txt as it is used by WordPress.org to prepare the public listing of your plugin
3 plugin tags: query, mysql, process list

mysql-process-list/mysql-process-list.php Passed 13 tests

The main PHP file in "MySQL Process List" ver. 1.2 adds more information about the plugin and also serves as the entry point for this plugin
56 characters long description:
Show MySQL Process list under Tools > MySQL Process List

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | An overview of files in this plugin; executable files are not allowed
Success! There were no dangerous files found in this plugin585 lines of code in 2 files:
LanguageFilesBlank linesComment linesLines of code
CSS1123488
PHP1231697

PHP code Passed 2 tests

Analyzing cyclomatic complexity and code structure
There were no cyclomatic complexity issued detected
Cyclomatic complexity
Average complexity per logical line of code0.22
Average class complexity0.00
▷ Minimum class complexity0.00
▷ Maximum class complexity0.00
Average method complexity0.00
▷ Minimum method complexity0.00
▷ Maximum method complexity0.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes0
▷ Abstract classes00.00%
▷ Concrete classes00.00%
▷ Final classes00.00%
Methods0
▷ Static methods00.00%
▷ Public methods00.00%
▷ Protected methods00.00%
▷ Private methods00.00%
Functions2
▷ Named functions2100.00%
▷ Anonymous functions00.00%
Constants0
▷ Global constants00.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

Often times overlooked, PNG files can occupy unnecessary space in your plugin
1 PNG file occupies 0.02MB with 0.01MB in potential savings
Potential savings
Compression of 1 random PNG file using pngquant
FileSize - originalSize - compressedSavings
includes/images/pluginsclub_logo_black.png22.36KB10.65KB▼ 52.36%