MySQL

If you are looking for a database management system which is easy to use then MySQL should be the number one choice without a doubt, however, if you are looking a platform to handle large datasets and complex queries then you might have to give it a thought.

From me as a long-term storage user perspective it's good, it's not good if you need lighting fast response time it's just not made for it u can use other NoSQL databases but for relational i think MySQL is the most newbie-friendly database in the market

From my own perspective and the tasks that I perform on a daily basis, MySQL is perfect. It has a reasonable footprint, is fast enough and offers the security and flexibility I need.

Everyone has their preferred applications and, no doubt, for larger data warehouses or more intensive applications, MySQL may have its limits, but for the area that I operate in, it's a great match.

It is a profiling tool for queries that shows information about where MySQL spends time on query, its performance and response problems by getting queries fast and takes up less disk space,

Scenarios where I wouldn't recommend MySQL:
*) If you have huge databases, in that case MySQL tends to get slow.

Scenarios where I would recommend MySQL:
*) If you have a medium size DB.
*) Need cost effective RDBMS solution

The primary scenario I would not recommend MySQL is in the case of very large databases. It is commonly known that performance is lacking in this regard. Though it is well suited to those databases in the small to medium range. I would highly recommend MySQL when integrating with other software tools. Many tools, such as Tableau, have connectors that are ready to run and hook into your MySQL database. This makes accessing the data a breeze and is very helpful when integrating with other tools.

It has some great features for storing large sets of rows so it is well recommended for storing large chunks of data. As for the less suited, it may be a bit of a hassle while trying to optimise the queries for trying to achieve better performance of the retrieval of data.

MySQL is best when used for client-specific projects with medium size databases. Whereas if the data is going to be extensive Mysql is not as suited as compared to MSSQL or Postgre.

For smaller database backends, this product works well. Our backend printer management software is using MySQL as its backend and we have not had any issues since it went live 2 years ago. It's also free so no licensing worries.

If you are looking for a relational database solution, that stores data in tabular format and with high read/write speeds, MySql shall be your choice. MySql has proven its worth for many years and still the same level of effort is going into the product for new features. In case your requirements are for a key-value pair database or graph databases, then MySql would not be an appropriate choice.

We have obtained greater speed to perform tasks specifically related to the manipulation of information. It is convenient to remotely access company, product, and business data. Purging logs is extremely easy. Failover services are optimized thanks to backups. You just have to start running the backup, and you can move that copy with your data to other servers.

We do have an interaction between Linux and Windows systems. MySQL played a vital role in connecting across different platforms. MySQL Cannot support huge data and doesn't have many debugging features.

MySQL provided very stable data base management platform to our applications with flexible management features. Also MySQL is very low footprint platform with easy database handling. when comparing with some other DBMSs, MySQL proved high storage efficiency and saving of storage space with large data sets and applications. suggest to have more native tools for replication eco systems with different locations.

Mysql is recommended when we have budget issues in our application and we need to spend less money in backend of the application as this is a open source tool and can give may functionalities, where as if our applications have need for scheduling jobs and scheduling tasks and creating queues mysql is less appropriate

It is perfectly suited for a company, that has a limited budget to pay for a database engine, and needs all of the capabilities of a paid service. Also needs complex data structures as well as connection with most of the data mining or business intelligence. Also great for open-source operating systems, because of their simplicity to install and maintain.

Well suited for the SMB environment and cost effective solution or anyone can use the community edition.

When compared to other SQL programs available today, MYSQL is both easier to use and more user-friendly in terms of its interface. I think it's great since it's easy to use for everybody, from SQL novices to seasoned pros. However, it probably isn't the best choice if you need very sophisticated features or massive scalability. You may use it on any server type, and the performance is satisfactory overall. For optimal performance, it does not require a lot of RAM.

MySQL has worked great when it's tied into other business apps and/or databases that aren't too large. Once the databases become too large, it starts becoming more inefficient and has issues at times with file corruption. I don't see MySQL being as scalable as others which can be a problem as growth occurs.

MySQL has been my go-to for making dynamic info using a database. Every site nowadays has data. It's very reliable and fast. I recently bought a book to learn more about optimization and recommend that to improve my skills.

Mysql is Fantastic for:-
1. User Management
2. Transactional Data
3. Final Reporting Data as it can be very quickly accessed and displayed on graphs

Not to be used for:-- It cannot be horizontally scaled so not suitable for very high data volumes- Should not be used for storing unstructured data- Should not be used real-time analytics, content management, document intensive storage

MySQL works great as a relational database server for web applications. It is has good programmability from PHP and runs well in any linux environment. The performance is generally good and it can run on all kinds of servers. It does not need an excessive amount of memory to run well.

It is a great product. It can be used with many types of web applications. However, it is not suitable for data analytics. We are using it with an IoT-based ERP system. In case if you decide to move to cloud, oracle provides full support to use MySQL as a cloud database service.

MySQL is really suited for a beginner who wants to use an RDBMS-type database that doesn't need any advanced features. It's also great if you want to spin up something quickly with only a few steps of installation and security configuration.

It might not be for you if you need something that needs to be massively scalable or if you need advanced features.

MySQL is free to use under the GNU license so most of the open-source, non-profit organizations can use it for free, it is easy to adapt and implement, and most cost savings compare with other SQL providers in the market. It is most suitable for small to medium projects and not recommend for banking and enterprise projects.

There are different plans available, so it offers you diversity to choose the one that fits your needs. Furthermore, I believe that through this tool, you will have a transparent idea about the entire processing of your daily work. For me, it’s a universal platform and provides you great security along with data management, so I will recommend you to use it, especially if you deal in e-commerce. This superb tool gives you a clear-cut idea about the processing of your work.