How to Check the MySQL Version

In this quick tutorial we’ll learn how to check the MySQL version of a server. Without a doubt MySQL is one of the most popular RDBMS options available, so you’ll find it pretty much everywhere. There can be some pretty staggering differences between MySQL versions, so knowing which version you’re working with is important. Learn here how, to check the version of MySQL your server is using!

Continue reading “How to Check the MySQL Version”

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”