MySQL
JetwareExternal reviews
1,619 reviews
from
and
External reviews are not included in the AWS star rating for the product.
A great free database management system
What do you like best about the product?
I like how many resources are available for MySQL, as well as how many other services integrate with it.
What do you dislike about the product?
I dislike how vague error messages can be, but this is common in a lot of database database management systems
What problems is the product solving and how is that benefiting you?
We use MySQL to manage all our data going or our in house reports and services. It allows us to quickly store and retrieve data, and integrate with a lot of other products and services.
Recommendations to others considering the product:
Ensure that a relation databse is right for your needs.
Very popular and open source database.
What do you like best about the product?
With MySQL and its proven performance, reliability and ease of use, it has become the main option I use for database in Web-based applications. In addition, it is an extremely popular alternative as an integrated database.
With its latest version, MYSQL 5.0 append new important features that make it more competitive with drivers such as SQL Server, Sybase and Oracle.
Something I find very fascinating in this new released version I can summarize it in this way:
Use of transactions ACID (Atomic, Consistent Isolated, Durable): To build more secure applications through commit, rollback, crash recovery and blocking by registration.
Store Procedures: To improve programming.
Triggers: To improve business rules.
Views: So that sensitive information is more secure.
Information Schema: For easy access to metadata.
Distributed Transactions (XA): To support transactions between multiple database environments
With its latest version, MYSQL 5.0 append new important features that make it more competitive with drivers such as SQL Server, Sybase and Oracle.
Something I find very fascinating in this new released version I can summarize it in this way:
Use of transactions ACID (Atomic, Consistent Isolated, Durable): To build more secure applications through commit, rollback, crash recovery and blocking by registration.
Store Procedures: To improve programming.
Triggers: To improve business rules.
Views: So that sensitive information is more secure.
Information Schema: For easy access to metadata.
Distributed Transactions (XA): To support transactions between multiple database environments
What do you dislike about the product?
The new features in turn also bring with them new problems that until now are supported by technical support. for example:
Mirroring with disconnected states
The message is duplicated in / etc / motd
filter a message in the log messages
validate the execution time of a process
Statistics in the database
but as I have indicated before, these problems are already being solved by the trained personnel. And by the way, I mention that he is very trained and I congratulate him
Mirroring with disconnected states
The message is duplicated in / etc / motd
filter a message in the log messages
validate the execution time of a process
Statistics in the database
but as I have indicated before, these problems are already being solved by the trained personnel. And by the way, I mention that he is very trained and I congratulate him
What problems is the product solving and how is that benefiting you?
having acquired the license for MySQL server we have eliminated great problems with this manager of tados and has resulted in immediate progress with the company. for example: we have equipment inventory control and the same website of the corporation is managed with said manager.
certainly this tool is very attractive, I hope to continue giving the required use and to continue improving its performance
certainly this tool is very attractive, I hope to continue giving the required use and to continue improving its performance
Recommendations to others considering the product:
I recently made some basic adjustments to improve the performance of MySQL. By adjusting these parameters properly, you can obtain many improvements in the performance of the database, especially if the database server does not have enough resources, and if the SQL optimization part can not be improved much more.
First of all, it can be very useful to take a look inside phpMyAdmin to the sections 'Show MySQL runtime information' and 'Show MySQL system variables', normally accessible from the main page of the application.
The first shows information and statistics that the system collects and maintains from its start. Special attention must be paid to the values of the variables shown in red, and to the tips indicated to the right of these values.
in summary you must have high knowledge of this manager to make changes and adjustments to the required level.
First of all, it can be very useful to take a look inside phpMyAdmin to the sections 'Show MySQL runtime information' and 'Show MySQL system variables', normally accessible from the main page of the application.
The first shows information and statistics that the system collects and maintains from its start. Special attention must be paid to the values of the variables shown in red, and to the tips indicated to the right of these values.
in summary you must have high knowledge of this manager to make changes and adjustments to the required level.
One platform for most database needs
What do you like best about the product?
Easy to use platform that helps resolve most is our database needs. We can store information in the form of tables and query the tables later to extract that information. Thereby making our lives easier.
What do you dislike about the product?
Nothing in particular. MySQL is a good querying language.
What problems is the product solving and how is that benefiting you?
Querying database
MySQL is the goto for LAMP Developers
What do you like best about the product?
Ease of use, speed, and greatly documented.
What do you dislike about the product?
I don't have any dislikes about MySQL. If I had to really beat on anything, it would be the process for exporting and importing a database can be a little bit difficult depending on versions, but it's really not that bad.
What problems is the product solving and how is that benefiting you?
I use mysql to organize and store data. This may be user data, or information and content for blog posts. I use MySQL as the layer that keeps all the information organized and maintained, and able to be queried.
The all around best database for software applications
What do you like best about the product?
With only a small amount of simple syntax I can define all the necessary actions to build, maintain and access a database. Using MySQL is straight forward and intuitive. With a some practice, you can easily build a database for any application. The stability and scalability make it great for building large scale applications.
What do you dislike about the product?
It can be difficult at times to correct a mistake after you have run an incorrect command. Once a change has been made to a database it is very difficult to undo it. It would be nice if there was an easier way to revert to an older version of your database or an undo feature. Additionally it would be nice if there was a way to build a sandbox version of your database and then automatically update the live instance with changes from the sandbox after testing to insure safety/functionality.
What problems is the product solving and how is that benefiting you?
I have been able to use MySQL to build databases for smartphone and web based applications. It is a very efficient and dependable solution for storing and accessing data for applications with multiple users like social media apps and information sharing services. I can't see myself choosing any other database for mobile or web based applications in the near future.
Recommendations to others considering the product:
If you haven't done database and also basic programming before then you should learn some of each before attempting MySQL. Taking a tutorial on SQL would also be good for first time users.
Great experience
What do you like best about the product?
I had really great experience with MySQL because it provides utmost Data security, high performance, compatibility ,On-Demand Scalability, Comprehensive Transactional Support, and round the clock uptime and flexibility of open source , Reduced Total Cost of Ownership and also complete workflow control
What do you dislike about the product?
Memory usage increased: If we use many stored procedures, the memory usage of every connection that is using those stored procedures will increase substantially.
Restricted for complex business logic: Actually, stored procedure’s constructs are not designed for developing complex and flexible business logic.
Difficult to debug: It is difficult to debug stored procedures. Only a few database management systems allow you to debug stored procedures. Unfortunately, MySQL does not provide facilities for debugging stored procedures.
Difficult to maintain: It is not easy to develop and maintain stored procedures. Developing and maintaining stored procedures are often required a specialized skill set that not all application developers possess. This may lead to problems in both application development and maintenance phases.
Restricted for complex business logic: Actually, stored procedure’s constructs are not designed for developing complex and flexible business logic.
Difficult to debug: It is difficult to debug stored procedures. Only a few database management systems allow you to debug stored procedures. Unfortunately, MySQL does not provide facilities for debugging stored procedures.
Difficult to maintain: It is not easy to develop and maintain stored procedures. Developing and maintaining stored procedures are often required a specialized skill set that not all application developers possess. This may lead to problems in both application development and maintenance phases.
What problems is the product solving and how is that benefiting you?
Increased the performance of our applications- MySQL implements stored procedures slightly different which helps in increasing the performance of the applications. MySQL stored procedures are compiled on demand. After compiling a stored procedure, MySQL puts it into a cache. And MySQL maintains its own stored procedure cache for every single connection. If an application uses a stored procedure multiple times in a single connection, the compiled version is used; otherwise, the stored procedure works like a query.
The perfect database for web applications
What do you like best about the product?
It is a very adaptable database. It is also very fast when performing operations. On the other hand it has been very useful to deploy it on servers with limited resources. I like that no matter what server language I use in my web applications I can achieve access to the mysql database without any complications. This also helps me to interconnect applications through the same database
What do you dislike about the product?
Many advanced functions of MySQL do not have a good documentation, it is required to invest time in being able to find all the necessary documentation. And it's also an unintuitive database for a beginner user.
What problems is the product solving and how is that benefiting you?
It has allowed me to build the database of all websites and applications in the cloud that I have created in the company, it is a great tool for database and widely used in web apps. We are currently creating new products for cloud solutions, and this integrated NodeJS tool works perfectly. We have also integrated it into web applications created with php and python
Recommendations to others considering the product:
It is a great tool, but they should improve the documentation for advanced functions. I like that it can be integrated to any type of server language, it is very useful to connect applications created in different languages from the same database. Finally, mysql does not come fully optimized, it requires several optimization adjustments to improve its performance. They are also simple optimizations that can be easily improved
Best SQL for Day today
What do you like best about the product?
I have been using this product for sometime ,really doing Fantabulous job connects to multiple systems and reorganize my data according to predefined functions,fantastic to use day to day operations
What do you dislike about the product?
Nothing from my end neither from coworkers
What problems is the product solving and how is that benefiting you?
Many ,such as integral part of our projects
Faster
What do you like best about the product?
Faster performance and good use of low latency tasks.
What do you dislike about the product?
The connection interface for my sql is not that intutive.
What problems is the product solving and how is that benefiting you?
Low latency trading
Pros and cons of the use of mysql in companies
What do you like best about the product?
It is very popular: the fact that many people use it and that it is so present in a large part of the web developments, makes the software providers try to make their applications compatible with this database, thus being able to find many applications for MySQL.
It is simple: it is easy to learn compared to other BDs, it is not necessary to spend a lot of time or money in training workers or in hiring qualified people. The fact that it is simple means that it is also fast, although there are some developers that miss some features (in my opinion, less and less).
It's cheap: although it belongs to MySQL AB, MySQL is open source, which is cheap means that at the beginning of the project the expense goes to other parties that may need it, instead of spending money on licenses.
It has support: one of the disadvantages that clients usually present towards open source is that it does not have support. MySQL offers a license with support and maintenance services, and it is also possible to obtain technical attention 24/7.
It is flexible and scalable: it has many types of storage, being able to select the one that suits us best, and stored procedures allow us scalability.
Native libraries for languages: offers libraries for languages such as PHP and Ruby.
It is simple: it is easy to learn compared to other BDs, it is not necessary to spend a lot of time or money in training workers or in hiring qualified people. The fact that it is simple means that it is also fast, although there are some developers that miss some features (in my opinion, less and less).
It's cheap: although it belongs to MySQL AB, MySQL is open source, which is cheap means that at the beginning of the project the expense goes to other parties that may need it, instead of spending money on licenses.
It has support: one of the disadvantages that clients usually present towards open source is that it does not have support. MySQL offers a license with support and maintenance services, and it is also possible to obtain technical attention 24/7.
It is flexible and scalable: it has many types of storage, being able to select the one that suits us best, and stored procedures allow us scalability.
Native libraries for languages: offers libraries for languages such as PHP and Ruby.
What do you dislike about the product?
Lack of integration with existing environments: there are many circumstances in which DBAs do not have an environment with which to deal with MySQL.
Lack of maturity: in comparison with other BDs such as Oracle (which turns 30), it lacks maturity, which indicates positioning and stability.
Lack of maturity: in comparison with other BDs such as Oracle (which turns 30), it lacks maturity, which indicates positioning and stability.
What problems is the product solving and how is that benefiting you?
MySQL is one of the most popular databases within the web development. There are people who defend it, and others who do not have it among their favorite BD. For those who have to decide on the choice of MySQL as BD of your system, this list of pros and cons can be very useful.
showing 311 - 320