MySQL

Easy to use.

Lots of resources online.

Technical support is very accessible and they respond quickly.

More SQL analytic functions.

Fully support ANSI standard features.

Easy querying.

Easy, spoken English like syntax.

Intuitive.

Easier to improve how the results can be displayed.

It is designed for Web, Cloud and Big Data. It provides high availability, self-healing and data integrity, provisioning, monitoring and resource management, developer agility, and security.

There is complete workflow control, allowing users to tweak all aspects of MySQL.

There is a variety of user interfaces that can be implemented, lowering the burden on programmers.

Incremental backups take more time and hassle to configure compared to other databases.

There is no built-in support for XML and OLAP which hurts business intelligence related analytics.

MySQL has gotten farther away from the open-source mentality. MySQL has proprietary and closed-source modules.

Reliable

Fast

Can match with most of the framework

Hard to match with some frameworks

Simple to use.

Speed

Extendable.

Features for geocodes.

Data relation.

Data organization.

Management of data.

UI/UX of the platform could be improved.

Some better UI for new customers without technical skills.

Easy to deploy

Easy to manage

Free

Scalability

Reverse engineering tools

Window functions. MySQL 8, is owned by Oracle, has brought in all your classic hits for Window functions, I.E aggregate functions like sum and count over some partitions, dense_rank, lag, first_row, row_number. Now, much like Oracle 11g and above, MySQL can answer all your analytical needs for understanding your data quickly.

8 allows for JSON processing, both in and out of the database, which is extremely convenient for web applications which quite often need to call web-based REST services to retrieve such information. Gone are the days of constructing an additional Java layer for things like retrieving basic data in a GET request—MySQL provides.

Event Scheduler: Write a stored procedure to monitor and modify your data. Then create an event so that it happens automatically. MySQL makes this very easy.

The language tends to be a bit verbose at times, especially when writing stored procedures. I shouldn't need keywords like delimiters to be able to compile a procedure.

Error handling, it could be a bit simpler. You need to declare "handlers" at the moment, and in order to get the error message, it requires you to select it and know the index.

MySQL is getting rid of inline variables while querying. Boo.

Database works well with MyPHP

There is design that uses the database with Wordpress

It is easily integrated with web engines, e.g. Apache

Some migration SQL<>MySQL would be in demand

Maybe some features that MongoDB has could enhance MySQL

Maybe more GUI for simplicity of operations under a Linux environment

Consecutive Queries run simultaneously very fast.

MySQL documentation is very easily searchable online and easy to understand.

We can use it easily on the remote system as well.

It could improve its large database size.

It could provide its role and commit functions, etc.

There are a few stability issues.

Speed: returning results from broad queries are a breeze.

High Availability: some of the central themes in MySQL are open source. As a result, no "Patch Tuesdays."

TCO: The fact that MySQL is an open source project, coupled with strong support and a low failure rate, make its overall total cost of ownership very low and extremely easy to introduce into a lab or research project.

Language support: I know this is a little far fetched, but moving from one RDBMS to another is, at times, jarring. I'd like to see some compatibility with other household names (i.e. SQL Server).

Along the same line, relaxing the syntax constraints would be nice (i.e. yes/no on the semicolon. Make it optional).

MySql needs to develop its features so that it maintains compatibility with more robust and common RDBMS (i.e. Oracle/SQL SERVER).

Oracle: Oracle should really think about this: is MySQL so different from their other flagship products that they feel they need to maintain it? Why not roll it up into a single, powerful tech?

It is really powerful in terms of speed, indexing, and data storing and fetching.

It is completely free so anyone can start using it if you are developing websites or applications.

Memory issues. If we have to fetch data from millions of rows, it lacks in speed and memory.

One needs to learn the SQL language to work with it.

The main advantage is that it is an open source app, so you have the free version, and if you want the paid version, the cost is very competitive.

It does not require a team or many resources to be installed and used.

It is a good application to access databases on the internet because it connects quickly, it is very fast and safe.

I do not recommend it if you require a more robust database or for applications used by the organization with a high volume of information since it is not efficient.

Many of the utilities are not documented to improve the performance or user experience.

Free to use.

It is always up-to-date with security and new features.

Loads of resources online to learn & get instant support.

Slow at times for no specific reason.

Storage limitations, hence companies are moving towards big data

I am a Mac user, and currently I am not aware if it is available on Mac.

Import and export the databases. It shows relational graphs between the tables.

Very use full tool for area development and pilot testing.

Handling a huge amount of data and good data management.

Entry-relationship model chart.

The basic SQL functions and stored procedures.

Does not allow data partitions.

Works perfectly for small data sets.

Lack of documentation for some functions.

