MySQL Reviews

Known and used by most people as most secure and reliable relational database management system. Accompanies 99.99% uptime. Nothing to fears as open source. Can have millions of helps through community. Offers a wide scope of high accessibility like cluster servers master slave replication. Provides high performance even for large volume projects. Growing and improving frequently. Best for cloud applications and big data applications. Supports by huge no of frameworks.

Red Hat Enterprise Linux, openSUSE, Fedora, Slackware Linux etc moved to MariaDB.

It is free to use and have a large known community of users all over the planet.

It is free to use, as long as you don't develop the applications using some strict and exclusive commands. I don't know if this have changes and by and large people don't seems to care about it, not even the owner for I have never seen or heard of anybody charged or asked about it.

It's the default standard for many companies. MySQL has grown into a very stable product that never crashes. We've made the move to MariaDB, but found that the tables sometimes get corrupted when restarting a database server under heavy load. With the recent speed improvements to MySQL, we have decided to actually migrate back to MySQL.

I'd really like if they would spend a bit more time on their CLI interface. As in, syntax highlighting in the CLI, an easier way to scroll through multiline queries when going through the history. I would also like it if we can specify a color scheme to use for the output.

MySql is the best database i have evwr used. It’s very user friendly and commands are very simple. Even if we stuck somewhere we can easily get the help while googling the problem. Support is also very knowledgeable, they respond to tickets very quickly. Replication, automatic backup are one of the best features i have used

As far as features are concerned there is nothing which i dont like. Everything is perfect including its license cost. So mysql is very manageable database

Anyone with some training and some basic technical expertise can work on it because it is simple to understand. It features a wide community base and simple-to-understand syntax for any problems or queries.

When handling huge databases or making changes to many records at once, MySQL can become noticeably slow. There might occasionally be a stability problem.

First it is easy for one to learn how to use this software. It is also an open source that is one can get it online for free. Another thing I like about this software is that it works well with different programming languages as well operating systems that are Windows, Linux and MacOS. Lastly it is fast and installation is simple.

It's slow when running large databases. Using it can also be hard for people who have no experience. Lastly is the user interface that is workbench, it is not interactive thus it needs some changes to improve it's performance.

The infinite documentation for any OS/Language combination to develop with MySQL is astonishing. You just need to go to google and search your question regarding a problem or a best practice with MySQL and you will find it, for sure. Installation is a breeze in any OS I installed on. Just a few clicks and you are done. If you got lost (hardly), google it and have your answer.

You still need to work with plain text files for advanced configurations. Stability its been improved with each release, but hurts performance by little.

Database queries are easy to understand and write in MySQL. It is widely used as a database management software and thus, has very good community support.

The time required for query processing is more if the dataset is very large. Sometimes the error messages prompted by MySQL are difficult to understand.

+ transactions support+ JOIN support+ easy to manage (via phpMyadmin)+ high performance (thank you InnoDB!)+ open source (a lot of support online)+ secure+ popular (thanks to open source)

- not for a newbie (some DB knowledge required)- transactions are not so effective as in PostgreSQL- sometimes unstable (large DBs)- hard to scale in complicated projects (large DBs)- hard to debug (without addons)

Simple and easy to understand, i.plements features and functionality. it is very efficient to generate reports invoking RDBMS.

Sometimes, the software takes time to upload a large database.

Wow where to start! The two main highlights are the ability to create highly customizable indexed data tables and the ability to query them in incredibly flexible ways! When one creates a table in MySQL, one has an option to create a primary key which is unique for every record in that table. That can then be used to easily search and reference the data in that table. One can also mark other data...

Read more

I think the biggest downside to MySQL is that there is quite a learning curve. You need to be good with structuring and organising data in theory/planning first before you approach this database language. It is only a tool, it will not do the design and architecture for you. Once you know what you want, you need to work through some tutorials and code examples to understand how to use MySQL. There are good database managers that use MySQL, suchas DBeaver or HeidiSQL, that will greatly assit you in the process - but you still have to understand how to write custom queries, so take some time to learn the language. If you don't have the time, consider maybe MS Excel or MS Access - less flexibility, but also a smaller learning curve.

Speed. MySQL is fast! Now, fast is a relative term which depends on workloads, database design and more. I work in Small and Medium Businesses space where a couple hundred GB of data in database or less is common. MySQL's performance has been blazing fast in majority of the installs with default or with slight change in configuration.

Confusion of selection is the least favorite. MySQL Community/Enterprise edition from Oracle is the most common for those who know MySQL. If you are new to MySQL and researching it for your small business, you'll inevitably come cross MySQL from Oracle, MySQL from Percona, MariaDB etc., which makes your selection process harder. I recommend installing MySQL downloaded from Percona. If you want support, Percona provides that too at a reasonable cost.

Mysql is a good tool to start in the world of software development. It offers a small but powerful product, with effective database management when it comes to bringing us useful information for the business. With a few command lines we can get all the information we need, and its installation and first use is fast and intuitive.

Although MYSQL works well for small and medium projects, in large-scale projects we can suffer a bit with information and data management, since this tool is not entirely designed to handle large-volume data. It can handle data in large volume, but the way in which it will do it will not be the most efficient or the most optimal, which can cause a certain lack of speed when deploying our project.

It's so easy to setup. Just install via package manager and you are up and running. If you need more features, just customize the setup files. Replication, Backup, all is working out of the box.

Creating a database and adding a new user must be done in sql. For this step an installer/menu would be great since I've to do this very often.

The best thing about MySQL is that it is Open Source. The total cost of ownership in a production environment is very low and performance wise, it is very high performance database. Also, the support for MySQL over the internet is vast and very helpful.

