MySQL

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

Easy to get started.

Lightweight, but scalable.

Well known, well supported.

Owned by oracle.

Limitations of fine-tuning.

Lack of failover.

Excellent market penetration.

Easy to get started.

Open-source license for most users.

I have only two years experience so I have not found any improvement but everything so far I used was good to me.

Quick processing.

Proven reliability.

Ease and flexibility of use.

Adding web hooks.

Support for CHECK constraints.

Hot Standby/Streaming Replication.

Popular

Improving capabilities over time

Widespread knowledge

Reactive APIs

NoSQL support

Graph data models

Opensource.

Flexibility.

Accessibility.

I have never used another database system in the past, so I cannot compare it with others.

I have no improvements that I can give because MySQL is only the one I have ever used.

Easy to spin up a database instance.

Fast.

Not great for dealing with large amounts of data.

Limited capabilities for stored procedures.