MySQL Room for Improvement

NM
Database Engineer at a retailer with 10,001+ employees

The developers of MySQL, which are Oracle MySQL, Percona, and MariaDB, seem to not be focusing much on object-oriented replication. Basically, replication is based on a text level of replication. There is a text level replication in Oracle, that is so similar it can be implemented in MySQL, however, it needs to pull a lot of resources. They have altered their approach for replication. Still, more focus on object-oriented replication would be good. 

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, is an open-source tool, it's not widely supported as a solution.

The latest 8.0 version has come up with whole new features. 

View full review »
PA
Software Engineer at a financial services firm with 10,001+ employees

MySQL can improve some of its functions. However, it is dependent on the use case. For example, if we are having multiple database connections in this tool, and we are performing one operation in one database, it takes a lot of time due to the reason we are selecting and processing the data. When we have a lot of data it takes a longer time. The transaction gets stuck in a queue and if we try to stop that particular transaction, it won't abort until all the selected records have been processed. This sometimes can be a lot of time and it can hold up our live processing of transactions. This product should be able to handle multiple processing at a time.

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.

View full review »
ND
Specialist Geosciences Data Consultant at a energy/utilities company with 10,001+ employees

I would like to see an autocorrect option, where if you're typing a query and you enter a comma instead of space, or something similar, the ability for it to be able to understand based on your previous scripts would be an advantage. For example, if you were to put a comma between your AND statements then it's not going to work. Maybe a smarter application where, as you're writing queries, similar to the way that grammar and spelling are checked when you type a text message on an iPhone, it could be autocorrected.

I would like to have the ability to cancel a query in SQL Developer. Specifically, I would like to be able to cancel the query should I accidentally write one that's going to loop, or have a JOIN wrong, where you get millions of records joining with millions of records over and over again. The availability to hit cancel so that it doesn't keep running would be helpful because, when such a thing happens, then you have to shut down the whole application and you lose any queries that you might've typed before.

View full review »
Buyer's Guide
MySQL
November 2022
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
657,397 professionals have used our research since 2012.
YT
Unemployed (previous role was Solutions Specialist, System Integration)

Because I am the middleware guy I'm not the SQL database administrator. If I have any issue with it, I'm going to contact the right person. 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. Then, when the administrator checks the status and makes notes, it works normally and the problem is fixed. With a big company you are not going to work directly with the MySQL database. We are the end user and not the administrator of the SQL database.

For MySQL, in terms of the usage or as the end user, I don't have much to recommend, as long as the query latency meets your requirements, it will be great. Otherwise, it's the horizontal scalability and you get more parallel in the implementation in terms of the SQL database regardless of the usage. This is probably much better than the vertical in terms of scalability.

View full review »
Kevin Honde - PeerSpot reviewer
Data Solution Architect at Econet Wireless Zimbabwe

The backup methods need improvement. MySQL needs to improve its backup methods so that you can actually do a backup without affecting products. Currently, when you're doing your backup, it locks the database. When someone tries to access it during a backup, it fails to read or to update. They can improve on the backup and all the backup features in general.

View full review »
Ahmed-Ramy - PeerSpot reviewer
CEO at TMentors

The support in MySQL is horrible.

It isn't as reliable as an SQL Server.

I don't see MySQL being improved at all, like in the last 10 years. It has been at the same level for a long time.

View full review »
CN
Principal Software Engineer at a manufacturing company with 1,001-5,000 employees

The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform.

View full review »
PE
Lead Project Manager, Owner at a tech services company with 11-50 employees

In terms of what could be improved, there is not anything that I can think of offhand.

Everything related to automation or improvements are external tools that are brought into it, so it has nothing to do with the robustness of the system itself - it is the developers and implementations that touch it. Those can be improved, but MySQL itself is fine as is. 

I would just say that it could be a little bit simpler to use.

View full review »
Ertugrul Akbas - PeerSpot reviewer
Manager at ANET

The two most common and popular MySQL database engines are MyISAM and InnoDB. Database engines provide the underlying functionality for MySQL to work with and process data. MyISAM is the default engine for MySQL for versions earlier than 5.5.5 and functions well in most scenarios.

However, depending on your needs, there are situations where another database engine, such as InnoDB, may be the better choice. For example, InnoDB supports transactions, whereas MyISAM does not. InnoDB also provides support for foreign keys, whereas MyISAM does not.

