How to Check the MySQL Version

Pre-Flight Check
  • These instructions are intended for checking the MySQL version on your server.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.

Here's 75% off a New VPS! Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support

From the Command Line

The following command:

mysql -V

Should return something similar to:

mysql Ver 15.1 Distrib 5.5.41-MariaDB, for Linux (x86_64) using readline 5.1

Note: Are you looking to upgrade MySQL on a Liquid Web Core Managed or Fully Managed server? Then contact our Heroic Support® team! And if you’re looking for ways to improve the performance of your VPS, check out our blog on Optimizing Your VPS!
From the MySQL Command Client

When you connect to MySQL using a command client with the following command, the version of the MySQL server is displayed:


You should receive a result similar to:

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 74
Server version: 10.1.20-MariaDB MariaDB ServerCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.MariaDB [(none)]>

The server version in this example is Server version: 10.1.20-MariaDB MariaDB Server.

Once connected to the MySQL Command client, you can also run the command:


Which should return a result similar to:

| Variable_name           | Value                           |
| innodb_version          | 5.6.34-79.1                     |
| protocol_version        | 10                              |
| slave_type_conversions  |                                 |
| version                 | 10.1.20-MariaDB                 |
| version_comment         | MariaDB Server                  |
| version_compile_machine | x86_64                          |
| version_compile_os      | Linux                           |
| version_malloc_library  | system jemalloc                 |
| version_ssl_library     | OpenSSL 1.0.1e-fips 11 Feb 2013 |
| wsrep_patch_version     | wsrep_25.16                     |
10 rows in set (0.00 sec)

Looking for other MySQL tutorials? We have two awesome series! First, Basic Database Interaction. Second, Basic User Interaction. Check them out below!



MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison

General Results
  • MySQL 5.5 and 5.6 both performed significantly better than MySQL 5.1.
  • Read/Write and Read Only workloads testing requests per second show a marked improvement for both MySQL 5.5 and 5.6 over MySQL 5.1.
  • The 95th percentile response times (explained below) for both Read/Write and Read Only workloads on MySQL 5.5 and 5.6 were much lower (thus faster) than MySQL 5.1.
Requests per Second

MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison - Requests per Second - Read and Write Operations

Continue reading “MySQL 5.1 vs. 5.5 vs. 5.6 Performance Comparison”