MySQL Pricing

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.

Very simple to get started with and take advantage of a broad set of features. Low learning curve to master it. In depth documentation with a large community support. Plethora of robust tools to support it, like the MySQL Workbench.

There are some not so intuitive functionalities that you have to look up the documentation to understand and work around. One of them is killing a query in process. Also, the profiler tool is not as powerful as some of the competitor DBMS.

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.

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.

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.

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.

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.

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.

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.

- If you structure your database correctly, it's very stable - It's free, and there are MySQL derivatives (MariaDB) that are even more powerful - The xtradb database engine in MariaDB (a derivative of MySQL) is incredibly fast - You can do things quickly and have some data integrity risks on small projects, or you can do things properly and have virtually no risk on mission critical applications - VERY easy to scale and setup database clusters and replication, especially in all of the cloud providers

- The barrier for entry is too low, causing MySQL and MariaDB to get a bad rep because inexperienced users take advantage of its simplicity - Performance isn't on par with MSSQL/SQL Server without a ton of configuring

Cost. Reliability. Ease of installation. Power.

While I have had some complaints about error locating in the MySQL code we write, I understand that the underlying technology would be degraded by more checks and balances within the system. Plus: This concept applies equally to every version of SQL we use (Postgre and MSSQL included).

MySQL was initially an open source RDBMS till it was acquired by Oracle corporation. MySQL was integrated with a very versatile web interface PHPMyAdmin which provided a full-fledged database client that allows administrators to manage the creation of database entities including tables, views, stored procedures, triggers, users, .... MySQL supports the various SQL 92 constructs including DDL, DML, and DCL SQL statements. It is not supported with advanced Undo/Redo Logging algorithms as in the case of Oracle database, but still can support advanced SQL queries with decent optimization mechanisms.

PHPMyAdmin suffered from performance lagging and bottlenecks specifically when inserting database rows. The lagging is mainly from the Web GUI since the actual SQL insertion mechanism is effectuated in the database but not refreshed in the PHPMyAdmin GUI. The latest database engine supported by PHPMyAdmin is MariaDB which suffered the same performance lagging issue. Customer support wasn't successful in figuring out the source of this bug. This is mainly experienced on Windows installations. MySQL is not open source anymore which makes MariaDB (the open source alternative) a much cost efficient choice.

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.

Mysql has been my favorite database since I started programming, it's easy to install, it's simple to find an application that connects to the database and do the administration in graphical mode, many content managers and e-commerce stores use mysql by default and has helped me carry out several projects, I like that most hosting providers have MySQL support at no additional cost. It is free this...

Read more

I think that mysql needs to improve in terms of the variety of data types in other databases. I find more complex types of data that are sometimes necessary, another point that should be improved is the power of the procedures that I consider limited compared to those of others. Other brands. Since Oracle bought mysql, the community is not sure about the future of this software, so it has created mistrust in me and I do not like this.

Effective to handel large data recording and reporting with in good time,while data is being entred and acessed from many users. Live from PC GuIwhereas also available phpmyadmin to acess on web and work with php accordingly, although it can be integrared with many languages programs like Java,Ajax,ASP but most of the time it being used with PHP. Work with existing filed like calculation/triggers best thing which is used BI,AI. Query reporting/response time from such large data is awesome. Query for access data almost every feature is available to get curtain form of data. UI and use is very easier.

Not generic calculation formula like excel, such additional feature should be introduced. Value based trigger should be introuduced with support of scripts, i.e if value of column (field) reaches,equals to specific value this then run this scripts ir query and put specific value on this filed etc , its currently un upavailable. Advanced statiatics are not get reported by data, like hypothesis, regerssions. No built in tool in excel.

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.

Whenever one makes a table in MySQL, one has a choice to make an essential key which is one of a kind for each record in that table. That can then be utilized to look and reference the information in that table without any problem. One can likewise stamp different information sections as ordered and make them one of a kind, for example the email segment. That will forestall copy records. Furthermore,...

Read more

First and greatest cons is that MySQL isn't reasonable for huge measure of information. It generally experienced despite everything experience issues performing complex joins. Data set might get debased under certain situations when critical choices is performed same time as different clients perform clumps of supplements/refreshes. With immense information, I had confronted information misfortune and inappropriate information recovery yet it is exceptionally uncommon and sensible.

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.

MySql is the Open source Database and anyone can use it without any licence cost. Queries are very simple and common to other RDBMS database. MqSQL Drivers(API) are available for all the Programming languages which makes easy to connect database from the code. This is platform independent and can be installed in any OS(Windows, Linux ). We can create procedures, triggers easily with MYSQl and the data back up can be handled softly. It supports CSV, Excel and Plain Text files for Uploading.

If the table has relatively more data count, the performance for query retrieval is slow. when you have too many open connections, database will go down and you will see the connection errors.

Been using MySQL for like 5 years almost 90% of total projects done by us are based on MySQL database, the deployment is insanely easy and scalability is amzing it can even handle TBs of data easily requires enough resources. Every major company is using MySQL in some way. These are not the only things being an open source projects the community developer support is by far the best i have ever seen even commercial products don't have this kind of support. Ah and yeah even a kid can use SL queries making it the best choice one can make for cost effective database solution.

nothing everything is awesome as it shoud be while some forks like mariadb have better performance on same system i wonder why is that maybe it's something to do with optimizations and data checks MySQL performs every time a query is run, well here you have it.

The price! MySQL is free and included in every major web hosting company that I've came across. It is so easy to use and it just works. I love the ease of implementation and how easy it is to import and export new tables and even complete databases. Additionally you can usually find phpMyAdmin bundled in with MySQL which makes managing and manipulating the databases a breeze.

MySQL does not offer data domain objects or extensibility. However, I have never needed either and this is why MySQL is always our go-to for making quick easy manipulatable databases online.

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

Simply amazing, the response speed of the query both in the bath and in the phpyadmin interface. The low cost of the resources required makes it suitable for applications and programs of small to medium size which makes it really functional, personally in my previous work and by company policies that only required open source applications and Free, mysql me It was the perfect answer because it had everything, speed, optimization, performance, easy to install and manage

As an administrator I have always tried to achieve the standardization of all my systems, both in codification and in the behavior of the databases and in mysql I have found many failures that even with (more than 15 years in the market), errors are found without the proper documentation, errors that even the community of oracle and mysql have not been able to solve, to the nomenclature of the errors is very generic and a single error code can refer to several different errors

- Easy syntax, matches almost other products like SQL Server by Microsoft and Oracle. Hence switching to MySQL is easy.- Data retrieval is at par with similar products- By far the cheapest and convenient options - Integration with other applications like any other ORM tool is readily available

- User Interface of its supported IDE can be improved- Sometimes database objects like Stored Procedure , functions are overwritten when simultaneously access from 2 different logins