MySQLFrom "Toys" in the hands of developers to today's "the world's most popular
Open Source
Database, the process is accompanied by a product version upgrade, as well as an increase in some new features, especially enterprise database functionality. Now, with MySQL 5.0 being perfectly developed, very few people have called MySQL a "toy database". MySQL's rich features meet the needs of many users, and Oracle's recent actions show that they treat MySQL with great emphasis on--oracle's jicisanfan intention to acquire MySQL.
Product roadmap for MySQL
Let's start with MySQL's more influential version of the product and look at the MySQL update.
MySQL 4.0
MySQL 4.0 was released in March 2003, which makes the new MySQL-based application more widely available. However, in version 4.0, MySQL does not support stored procedures, triggers, server-side pointers, or views. MySQL 4.0 is a development from 3.23, compared to the 3.23 version has a great improvement, mainly for the Web site, when the MySQL is not an enterprise-level database.
The following are the main new features of MySQL 4.0:
Fulltext INDEX: The fulltext index is probably the most worthy of the user's expectation.
Fulltext creates an index in a text field, providing a powerful and flexible mechanism for performing Boolean searches on that index. As a general development experience, developers often have to create indexes and access text data, and the Fulltext index is much better than imagined.
Many solutions are limited to full-word indexing, and the Fulltext index does not have this limitation, allowing developers to add or split phrases.
ANSI SQL Union: supports the ANSI SQL Union statement, which aggregates the query results into a result set.
Multi-table operation: Multiple table update and delete can be performed.
New statement: Adds some nonstandard new statements familiar to other DBMS users (such as identity and truncate TABLE), and new features such as Found_rows () that return the number of records that can be returned without the limit clause.
InnoDB Storage Engine: The InnoDB storage engine was the standard feature of the server at the time and became an additional option in version 4.0. InnoDB is a table type that allows acid-compliant transactions, rather than the default MyISAM table type, which can speed up general usage, but is not very useful for critical operations.
The InnoDB table uses row-level locking attributes, which means that updates to one record lock only that record, not the entire table. When you choose to access a large number of databases (for most Web sites), locking the entire table is fairly fast, but when the number of insertions and updates is close to the number of options, the speed is slower. For a long time, the criticism of MySQL has been focused on the security and consistency of the MyISAM table, and the acid-compatible InnoDB table has traveled a long way to solve these problems.
http://www.bkjia.com/PHPjc/630964.html www.bkjia.com true http://www.bkjia.com/PHPjc/630964.html techarticle MySQL has changed from "Toys" in the hands of developers to "the world's most popular open source database", where the process is accompanied by product version upgrades and new features (especially ... ).