MySQL Room for Improvement
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 »
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 »
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 »
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 »
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 »
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.
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 »
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 »
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 »
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 »
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.
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
Team Leader Presales at a comms service provider with 51-200 employees
Scalability could be improved.View full review »
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.
System Analyst and Team Lead at a tech services company with 11-50 employees
The licensing of the solution is on the expensive side.
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 »
IT at a construction company with 201-500 employees
The manuals or documentation could be better.View full review »
Project Manager at a computer software company with 1,001-5,000 employees
The solution could be more secure.
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.
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 »
Data Analyst at a tech company with 51-200 employees
IT Specialist at a government with 1,001-5,000 employees
The solution could improve by having better performance and security.View full review »
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 »
The solution could have better integration and security features.
The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions.View full review »
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 »
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 »
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 »
Security is a concern. MySQL could have better security features.View full review »