MySQL Features

MySQL is the standard database software used by virtually all the PHP-based scripts for database creation and functioning. It is a standard add-on software for most webhosts as part of the cPanel plan. As long as you are not hacked, the database software works quietly in the background 24/7 and delivers your website to the world. As an "add-on" software it is free in that sense (or may be part of my monthly hosting fees), but this is a trivial point. MySQL is like a set-and-forget kind of software, and indispensable to nearly all webmasters.

The database is not very efficient, and this often leads to errors, if some script overloads it or if your website is hacked and compromised. If there is too much traffic, things also can break down. As anything database related is hard to repair, it is best to get an expert on MySQL, who can be expensive, to fix any issues in the database. Many additional plugins create further tables or rows in MySQL which remain there for life even if the plugin is removed later on. This leads to bloat in the database.

MySQL is so easy to use and comfortable, even a lot suitable for the WordPress platforms. I like how this database has organized everything, backup process, data replacement, adding or deleting tables, find out the important data even query. If I want to do something, I can write some code as commands and all done. This database supports a query language too.

There are no cons I've noticed with the MySQL database. But I think it should be easier because newbies will get confused while using and learning MySQL. With little knowledge, you can't manage and control the MySQL database.

In first time it's open source and it capacity of large amount of data management

Cluster creation is not simple to manage

MySQL is a powerful database management system. It is free. Easy to learn and use. I someone new to DBMS. We can recommend that person to MySQL without any trouble. It is supported to any environment. If your server/PC windows, Linux or Mac. It doesn't matter. MySQL support for all Operation systems and very easy to set up in any environment. We can tall like this if we think about the setup and configuration...

Read more

Actually, It is a relational database. Therefore before the database creation, You want to create ER-Diagram otherwise you are in trouble. When the relationships are increasing. Hard to insert data. As well as. MySQL is not good for large databases. If relations go very hight. data retrieving speed is going down. If table storage is hight, data retrieving speed is going down. If connections are going hights. It returns too many connection errors and MySQL down. We want to restart.

The platform is stable - always working. Documentation is consistent. Updates are coherent and stable. We use it in 95% of all our projects, and it has been a life saver for our bottom line.

Choosing the right tool to download was confusing. Obviously written by developers instead of management. I'd suggest a 2-4 step process to help in choosing the right packages. The setup process could use a bit more explanation and be more lucid.

Large and experienced community. Any question you have - someone has already asked it and received a good answer. Unbeatable stability. Decent performance. Keeps improving over the years without many breaking changes. You can be almost sure that code written 10, 15 years ago will work in the newest versions.

Misconfiguration can lead to freezes and crashes, default configs aren't a good choice in most cases. Takes a long time to restart. SQL will not perfectly match your project logic - you have to learn to think in SQL if you want to have a data architecture that works well.

MySQL is an incredibly powerful and versatile open-source relational database management system. It is easy to setup and use, and it is highly customizable, allowing users to tailor the system to their specific needs. The sheer number of features and capabilities available makes MySQL an ideal choice for businesses of all sizes.

MySQL can be quite difficult to understand and use for those who are not experienced with databases. The complex nature of the software can make it difficult to troubleshoot and maintain. Also, some of the features are not always as intuitive as they could be, which can make it difficult for novice users to understand.

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.

I enjoy MySQL as a web-based SQL database tool. In particular, it's comparability with PHP makes it a formidable tool when creating hosted web applications. I myself have used MySQL to create MANY web based databases for web applications, websites and CMS powered websites alike. Very few downsides to using MySQL and it's basically globally accepted by the Web Development community.

Very few things. If I had to pick something I would say that the PHPMyAdmin user interface for MySQL databases could definitely use an update. To be honest though, I'm not even sure if PHPMyAdmin is a part of MySQL or cPanel itself so take this criticism with a grain of salt.

Currently we have many different types of DB on the market (No SQL and SQL). I spent the past 3 years working with MySQL and completely feel in love with the many of its' feature. * Once you become familiar with the features and the commands, you will find it is super easy and flexible to operate. I interact with it via both the CLI (Command Line Interface) and GUI (Graphical User Interface) and just...

Read more

Looking at the NoSQL DB (MongoDB) which uses a document type format to save data in their DB, I would say one of the feature I believe is missing or could be improved, is the way data is stored. What I mean, is that currently in MySQL, if the field is not created, you can't insert data as it will not automatically create necessary fields, while with MongoDB, if the particular field has not been created before data was inserted, it will be done on the fly while uploading or inserting data.

MySQL is very fameous data base software.It is a first data base software which I use to develop my first POS system program.It was recommend by my friend and he said that it is very fast and reliable data base program but also it is very simple to understand and work with it.There for I choosed it and he said true.It is very easy to learn and work with it and I simply got familiar with it in a small...

Read more

Mainly MuSQL is my favorite data base software and I havent many drawbacks of it.I think it is better to replace more user ffriendly commands in MySQL library for JAVA.Some times it get tricky to some commands in MySQL from JAVA by using the library.But it is not a big deal.Many Programing softwares are suggest many programing key words ttherefore coding is getting very easy.But when getting to code MySQL commands , some programing platforms were unable to suggest key words and cods ththerefore I think that must be improve more.Considering security I heard that there are many more secured data base software in the feild.So I suggest to improve the security of MySQL data base.

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.

MySQL is easy to install and configure. You can quickly set it up in no time.

