In terms of transactional support, although MySQL's own storage engine is not available, it has implemented all of the four transaction isolation levels defined by the SQL92 standard through the third-party plug-in storage engine InnoDB, for example, The well-known Oracle database has only implemented two of these (serializable and readcommited), while PostgreSQL also supports four isolation levels. PostgreSQL also supports four isolation levels.
However, there is a gap between MySQL and other databases in terms of programmable support, although the latest version of MySQL has started to provide some simple programmable support, such as starting to support Procedure,function,trigger, but the supported features are relatively limited, Compared with other major commercial database management systems, there are still a large number of deficiencies.
Ease of Use comparison
From the installation side, the MySQL installation package size is only about 100MB, these large commercial databases are not at the same order of magnitude. The ease of installation is much simpler than a commercial database such as Oracle, whether it is compiled with a compiled binary distribution package or a source code installation.
From the database creation to compare, MySQL just need a simple createdatabase command, can complete the action of building the library in an instant, and the Oracle database is compared, the creation of a database is a very large project. Of course, there are certain differences between the concepts of the database and cannot be denied.
Performance comparison performance has always been a feature of MySQL's Pride. In the process of testing the TPCC values of various databases by the authoritative third-party evaluation agencies, MySQL has always had excellent performance, and in all other commercially available general-purpose database management systems, only the Oracle database can be higher. MySQL wants to be a customer to meet 99% of the functional needs of the premise, spend most of the rest of the energy to performance efforts,
Reliability
About the reliability of the comparison, and there is not much detailed evaluation of comparative data, but from the current industry exchanges can be learned that several major commercial manufacturers of the reliability of the database is certainly not too many questionable. But as a representative of the open source database management system, MySQL also has a very good performance, and not as some people have doubts in the mind, because it is not provided by the commercial vendors, will not be stable enough not robust. From the current most popular Facebook such a large web site is the use of MySQL database, it can be seen that MySQL in the stability of reliability, and no more than our commercial manufacturers of products are not inferior. And in the top 10 of the world's largest web site, most of the business is running in the MySQL database environment, such as Yahoo,google. In general, MySQL database has its own three principles in the development process: simple, efficient and reliable. From the simple comparison above, we can also see that in MySQL's own three principles, no one is not doing well. Moreover, although the function is not one of the three principles that MySQL itself pursues, but considering the rapid growth of the current user volume, the user needs more and more diversification, MySQL has to make a lot of effort in the function to constantly meet the new needs of customers. For example, the recent version of Eentscheduler (similar to Oracle's job function), partition function, the self-developed Maria storage engine in the function of the extension, Falcon storage engine support for transactions, etc. Has proved that MySQL has also begun to work tirelessly in terms of functionality. No one product can be perfect, nor can it be applied to all users. Only when we measure the characteristics of each product, we choose a product that is most suitable for ourselves.
MySQL's main application scenario what scenario does MySQL apply to in what scenarios? 1, Web site System Web site, is MySQL's largest customer base, but also the most important support in the history of MySQL, this point in the beginning of the MySQLServer Introduction section has been explained.MySQL is the most popular database management system for Web site developers because the installation configuration of MySQL database is very simple,maintenance during use is not as complex as many large business database management systems,and excellent performance. Another very important reason is that MySQL is open source and fully free to use.
2, logging system MySQL database insert and query performance are very efficient, if the design is better, when using the MyISAM storage engine, the two can do not lock,achieve very high concurrency performance. Therefore, MySQL is a great choice for systems that require a large number of inserts and query logging. such as processing user log, operation log, etc., are very suitable for the application scenario.
3, the Data Warehouse system with the current data warehouse data volume of rapid growth, we need more and more storage space. The increasing volume of data makes statistical analysis of data more and more inefficient and increasingly difficult. What to do? Here are a few of the main solutions, one is to use expensive high-performance host to improve computing performance, high-end storage equipment to improve I/O performance, the results are ideal, but the cost is very high; the second is to improve overall computing performance and i/by replicating data to several inexpensive pcserver that use large hard drives o ability, effective, storage space is limited, low cost; third, by splitting the data horizontally, using multiple inexpensive pcserver and local disks to hold the data, each machine has only a part of all the data, solve the problem of data volume, all pcserver parallel computing,also solve the problem of computing power, through the intermediate agent to allocate the operational tasks of each machine, can not only solve the computational performance problems and can solve the I/O performance problems, the cost is very low
In the above three scenarios, the second and third implementations, MySQL has a greater advantage. Through the simple copy of MySQL function, you can copy data from one host to another, not only in the LAN can be replicated,in the WAN can likewise. Of course, many people may say that other databases can do the same, not only MySQL has such a function. Sure, many databases can do the same, but MySQL is free, and most of the other databases are charged according to the number of hosts or the number of CPUs .
When we use a lot of pcserver, the license cost is quite amazing. The first scenario, basically all database systems can be implemented, but its high cost is not every company can afford.
4, embedded system embedded environment to the software system the biggest limitation is the hardware resources is very limited, in the embedded environment to run the software system, must be lightweight low-consumption software. MySQL is very scalable in terms of resource usage, can be run in a resource-rich environment, or it can operate in very low-resource environments. It is a very suitable database system for the embedded environment, and MySQL has a version specifically for the embedded environment.
From for notes (Wiz)
MYSQL simple comparison with other databases