When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL. An example of this is the Vertica DB engine (https://en.wikipedia.org/wiki/...), and offering support for it would be valuable.

View full review »
Satishbabu Gunukula, Oracle ACE - PeerSpot reviewer
User

Improvements are required in character set support, scalability, and big data sets.

There is a lack of advanced features such as SQLServer, PostgreSQL, etc. I would like to see minimum reporting services and analytics features in the next release.

MySQL doesn't have many tools to monitor performance and fix issues easily.

The graphical user interface needs to be improved. It would be nice to have drag and drop on tables to create relationships between them. Other relation databases have these basic features. It helps during development to have these on hand.

This product is not suitable for enterprise applications.

View full review »
AR
Vice President & Head of IT Governance at a financial services firm with 1,001-5,000 employees

I have doubts about its overall stability. It's something that they should look at.

As an open-source product, there isn't really any technical support available if you get into trouble or have issues.

There isn't much scalability potential in the product.

View full review »
VC
Sr. Solution Architect at a computer software company with 5,001-10,000 employees

Integration is a key feature in need of improvement, as we have spent hours building this just to ensure that a set of data is exposed to a different client, a different world in need of that data. Since we are dealing with open source, which we are now employing in memory databases as well, it would be nice if they were to start thinking along those lines. 

View full review »
ARJUNMarya - PeerSpot reviewer
Enterprise Architect at a computer software company with 1,001-5,000 employees

Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier. In terms of new features, automation is always the biggest demand from our customers.

View full review »
PJ
Deputy Director General at a computer software company with 1,001-5,000 employees

We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things.

It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast.

View full review »
SJ
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees

It would be ideal if the solution had more references available in terms of helping me find answers to issues or problems. When I run into issues, I really have to research how to fix them. 

The installation process could be better.

I would like the product to have even better stability and scalability.

View full review »
LK
Systems Administrator at Dairibord

MySQL could be improved by adding more automation. There are no additional features I would like to see that I can think of at the moment. 

View full review »
DB
Founder at Art World Web Solutions

MySQL is good but it should be able to handle the large transaction levels that Oracle can. It should be able to manage large amounts of data. We have experienced some issues when we are handling a large amount of data in MySQL.

The memory consumption it's using is very high at times, and the default parameter settings are not quite good automatically. We need to tweak the configuration as per the requirements. This is an area that can be improved by giving some guidelines and direction. 

On the database side, it should be really lightweight, and the data structure should be like MongoDB.

It should put less load on to the memory and it should be able to handle maximum data.

View full review »
Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH

Typically security will be on a security layer. I haven't really looked into the security of it, but it should be good.

It could be more secure.

View full review »
TB
Managing Director at a financial services firm with 201-500 employees

Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance. When they release a new version, they mostly concentrate on scalability and performance.

View full review »
PK
Freelance Software Engineer + Director of a company at a outsourcing company with 1-10 employees

Its scalability can be better. It is probably not as scalable as Oracle. 

I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked.

View full review »
Hector Cuna - PeerSpot reviewer
Sysad Database Administrator Lead at USSC

It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL.

View full review »
Anays Micolod - PeerSpot reviewer
Programmeuse Python 3 at Université Grenoble Alpes

Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient.

I would like to be able to sort the data easily without having to do a request to get the table out of the database into the web page. At present, I can't do it directly inside MySQL; I have to do a request and print out my request into a web page.

View full review »
VR
SVP Technology and Head of India at a financial services firm with 201-500 employees

The technical support should be more knowledgeable and available worldwide.

View full review »
KB
Team Leader Presales at a comms service provider with 51-200 employees

Scalability could be improved.

View full review »
Karel Van Der Walt - PeerSpot reviewer
Data Architect at ACPAS Loan Management Software

I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB.

PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature.

View full review »
JI
System Analyst and Team Lead at a tech services company with 11-50 employees

The licensing of the solution is on the expensive side. 

View full review »
CM
Project Business Analyst RPA at a consultancy with 11-50 employees

MySQL needs to be more accessible and user-friendly. The person working with it needs to be trained in MySQL to have the necessary skills to control the database and analyze data. It should provide better customer experiences.

View full review »
DM
IT at a construction company with 201-500 employees

The manuals or documentation could be better.

View full review »
SA
Project Manager at a computer software company with 1,001-5,000 employees

The solution could be more secure.

View full review »
RM
Senior Director IP led Services (PES) at a computer software company with 1,001-5,000 employees

I'd like to see some additional JSON query support in the solution. 

View full review »
VR
Full Stack Developer at a tech services company with 10,001+ employees

Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance.

View full review »
CL
Data Analyst at a tech company with 51-200 employees

It is not as powerful as SQL Server. It can be more powerful.

It is not scalable and has certain limitations, which is not the case with SQL Server.

View full review »
RP
IT Specialist at a government with 1,001-5,000 employees

The solution could improve by having better performance and security.

View full review »
PareshNayak - PeerSpot reviewer
Oracle Cloud Infra Architect at Wipro Limited

We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL.

View full review »
ZelalemGedefie - PeerSpot reviewer
Senior System Administrator at Debre Markos University

The solution could have better integration and security features. 

View full review »
OmidKoushki - PeerSpot reviewer
Solution Architect at KIAN company

The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions.

View full review »
AV
Information Systems Computer System Controller at a insurance company with 11-50 employees

There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations.

View full review »
KR
Information Technology Administrator at a tech services company with 51-200 employees

There should be more tools to manage the on-premises version and more automation features.

View full review »
CR
Senior Java Developer at a computer software company with 11-50 employees

Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it.

View full review »
Ruben Conti - PeerSpot reviewer
Owner at Intersoftware sas

Security is a concern. MySQL could have better security features. 

View full review »
Buyer's Guide
MySQL
November 2022
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
657,397 professionals have used our research since 2012.