Difficult time to find the commands and functions.

The Community Server edition remains a strong candidate for a SQL-based database solution that supports a wide array of data structures.

It scales well for both small business and enterprise use.

It performs very well provided your database schema is well-planned and carefully considered (which is the case for any database solution).

It has a number of interface solutions including GUI-based ones such as phpMyAdmin and MySQL Workbench that allow for easy management of your databases.

Does not fully comply with SQL standards, most notably in regards to referencing foreign keys.

A major bug remains in its implementation of timestamp methods that will result in a 0 being returned for dates falling after Jan 19, 2038. While possibly not a show-stopper for most use cases, there are applications where date ranges that far out will be required (such as loan management).

Its open-source nature may not suit larger organization or high-performing systems well, which may benefit from the stronger support and scalability of premium products.

MySQL software is Open Source.

Low cost in requirements for the elaboration of databases, since due to its low consumption can be executed in a machine with scarce resources without any problem.

Easily understood documentation and great for having everything arranged in one place.

Lots of the UI is very basic and limited.

It lacks some formats.

It can be quite slow at times if it's processing large amounts of data.

The free version does every thing that I have ever needed it to do when working on a database. Some of our developers have the enterprise version, and swear that it is great but I cannot attest to that.

MySQL is cross-platform. I have only used it with Windows and Linux, but there is MAC and BSD support as well.

MySQL is very fast and can handle thousands of database records with ease.

Search function on the MySQL website it horrible. Spiceworks and StackExchange have far better results.

Documentation is in no discernible order, and there is plenty of documentation on the website but because of the poor cataloging I have never been able to find what I need quickly.

Takes a good amount of time to learn, I have been playing with it on and off for almost 10 years and I still am nowhere close to an expert.

Store Data

Easy Query Language

Simple to setup

Currently owned by Oracle

MySQL doesn’t support full outer joins

MySQL doesn’t support working with arrays

It’s available for free but provides a lot of functionality even for a free database engine. There are tons of knowledge sources out there in case we needed technical support and dealt with troubles.

Since our project was a genomics project, we handled tables with numerous rows (e.g. sequencing). MySQL is very stable and performing well in hard conditions.

There are many developers who are familiar with MySQL already, like other major RDBMS products. It is easy to hire engineers with reasonable payment.

MySQL doesn't provide good data wrangling functionalities, such as parsing JSON or XML. We had to transform them outside MySQL on the web application server side using JSP.

As we move forward to adopt more genomics information, MySQL may lack of dealing with "big data" functionalities.

It is a freely available S/W and easy to manage budget, but there are possibilities to spend cost for additional technical support.

I am able to use the online database interface PHP MyAdmin interface which is open-source, to manage my schema, manage users, and roles.

MySQL provides a nice client to manage multiple databases, remote, or local to perform database operations from a clean UI.

I am able to script database backup and restore operation very easily using a few simple commands.

MySQL integrates nicely with PHP but is also support connectors to Java and many other programming languages.

Features have lagged over the past 5 years since Oracle purchased it

The open-source community hasn't been able to make improvements to MySQL like a true open source project would permit

Upgrading from version-to-version has been a bit difficult

It's very cheap to find hosting solutions with it

WordPress and many other CMSs rely on it

There are a lot of GUI applications that make it much easier to work with MySQL

It's rather easy to understand how it works

Big projects can't rely on MySQL since it's performance is not that good

Security is one of the major concerns

We've had some stability issues with some projects with a lot of users

MySQL is first off free to use, so that makes it a win right there.

MySQL is constantly updated and security holes are patched quickly and often.

MySQL is highly customizable and allows you access to all areas of the database to use it the way you want, plus there is lots of documentation online and other users sharing their customization experiences to help you along the way.

MySQL would be useful on Mac computers as well but i do not believe they have a Mac version available yet

MySQL can be very overwhelming to get started with, so it would be good if they offered some kind of beginners tutorial for new users

Precise queries without many ramifications or connections, queries that do not require a large amount of data processing

Allows the hierarchy of database through different schemes or environments which allows having more data to be hosted with conditions and particularities relevant to each one.

It provides an excellent option to preserve the protected information. It is reliable and offers a lot of security to its users.

Complex queries usually require many resources to obtain results. Other software does not present this situation.

MySQL has stopped its evolutionary process since its change of ownership, so the changes it presents have become irrelevant to the operation of the service.

Oracle has avoided releasing the code for the detection and correction of errors so the essence of open source has been disappearing

It is very easy to set up and manage

It is very low cost

An established DBA can pick it up very easily

Good community

Concurrency on very large applications

Having a vendor to support can be expensive

Not shared disk for HA makes it more expensive and complex