MySQL Logo

MySQL pros and cons

Vendor: Oracle
4.1 out of 5
Badge Ranked 1
4,445 followers
Post review
 

MySQL Pros review quotes

Patryk Golabek - PeerSpot reviewer
Aug 5, 2020
This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable.
AG
Oct 20, 2020
The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support.
NM
Dec 29, 2021
MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.
GG
Oct 19, 2020
I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered. SQL Server has a query analyzer. MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system. It seems more responsive and cleaner. With MySQL, you get what you need without any overbloating, for which Microsoft is known. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance.
PA
Jan 26, 2022
MySQL is easy to use, has fast performance, and it is comfortable for end-user to use. The schema level and structure we are using are very simple and easy to understand. Additionally, packaging tool development is straightforward and the data is presented in a way that is very simple to understand.
Ismail Yushaw - PeerSpot reviewer
Nov 29, 2023
It is a very stable solution. I deployed the product six years ago, and it still works fine.
ND
Feb 25, 2021
It is pretty simple to use and I don't have anything really bad to say about it.
YT
Nov 13, 2021
The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures.
LM
Oct 12, 2020
The most valuable features are that it's free and the documentation is good.
AC
Nov 10, 2020
Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language.
 

MySQL Cons review quotes

Patryk Golabek - PeerSpot reviewer
Aug 5, 2020
In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. These open source projects have sprung up, but they're more general purpose.
AG
Oct 20, 2020
If the customer is already using or has already used Oracle for a long time they will know the look and feel and the character of this database that can fit into their business.
NM
Dec 29, 2021
They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.
GG
Oct 19, 2020
The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL.
PA
Jan 26, 2022
In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful.
Ismail Yushaw - PeerSpot reviewer
Nov 29, 2023
The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required.
ND
Feb 25, 2021
I would like to have the ability to cancel a query in SQL Developer.
YT
Nov 13, 2021
Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it.
LM
Oct 12, 2020
In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be.
AC
Nov 10, 2020
MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand.