PHP/MySQL CPU performance statistics

Description

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!

Reviews

No php 8.2 compatibility

mailchef December 23, 2023

Throws exceptions, no php results but mysql test is working.

No updates and did not work with php8

Ralf R. September 2, 2022

I uses plugin for years but not updates and did not work any longer with php 8

Finally a test plugin

18TommyBoy September 26, 2021

Good job!

mysql test could be misleading

Jaro June 4, 2019

I tested this plugin with the real world example and it showed me very misleading information about MySQL performance. I had a large database of 11k+ images, 5k+ posts imported and then manipulated to two different local WP environments. One that was measured by this plugin as much slower due was performing significantly faster, and one that should be faster was in the real world much slower. I made sure it was the same database and all steps were exactly the same, then measured time with the stopwatch. When we’re talking about PHP performance test, it DOES reflect PHP performance correctly, or better say more precisely. UPDATE: Despite that in occasional cases this plugin gives unreliable readings, it’s not that often and do recommed to use it as basic test of the server performance.

Handy

Pothi Kalimuthu November 3, 2017

I had to measure the performance of my two local machines (a laptop and a desktop). This plugin came in handy to do exactly that. I only wish that there was a way to export the results for future ref!

Works well and does various important tests

CodeBard December 7, 2016

Benchmarks PHP and MySQL and does various performance analysis on these. Especially MySQL analysis is good. In general benchmarks are short, but quite informative.

Contributors & Developers

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 https://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