PHP/MySQL CPU performance statistics

November 27, 2020

PHP/MySQL CPU performance statistics Plugin

With the performance test plugin you can test the CPU and MySQL speed on your webserver and your MySQL server.

CPU performance testing:
This plugin does various calculations and string manipulations on your PHP webserver
and your MySQL database server. To further test the MySQL server, a sequence of MySQL
inserts, selects, updates and deletes are performed in a separate custom database table
(we do not use your WordPress tables for this).

Network testing:
The network is tested by fetching directly from Google’s CDN / apis network. Fetching from the Google
apis network gives you the nearest server, and will give more accurate results. We also fetch a small 1Mb
file from our servers as well in case the Google apis is down. The network tests are not yet shown in the
graphs, we are working on this 🙂

Results:
After the sequence of tests has finished, the results will be displayed for you to evaluate. MySQL results can
vary depending on the type of connection your webserver has to the MySQL server. If a “local socket” connection
is used a typical result for the MySQL query test is 0.05-0.25 seconds. Web hosting providers with dedicated MySQL
servers will show a slower time/queries per second, as a TCP/IP connection to the MySQL server is made instead of
a local socket connection.

There are many factors that will determine how fast your website will run. This plugin does not test
for how many hits/requests per second your provider allows to your website, file system performance is not tested
either. Use it as a performance test to assess how fast a CPU your provider has allocated to your webserver
and your MySQL database backend.

Share with your friends, let’s start a competition and see who’s got the fastests servers (hint) 🙂

Installation

This section describes how to install the plugin and get it working.

e.g.

  1. Upload mywebtonet-performancestats folder after extracting the zip file, upload to the /wp-content/plugins/ directory or simply upload the zip file from the admin panel.
  2. Activate the plugin through the ‘Plugins’ menu in WordPress
  3. Click Performance test in the menu!

Changelog

1.0

  • This is the first stable release of this plugin.

1.0.1

  • Minor correction in the submit results section.

1.0.3

  • Now with graphs 🙂 Thanks to http://www.ebrueggeman.com

1.0.4

Now with even more graphs 🙂 Now your fastest and slowest times are logged in the database.

1.0.5

Minor code changes.

1.0.6

Query test added.

1.0.7

Minor changes. Tested on WordPress 3.8.

1.0.8

Now with network testing tool

1.0.9

More PHP information + webserver type/version

1.1.0

Minor update

1.1.1

Only calling apache_get_version() if function exists

1.1.2

Some servers reports one or more of the MySQL tests at 0.00 seconds, which
is impossible. This now triggers an error.

1.1.3

Added path and gateway interface

1.1.4

Added missing ?> in main script, for some reason it doesnt work with all php versions without it.

1.1.5

Minor code changes + split the network test into two seperate tests

1.1.6

We have done some minor code changes as some webservers require

<?php

instead of just

<?

1.1.7

Minor code corrections

1.1.8

Some servers failed to do the network test (openssl errors). We now do the test directly from a nonssl enabled server.

1.1.9

Now with PHP 7.0(RC5) figures.

1.2.0

Tested with PHP 7.1. For network testing we have changed so we no longer use file_get_contents but curl instead, this makes the plugin more compatible with almost all webserver configurations.

1.2.1

Minor update to the network test.

1.2.2

Minor code modifications to work with PHP 8.0 which it doesn’t…and WordPress 5.6

Details

  • Version: 1.2.1
  • Active installations: 500
  • WordPress Version: 3.2.0
  • Tested up to: 5.6.14

Ratings


5 Stars
4 Stars
3 Stars
2 Stars
1 Stars