No more typing reviews! Try our Samantha, our new voice AI agent.
MySQL Logo

MySQL pros and cons

Vendor: Oracle
4.1 out of 5
Badge Leader

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

MySQL is highly valued for its open-source nature, allowing extensive community support and rapid development.
It is recognized for its stability and reliability, having been a mature database solution for many years.
MySQL provides strong performance and scalability, making it suitable for various scales of projects and enterprises.
Users appreciate its ease of use for setup, deployment, and management, which can be critical for projects with tight deadlines.
MySQL is praised for being cost-effective, often highlighted by its free access and robust features without additional expenses.

CONS

MySQL is not easily scalable on cost-effective consumer-grade hardware.
Documentation is often complex and insufficient for users without database experience.
There are frequent performance issues, especially with large data sets and complex queries.
Integration, security features, and monitoring tools need significant improvement.
Scalability and enhancement of high availability and replication features are necessary.
 

MySQL Pros review quotes

it_user1065 - PeerSpot reviewer
Senior Manager of Data Center at a integrator with 51-200 employees
Jul 1, 2012
MySQL is indeed the world's most popular open source database.
it_user1044 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Jul 2, 2012
As a developer I have used many database engines but MySQL is by far the best known and most popular Open Source database engine.
it_user1122 - PeerSpot reviewer
Infrastructure Expert at a tech services company with 1,001-5,000 employees
Jul 12, 2012
Combined with PHPMyAdmin, MySQL is an excellent database solution for small to medium sized businesses or installations.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
889,855 professionals have used our research since 2012.
it_user1164 - PeerSpot reviewer
Infrastructure Expert at a tech services company with 51-200 employees
Jul 13, 2012
It has a relational database system.
it_user1077 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Aug 4, 2012
Offers high performance due to its unique storage engine architecture as well as it's core written in powerful languages such as C and C++.
it_user1020 - PeerSpot reviewer
Head of Data Center at a tech company with 51-200 employees
Dec 18, 2012
What I like most about MySQL is that it's relatively easy to install, fast, lightweight and reliable.
it_user3876 - PeerSpot reviewer
Database Manager at a tech company with 51-200 employees
May 1, 2014
Having excellent performance, MYSQL is used by many internet powerhouses like yahoo as their back-end database.
it_user178848 - PeerSpot reviewer
Engineer with 51-200 employees
Jan 13, 2015
MySQL provides a low cost and effective SQL Database solution for smaller companies that don’t require the overhead and cost associated with RDBMS tools like Oracle.
it_user244500 - PeerSpot reviewer
Constructor of the computer systems at a security firm with 51-200 employees
Oct 29, 2015
Reliability Security Flexibility Functionality Availability - controllability anywhere and with different methods
it_user285990 - PeerSpot reviewer
Service Operations Manager at a tech vendor with 51-200 employees
Aug 5, 2015
However, the ability to scale horizontally is much better than other vendors.
 

MySQL Cons review quotes

it_user1065 - PeerSpot reviewer
Senior Manager of Data Center at a integrator with 51-200 employees
Jul 1, 2012
Slower performance when using InnoDB as compared to MyISAM for using simple queries
it_user1044 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Jul 2, 2012
You probably wouldn't use it for heavy-duty installation.
it_user1122 - PeerSpot reviewer
Infrastructure Expert at a tech services company with 1,001-5,000 employees
Jul 12, 2012
It is a community driven project, which means that support is sometimes scarce and hard to find.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
889,855 professionals have used our research since 2012.
it_user1164 - PeerSpot reviewer
Infrastructure Expert at a tech services company with 51-200 employees
Jul 13, 2012
DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are non deterministic.
it_user1077 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
Aug 4, 2012
MySQL is missing some RDBMS features like stored procedures, foreign keys, transaction, rollback, and subselect, and it also does not support triggers.
it_user1020 - PeerSpot reviewer
Head of Data Center at a tech company with 51-200 employees
Dec 18, 2012
Just be ready though to work at the command line should you wish to use MySQL in its free form.
it_user3876 - PeerSpot reviewer
Database Manager at a tech company with 51-200 employees
May 1, 2014
MySQL has a limited storage capacity. It doesn’t support large databases.
it_user178848 - PeerSpot reviewer
Engineer with 51-200 employees
Jan 13, 2015
Replication and HA features, but that is to be expected at this entry point.
it_user244500 - PeerSpot reviewer
Constructor of the computer systems at a security firm with 51-200 employees
Oct 29, 2015
MyISAM tables could be more reliable.
it_user285990 - PeerSpot reviewer
Service Operations Manager at a tech vendor with 51-200 employees
Aug 5, 2015
Configuration templates and reliability both need work.