Free database management system (DBMS). MySQL server is characterized by high speed, stability and ease of use, is the solution for small and medium-sized applications. In addition to Oracle Database is one of the fastest DBMS today. Distribution of MySQL database management system based on the GPL and high speed processing of requests has resulted in the database has become the de facto standard in network hosting services. Typically, MySQL is used as a server, which treated local or remote clients, but the distribution is a library internal server to include MySQL in the autonomous program, and perform sql queries. Flexibility DBMS MySQL supports a large number of types of tables: Users can choose vert fast table type MyISAM, supporting the full-text search, and a slow but very steady table InnoDB, supporting the transaction at the level of individual records. Moreover, the DBMS MySQL comes with a special type of table EXAMPLE, demonstrating the principles of creating new types of tables. Through an open architecture and the GPL-licensed, new types of tables are constantly created in the MySQL database management system.
MySQL Enterprise Server 5.1 delivers enterprise features, including:
- Partitioning to improve MySQL performance and management of very large database environments
- Row-based/Hybrid Replication for improved replication security
- Event Scheduler to create and schedule jobs that perform various database tasks
- XPath Support
- Dynamic General/Slow MySQL Query Log
- Performance/Load Testing Utility (mysqlslap)
- Full Text Search
- Archive engine (better compression, more features)
- User session and problem SQL identification
- MySQL embedded library (libmysqld)
- INFORMATION_SCHEMA objects
- Faster data import operations (parallel file load)
- ACID Transactions to build reliable and secure business critical applications
- Stored Procedures to improve developer productivity
- Triggers to enforce complex business rules at the MySQL database level
- Views to ensure sensitive information is not compromised
- Information Schema to provide easy access to MySQL metadata
- Pluggable Storage Engine Architecture for maximum MySQL flexibility
- Archive Storage Engine for historical and audit data
Related posts
No Comments »
No comments yet.
Entries (RSS)