The thing I like the least about MySQL is it requires a steep learning curve and one must be familiar with SQL concepts in order to use it efficiently. Also, for complex business logic, it tends to get very hard to handle.

It is a manager that is very easy to implement, adjust and configure based on the needs that you want to meet. The resources needed for its implementation are low, being able to increase them based on what is required, being able to carry out a more adequate distribution of resources.

The replication and backup tools of the same software have limitations that end up affecting their operation, having to use other means of control and restoration to improve results.

Flexibility and 1st level support from most application servers via JDBC ODBC connectorsMost cloud providers offer Mysql as SaSS or additions to PaSS offerings - so in terms of reducing costs to run mysql instances, these can be placed under op expenditure.

Standalone product support can get expensive (from Oracle).Database restore for master/slave replication can get complex with bin log files manual adjustments being required to fully sync replication.

Mysql is Transactional, you can commit or revert a set of actions in a transaction, it has well implemented all the Transactional feature such as primary key, foreign keys, indexing etc ... so we mainly use mysql for data collection from realtime interactions with the end user, Its Hibernate support gives a edge on realtime interactions, Mysql provides many type of JDBC/ODBC jars, using which it...

Read more

Mysql dose not support data transfer between DB and Distributed file system such as AWS S3, which most of the other databases dose, We had to use different PSQL database for large non relational data storage, since it is not the intended purpose of Mysql, so we have to maintain two database systems, it wold be better if mysql can give non transactional support as well for large data storage and analytical use case , so that it can be one stop DBS solution for all data actions.

In my opinion, MySQL has the following main advantages: 1. It's versatile and adapts to different use cases. Although MySQL is most commonly used to manage data for web applications (in what's called LAMP: Linux, Apache, MySQL, PHP), it's really a jack-of-all-trades that one can use in different scenarios. 2. It's rock-solid. MySQL and its featured stability have both passed the test of time; the...

Read more

The way I see it, MySQL has two disadvantages: 1. Depending on the amount of data it handles and on how many clients connect to it, MySQL can use a lot of resources, effectively becoming a server hog and therefore requiring a powerful computer/server. 2. MySQL isn't exactly the easiest software to install and manage; it requires quite some technical knowledge.

MySQL is open source software that allows anyone to use it and modify it. Anyone can download the MySQL source code and use it without paying. Anyone interested can study the source code and adjust it to their needs. MySQl is a relational, multi-threaded and multi-user database system with more than six million installations and is widely used in web applications, such as Drupal or phpBB, on platforms...

Read more

A large percentage of MySQL utilities are not documented. The support for triggers is basic so there are certain limitations in what can be done with them. By handling referential integrity with non-transactional MyISAM tables. It does not treat them differently from the rest of the fields. Privileges for a table are not automatically deleted when a table is deleted. A REVOKE command must be explicitly used to remove privileges from a table.

I used MySQL in a project that was covered under the GPL license thus it was free. This helped My company save a lot of expenses compared to when we were using another DB software. My adaptation to MYSQL was quick based on my previous use and knowledge of MSSQL which have similar Coding structure and many parallel functions. MYSQL, been open sourced means that there are tons of thousands of supports...

Read more

The need for technical support is overwhelming even though you will most likely find help on the internet. It is difficult to get your actual database performance base on your system specs adaptation like memory utilization and usage during different calls. There is a shocking lack of documentation for many functions embedded within the program and I had to resort to the internet to uncover their uses. You...

Read more

MySQL is the simple, fast, popular open source and freely available database for software developer. MySQL provides adapter to integration to almost all types of programming languages. MySQL query syntax is easier to learn compared to all other database management software. It also support highly complex and advanced SQL queries. It is being maintained by Oracle. MySQL has good documentation. MySQL provides a tool called Workbench to write queries and look in the table data. MySQL provides the indexing and hashing for faster reading of data.

MySQL doesn't support complex data types like: JSON and ARRAY. MySQL does not support SQL check constraints that is used to validate data stored in a column. MySQL doesn't support common table expression. MySQL doesn't support full outer joins. It is costly to increase connections limit in MySQL.

MySQL is a powerful tool for handling large databases without the fear of any data loss. It enable users to integrate with different tools. There is a huge collection of free plug-ins. Despite it is an open source, it provides a high data security that helps to protect data in a well organized manner. Solutions are readily available on forums for any type of problems. The web interface has made the installation setup and configurations much more easier.

It does not support most of the useful features that modern database tools support like ROLE and COMMIT. It does not handle large databases efficiently and performance is bit low. I believe you do get what you pay for. Although, it is a great free of cost product.

I been using MySQL Since it's invention. I use MySQL to create user databases for user profiles, Order tracking and website user data management and it has done perfect on the website software i use such as WordPress. vBulletin and a range of other website based applications. I also use MySQL for my video/audio chat application to start users chat profiles.

Sometimes hen your importing large MySQL databases from one host to another it can be challenging. Sometimes the process breaks during upload or importing and you have to start all over again or the import doesn't fully import everything and there is website issues so keep that in mind. I found a way around this alot of times by just using big dump. Other then that over the years it has been getting better and better as of the latest version i must say that it is running so far flawlessly.

MySQL is a robust, well document, secure, and interoperable database system software. Almost everyone, all the way down from the vast majority of cheap shared hosting providers up to enterprise cloud hosting providers has support for MySQL databases. I don't need to know how to write queries to use it as there are a number of visual tools to write and execute queries. It is scalable. A project can start small on a single server and grow huge to work in a distributed cloud ecosystem.

Learning MySQL is a steep learning curve however you don't have to learn it in most cases as there are frameworks, and visual tools that create MySQL queries for you.