Senior Manager of Data Center at a integrator with 51-200 employees
One of the best open source database for web developers and application enthusiasts
Pros and Cons
- "MySQL is indeed the world's most popular open source database."
- "Slower performance when using InnoDB as compared to MyISAM for using simple queries"
What is most valuable?
The best features in MySQL, making it one of the most used databases globally, are-
1) Multi-threaded architecture for multiple CPU utilization and kernel threading
2) Use of triggers and crash recovery techniques
3) Indexed Conditional Pushdown
4) Integration with LAMP/WAMP
5) Easy setup with Memcached for increasing performance and scalability
What needs improvement?
Few cons in MySQL are
1) Increased complexity in InnoDB
2) Slower performance when using InnoDB as compared to MyISAM for using simple queries
3) Only identical MyISAM tables can be merged.
4) No active directory integration as in SQL server
5) It does not support check constraints
What other advice do I have?
MySQL is indeed the world's most popular open source database. It has been designed on the hyper threading infrastructure and supports multi-threaded architecture for using multiple CPU's. It works on index compression with B-Tree disk tables popularly known as MyISAM. Its efficiency depends on the implementation of SQL functions with optimization of library classes.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
A stable and flexible product that is easy to use and can be deployed quickly
Pros and Cons
- "The product is flexible and easy to use."
- "The interface could be improved."
What is our primary use case?
I use the product as a backend to my application.
What is most valuable?
The product is flexible and easy to use.
What needs improvement?
The interface could be improved.
For how long have I used the solution?
I have been using the solution for seven to ten years. I am using the latest version of the solution.
What do I think about the stability of the solution?
I rate the tool’s stability a nine out of ten. The stability is good.
What do I think about the scalability of the solution?
I rate the tool’s scalability a seven out of ten. We have four direct users and more than 1000 indirect users. We use the tool twice a week.
How was the initial setup?
I rate the ease of setup an eight out of ten. The deployment took a few minutes. We need two system administrators to maintain the tool.
What about the implementation team?
The deployment was done in-house. We need one system administrator to deploy the tool.
What's my experience with pricing, setup cost, and licensing?
I rate the pricing a seven or six out of ten on a scale of one to ten, where one is cheap and ten is expensive.
What other advice do I have?
We used different solutions before, but I do not know why we switched to MySQL. I recommend the solution to others. Overall, I rate the product an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Updated: June 2026
Popular Comparisons
Teradata
SQL Server
Oracle Database
PostgreSQL
MongoDB Enterprise Advanced
SAP HANA
Firebird SQL
InfluxDB
ClickHouse
MariaDB
IBM Db2 Database
Qdrant
Milvus
OpenSearch
CockroachDB
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which solution do you recommend for embedding reporting? Why?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Why are MySQL connections encrypted and what is the biggest benefit of this?
- Considering that there is a free version of MySQL, would you invest in one of the paid editions?
- What is one thing you would improve with MySQL?
- How does MySQL compare with Firebird SQL?
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Why is Open Source Databases important for companies?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?

















MySQL is platform independent and can be installed on windows, linux and other OS too. It is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source.