So far for our usage, we are satisfied with the features.

iv'e been developing for a few years now and using MySQL has made my programming an absolute breeze. MySQL is designed to focus on big data, especially for web development I originally used Microsoft SQL Server but chose to use MySQL instead which provides a great opportunity for a platform that is easy to integrate., is easily scaleable and has great data integrity. As i use MySQL for my company,...

Read more

Porting a MySQL application to Microsoft SQL Server, or to a competing SQL database engine, requires a significant amount work. as MYSQL is not backward compatible. Although in theory it is scalable up to 8 TB, MySQL can not work efficiently with large database.

I have been using MySQL for several years and I have to say, it has proven to be a reliable and powerful database management system. It offers robust data recoveries options such as binary log and InnoDB crash recovery, which gives me peace of mind knowing my data is safe. The data dictionary feature is also extremely useful, it makes managing the database and optimizing queries a breeze. Overall, I highly recommend MySQL to anyone in need of a solid, open-source database management system.

I have been using MySQL for some time and I have to say, I find it to be quite cumbersome when compared to newer non-relational databases. One major issue I have encountered is the difficulty in handling large amounts of unstructured data, which is common in many modern applications. Additionally, the rigid schema and the effort required to maintain it can be a big headache, especially in a fast-paced development environment. These issues are typical in traditional RDBMS like MySQL and are less prevalent in Nrdbms

MySQL's compatibility with various platforms and extensive support for programming languages contributes to its versatility, making it suitable for diverse applications. Moreover, its extensive online community and detailed documentation make troubleshooting and learning effortless.

MySQL lacks some advanced performance optimization features found in other database management systems. This limitation may require additional effort to optimize complex queries manually.

I am quite amazed by MySQL and the outstanding features it provides. MySQL has played a significant role in my professional development as a database management system by giving me a dependable and effective platform for storing, managing, and retrieving data. My favorite aspects of MySQL are its scalability and robustness. It is able to handle high data quantities with ease, ensuring optimal performance even in demanding settings. MySQL is an excellent option for both small-scale projects and enterprise-level applications due to its simplicity of use and flexibility. Its broad support for a variety of platforms and programming languages enables me to easily include it into my current software ecosystem.

Even while my overall experience with MySQL has been favorable, there have been a few things that I've found difficult or that could be done better. I thought the complexity of managing and establishing replication setups was one area that needed improvement. In some cases, setting up and maintaining replication in MySQL requires complex setups and a thorough understanding of the architecture.

MySQL is free and open source software.It has a large community of users and developers.It is easy to learn and use. It is portable and can be used on many different platforms. It is fast and efficient.

The only downside to MySQL is that it can be a bit slow at times. This is usually when I am running a lot of queries at the same time. Overall, though, I have been very happy with MySQL.

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.

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.

There a whole world of documentation, best practice, books on mysql. It can be found on nearly any cloud, system, paas. It is really fast (on MyISAM), support transactions (InnoDB), may perform as in-memory cache (memory), or even CSV (never use this one except for testing or reports). Deploy and set up takes next to no time, it consumes very little resources. Actually I feel it is hard to write...

Read more

First and biggest cons is that MySQL is not suitable for big amount of data. It always had and still have troubles performing complex joins. Database may get corrupted under some scenarios when significant selections is performed same time as other clients perform batches of inserts/updates (basically, there is a long lasting bug in memory management). Transactions are available in a single engine...

Read more

The thing I like most about MySQL is, It is available for multiple operating systems like Windows, Linux, etc. It is free and open-source. It is very lighter in comparison to MsSQL and very fast. It is very easy to learn and use. It is very easy to install, configure and manage. The syntax is very identical to the same we use sentences in English. It is capable to hold large data in tables. It is best free database with enterprise level features. It is supported by almost all popular programming languages. There are numerous 3rd party custom tools available for it.

With huge data, I had faced data loss and improper data retrieval but it is very rare and manageable. Some of the error messages are so general and unable represent the actual problem. Some error messages are so weird then the actual problem. It gives sense of insecurity at some points.

MySQL is a well balanced product, while it is free to use, it also has many features you can find in corporative solutions, like SQL Server and Oracle. If you ever need help, you will find answers almost everywhere, from their own documentation to stackoverflow and other forums, easily. You will have a very short learning curve with MySQL.

When you need to deal with great amount of data, like some kind of data warehouse structure or huge amount of measures to analyze, you better go other choices. It starts getting too slow with the same hardware other products will work smoothly. But I guess that is not the purpose for MySQL. In the other hand, if you want it to build a transactional system like an e-commerce platform or even a Blog page, it is a very good choice!

MySQL integrated really well with the PHP scripting language. MySQL is what is called a Relational Database Management System (RDBMS). It is a software system that uses the SQL database query language to manipulate data in a database. MySQL provides for data handling, storing, modifying, and deleting in a tabular format. You can design your database so that each table has a key to at least one other...

Read more

The MySQL reference manual is not clear enough in describing how to utilize many of the features for MySQL. The manual is too technical and apparently is designed for persons with a high level of computer programming or technical knowledge. The manual is sometimes confusing when seeking to find the proper column type to use (i.e. TEXT, CHAR, VARCHAR, etc.). The Date and Time functions for MySQL like DATE and DATETIME are hard to understand and difficult to implement. The table join features are difficult to understand and use.