MySQL

Easy to use the queries

Superfast in fetching the data

Easy to learn and apply

Data joining can become lot more easier with data view tabs

It is easy to understand.

It works well with most of the popular programming languages.

It is better and cheaper than other relational database services available in market.

I would love to see some updates in the UI part of it.

They should work on their documentation. Make it more readable by changing fonts.

Simple and flexible

Can be used in different OS (Windows, Linux, MacOS)

Open-source

Big datasets problem

Improving the user interface

More tutorials needed in the documentation

Beginner friendly

Quick and easy to set up

Has a massive userbase

Lack of advanced features compared to PostgreSQL or SQL Server

Doesn't scale as well as PostgreSQL or SQL Server for large databases

Multiple database engines.

Open source

Supports millions of records.

User interface to manage DB.

Data replica or auto sync between two servers.

It has hit every nook and corner of my entire organization and I am very much satisfied with its high availability, self-healing, provisioning, monitoring, and much more.

It works faster and gives effective services.

My team is at ease to work on such a reliable platform that is concerned with security. It provides me full control over all aspects of MySQL through its comprehensive set of advanced features, management tools, and technical support as well.

It is the most reliable database management tool that collaborates really well with WordPress, Drupal, Joomla!, etc., and equips me with all the necessary tools that could be beneficial to meet database challenges of next-generation web and cloud services.

This is a very costly tool that really does not fit well with small business setups.

There are still many complications (e.g., I faced difficulty in its licensing and its UI/UX could be improved too). Also, it is complicated in understand, as too much of the information is available--it becomes difficult to understand.

Storing relational data.

Quick management.

Integration with different development tools, for instance with IntelliJ Idea.

I had some stability issues in the past.

SQL requirement.

Hard to find support for special cases.

Easy to set up

Easy to learn for beginners

Multi-language support

Scalability.

Not efficient to handle big data sets.

Easy integration with development tools and environments, as well as connection with different programming languages

The support for handling transactions allows recovering from failures in operations and thus maintain data integrity.

Efficient use of resources at the memory and CPU level

Cross-platform support for different operating systems

Lack of documentation for a large percentage of MySQL utilities, for example the aspect of data replication for certain cases there is no documentation.

Some experience is required to configure and tune it to the project requirements.

Migration from standard SQL is sometimes not automatic and requires manual migration.

Easy of use

Fast installation

Support for replication and backups

Free software

Standard GUI

Blueprints of configuration

Better tutorials

Very easy and simple to learn and apply

Robust and secure

Compatible with almost all types of programming languages, like C#, Java, and PHP, which provides flexibility to deploy databases for different applications

Not suitable for large data management

User interface can be improved

Support for non-relational data will be an added advantage

Security updates are not that frequent

Since MySQL is open source, it is free to use under the GNU license

Before any update to data, it pops up a summary for approval, which lowers the risk of making a mistake

Performance is great if you need a relatively small DB

Compatible with many operating systems and integrates with many development tools

If you need a big/huge RDBMS, MySQL is probably not for you (performance-wise)

Complex joins/transaction handling causes temp hangs and performance issues--this can be improved

Fine tuning is not that easy--you'll probably need an expert (in-house or outsourced) for it

MySQL is very fast, so a request doesn't take long

MySQL has many configuration options

We had never any problems like a destroyed database

MySQL has a problem when databases are getting too big

Support for NoSQL

Very quick to get up and running - easy to use.

It can run on very small virtual machines

It performs well and is flexible

MySQL always consumes all the memory available on a box and sometimes releasing resources can be an issue.

There are certain commands that can get you into trouble and create corruption which is not easily remedied.

Transaction handling is not the most efficient and larger databases can take some performance hits.

Data security- MySQL provides a very high-level of security.

High performance-MySQL provides very high performance in terms of data mining . A huge amount of data can be easily extracted in couple of seconds.

Easy management - This is very easy to manage and easy to demo to employees so they can get hands on quicly.

I would say it has few stability issues. It crashed for me, but this is very rare.

Another thing is definitely a user cannot start using this right away without any training.

Data security

Data manipulation

Data management

Insecurity at some instances

Data loss in some cases

Data mismanagement for larger data

Cost constraints

Web based applications deployments

Small to mid-enterprise projects

Tools for performance insights.

Easy to do the manual failover.

Easy detection of errors.

Easy to check index fragmentations.

MySQL has the ability to place a breakpoint with the debugger which is a huge feature

It offers a reliable data store

MySQL Workbench works extremely well as a GUI for MySQL

Replication is easy to configure

It could benefit from wider adoption and more forums with answers to questions

It doesn't have the same level of support as Microsoft

MySQL is compatible to run on many OS like Windows, Unix, Linux.

MySQL allows transactions to be rolled back, commit, and crash recovery.

MySQL is very secure as it keeps passwords encrypted

MySQL does not support a very large database size as efficiently as other databases do.

Transaction handling is not very efficient.

SQL check constraint is not supported by MySQL.

Best in breed in open-source RDBMS databases.

Portability with our secondary database Oracle Database without much scheme changes.

Scales well with IaaS.

Some restrictions on the table sizes and schemes (unlike IBM DB2, Oracle DB, etc).

Issues with some of the SQL operations ( merge join, hash join, etc) that degrades the overall performance of the queries.

Licensing from Oracle for MySQL use can be improved.

Excellent response times when consulting data

Easy to learn, use and manage

It is necessary to invest time and effort to implement additional functionalities that are required in business environments, such as data replication.

When acquired by Oracle, its innovation speed has decreased, which opens the way for other competitors.

Very good for basic to enterprise-level needs.

Cost-effective

MySQL has some limitation with complex data types.

Limitations with common table expressions.

Easy to learn.

Easy to use and manage.

Easy to backup and restore.

Have a community version open source.

More documentation.

Efficiently manage big amount of data.

Very fast and reliable DB

Innodb tables are a huge improvement

Works very good with the open-source ecosystem, even though it was adquired by Oracle

InnoDB tables performance could be improved

Tuning is a little bit complex

InnoDB tables do not support full-text searches

Data Security, MySQL is globally renowned for being the most secure and reliable database management system used in popular web applications like WordPress, Drupal, Joomla, Facebook and Twitter. The data security and support for transactional processing that accompany the recent version of MySQL, can greatly benefit any business especially if it is an eCommerce business that involves frequent money transfers.

High Performance, Whether it is an eCommerce website that receives a million queries every single day or a high-speed transactional processing system, MySQL is designed to meet even the most demanding applications while ensuring optimum speed, full-text indexes and unique memory caches for enhanced performance.

Complete Workflow Control, With the average download and installation time being less than 30 minutes, MySQL means usability from day one.

It’s Got A Few Stability Issues

It Suffers From Relatively Poor Performance Scaling

Its Functionality Tends To Be Heavily Dependant On Addons