Mysql is the best way to interact with the sql database. It offers the best available security towards sql database and maintenance. It takes care of large databases to be optimised and responsive to every action. Review collected by and hosted on G2.com.
Apart of a lot of features and data security enablers, it also raise some issues towards large data uploading and downloading at once. Also some backups interrupt while delivering data from it's database to the system. Review collected by and hosted on G2.com.
My favorite thing about MySQL in general is that it is very easy to code in. I have a lot of "new to coding" members on my team, and I find that using MySQL to code has helped them to pick up quickly. For example, the coding is very straight forward to English when using the expression "WHERE VARIABLE LIKE '%WORD%'". Review collected by and hosted on G2.com.
My biggest dislike about MySQL is when you run a line of code that fails, the error message is either vague, or way too long to explain what actually happened. I have coded in R, and it explicitly tells you what is wrong, where with MySQL, sometimes you have a weird error message that you have to google, but the error only showed up because you forgot a comma or something simple like that. Review collected by and hosted on G2.com.
Mysql has a lot of efficient and amazing features to be used starting from it's efficiency to hold large datasets in form of well managed tables rows and columns structure. It provides best data security at some loss of data at places where it kept a loop hole. It is therefore the best used databases in the every sector despite of handling some large databases at it's initial setup. Review collected by and hosted on G2.com.
Although Mysql is something that has efficiently build and has a lot of effective features to be used but aside of that it states some problems which includes data loss, insecurity at some places, data mismanagement when it gets larger. And with that it is not adorable to be used like this in any growing corporate industry. Review collected by and hosted on G2.com.
It is easy to configure and manage. It is a great solution for an enterprise level DB without the enterprise level costs. The interface is a bit lean, but still very manageable. I love the ease of setup and configuration and management via the included web interface or you can get custom tools to manage it. I like options! Review collected by and hosted on G2.com.
It doesn't have all of the features DBs like MSSQL or Oracle have that would make some admin easier, but it isn't really that much of an impediment. I think the web interface can be a little more robust and have more features for management. I guess you do get what you pay for. Overall it is a great product though. Review collected by and hosted on G2.com.
Mysql is a software that is easy to deal with, it's is an open-source software which means it can easily customised and can be extended on demand. It is well known for it's high performance and security of data it holds. It offers complete control of it's workflow of data due to it's open source and highly scalable behaviour. Review collected by and hosted on G2.com.
Mysql is used for better transaction with sql database but then also it causes some query fallacy sometimes while multiple transactions occurs simultaneously. Mysql is also causes data loss problems at entirely vast database and tables of data. Apart of this mysql is also causes some redundancy and mismatch of data especially while dealing with primary key attributes. Review collected by and hosted on G2.com.
As we know that mysql is widely used and adopted, it offers great performance along with easy to use interface and features for it's users. It acn be configured over WAN and LAN networks. It arranges data in structured manner which makes it simple and clear design to understand and tackle with it accordingly. Supported by a wide range of softwares and servers. Review collected by and hosted on G2.com.
As we see it's structure and working we will get to know that it's not start out as RDBMS which limits it user's area. It is open source which raise a risk of data loss at replication. Because of it's structural design it doesn't have any automated switchover or overhead. It has tough scaling and it is not community driven it is owned by Oracle. Review collected by and hosted on G2.com.
The Mysql is reliable and can be trusted for performance. It provides a low-level graphical interface that makes it easy to understand what to do and where to do it. It supports questions that are mostly written in English sentences that can be explained in the same way as English. Also mysql is used to work with large datasets which can be further used to work in our premises. Review collected by and hosted on G2.com.
This has performance-poor scaling. It does not support some modern database features such as ROLE and COMMIT that are required in any database. Additionally it causes some stability issues below version 5.0, does not have some features and after that version it becomes less compatible for older systems. It can be used to hold data but to a certain extent, there are some limitations to its use. Review collected by and hosted on G2.com.
Some of the major advantages of MySQL include data security, on-demand, scalability, high performance, the flexibility of open source, reduce the total cost of ownership as you will use it to make your own server, it comes with 24x7 assurance and a lot of solutions available on the forum for a different type of problems. Review collected by and hosted on G2.com.
MySQL does not support a very large database size as efficiently, it also does not support ROLE, COMMIT, and stored procedures in the versions less than 5.0. Transactions are not supported efficiently. There are some stability issues. It also suffers from poor performance scaling. Review collected by and hosted on G2.com.
Mysql is an open source database which provides the actual idea of internal functioning and build structure. It support comprehensive transactional ability. It has a powerful build quality that is helpful for handling large data so that no dataloss occurs or data should be consistently available for processes. It also offers high data security that will help to protect data in efficient manner. Review collected by and hosted on G2.com.
It occurs some issue like in the lower version before 5.0 it doesn't support ROLE, commit. It also incurs some stability issues. Requires high memory to process as well as difficulty to debug and maintain the data inside. It also offers some sort of inconsistencies when used with other tools and softwares. Review collected by and hosted on G2.com.
If we talk about the best in MySQL then I think everything inside it is the best. Strong behavior, consistent nature, helps to integrate with big data to handle it, starting with atomic-like properties and working together and never disappointing you. It is easy to implement the query language to use it. Also, installing this server is the easiest task among the rest of the database servers. Review collected by and hosted on G2.com.
As we all know that nothing is right in this era, this database has some errors and limitations in its favor. Like I encounter a problem when using, when I need to store more than one value inside the cell of a table in MySQL, but it will not allow me to do so. However it also has some restrictions that use integer fields as primary keys and foreign keys. Review collected by and hosted on G2.com.
This is likely to be the best database for MySQL. It has many obstacles. In addition, it provides security, system wide compatibility, reliability, redundancy and more for users. It has a good password protection protection enabled that keeps it secure and robust to use. It has a good range of constructions that can be used to create any type of field that can store URLs, images, text, numbers, here we will keep blank fields to fill later, which is the default or Can be set to zero or blank. Review collected by and hosted on G2.com.
MySQL is the best database to use for every level of work, it can be either beginner level or master level. This provides a good service, but sometimes it limits the user to usability by entering the same exact data defined under the field. Also this field does not support multiple inputs at the point of instance which causes the creation of some more tables to handle the data. Review collected by and hosted on G2.com.
It's the best and one of the simplest RDBMS for a newbie to get started. I started learning this when I was early in school in my undergrad. To date, this remains my favorite.
The query and its syntax are easy to learn and grasp for a newbie. Review collected by and hosted on G2.com.
Well, there is nothing that I dislike about it. I used it in my grad school as well. At first, I was unhappy that it did not have a graphic based interface but then they came up with Microsoft workbench. Review collected by and hosted on G2.com.
MySQL provides a very basic graphical user interface. I love it because it's not hard to understand the roles and commands. Also, the other best thing I've experienced is that it's got very full and quick import and export tools. Another favorite aspect that helped me a lot is that there is a variety of helpful documentation on the web in various languages. On the other hand, it runs very well on Linux servers, which are the ones that we have in the company. Another major benefit I have experienced while using it is that It is the best method for building data tables to manage and archive data in a standardized manner. It is conveniently compatible with other app programs. Review collected by and hosted on G2.com.
I'd say the biggest downside I've come across when using it is that MySQL does not support very large storage sizes efficiently. The main disadvantage for me is the size of the data and it creates an inconsistency when dealing with massive datasets. There are low output scaling and reliability problems. It also does not support stored procedures in versions other than version 5.0. Often it hangs quite a bit because of queries that return a huge number of rows. Also, I have found that it becomes impossible to move that huge database to another server. It is fine at an early point, but not long-lasting. Review collected by and hosted on G2.com.
This is the best example used for database tools. It is an excellent tool for creating, deleting and manipulating data in a database. It is easy to use and very reliable in nature. It is an open source tool which makes it open to reach and develop new heights of development in the region. At the same time it is a bit expensive which makes it different from other devices and sets the best example for widespread use of devices. Review collected by and hosted on G2.com.
Mysql is an efficient and optimized tool to use, but again despite excellent support it offers some relatively scalability issues that make it relatively poor to use in an open manner. Development in the database is not community-driven. Review collected by and hosted on G2.com.
MySQL is really reliable and quick in processing which provides us stability in our day to day business processes. It is very easy and flexible to use in all environments. Syntax is very easy and well designed which helps us in writing queries easily and learning faster. Review collected by and hosted on G2.com.
Not very easy to match with some of other frameworks. Massive amount data retrieval can be lag but does not happen often and hope the development team can try to improve this. May be some more documentation can be help. Review collected by and hosted on G2.com.
MySQL supports a detailed documentation that is the best and functions every part of it. This documentation will be updated from time to time. It also supports a wide range of operating systems to support execution and since it is an open source product, there is no license fee to use it in any way. It's queries are easy to write and understand and can be used efficiently at places. Review collected by and hosted on G2.com.
It does not support any property of isolation and atomicity for queries. It is very expensive from the hardware side and uses too much RAM in backend runs. There it takes a lot of time when getting data with multiple sub-queries and even when we try to fetch a table with multiple rows of data. Review collected by and hosted on G2.com.
Database design, ease of maintenance, optimization and tuning, reliability Review collected by and hosted on G2.com.
MIgration to version 8 changed authentication from mysql_native_password and as a sysadmin you spend some time to make things work again. Review collected by and hosted on G2.com.
* It is a platform that can be implemented on any operating system.
* MySQL is open source software, so there is no license fee.
* The syntax for the queries is very simple and its response times are very short.
* Has a database manager or interface (MySQL Workbench) where large amounts of data can be imported / exported and perform a large number of operations.
* Most developers and large companies develop apps using MySQL as a database, so there is extensive documentation. Review collected by and hosted on G2.com.
* It is a difficult database to scale when there are problems in the database.
* May require high CPU resources when performing multiple queries. Review collected by and hosted on G2.com.
MySQL is a simple database and it has been very popular over the years. I think its most important factor is the ease with which you can learn the syntax of your queries. Furthermore, I also like the fact that it has extensive documentation, which is constantly updated. In addition, they have an application called Workbench that offers a nice graphical interface and tools to do different tasks to the databases, such as import and export of data, performance reports, and tools to add, remove or remove tables. Review collected by and hosted on G2.com.
Sometimes migrating large databases from one server to another can usually be a cumbersome process, since the default server configurations do not support reading large amounts of data and do not have long runtime. Review collected by and hosted on G2.com.