No more typing reviews! Try our Samantha, our new voice AI agent.
it_user1065 - PeerSpot reviewer
Senior Manager of Data Center at a integrator with 51-200 employees
Vendor
Jul 1, 2012
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.
PeerSpot user
it_user2652 - PeerSpot reviewer
it_user2652Project Manager at a non-tech company with 10,001+ employees
Top 20Real User

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.

Director at BAB
MSP
Nov 30, 2023
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.
PeerSpot user
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: June 2026
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.