Shulou(Shulou.com)06/01 Report--

MySQL has significantly improved its performance and availability, integration, query performance in version 5.6, and can support the next generation of Web, embedded and cloud computing applications. It has the following characteristics:

Add! Online DDL / change data architecture supports dynamic applications and developer flexibility

Add! Copy the global transaction identity to support self-healing clustering

Add! Replicating crash-free slaves improves availability

Add! Replicating multithreaded slaves can improve performance

Add! With NoSQL access to InnoDB, you can quickly complete key operations and extract data to complete big data deployment.

Improve! Up to 230% performance improvement on Linux

Improve! Higher scalability on today's multicore, multi-CPU hardware

Improve! Improved InnoDB performance to handle transactions and read-only loads more efficiently

Improve! Faster query execution and enhanced diagnostics

Improve! Performance Schema can monitor the resource usage of individual users / applications

Improve! Ensure security through policy-based password management and enforcement

Highly reliable, with almost no intervention to ensure the continuous operation of the system

Easy to use, it only takes 3 minutes to complete the installation and configuration process from download to development environment.

The management requirement is low, and the database maintenance work is very little.

Replication supports flexible topologies for scale-out and high availability

Partitioning helps improve performance and manage very large database environments

ACID transactions support the construction of secure and reliable business-critical applications

Stored procedures can improve developer efficiency

Triggers can implement complex business rules at the database level

View ensures that sensitive information is protected from attack

Information Schema helps facilitate easy access to metadata

The plug-in storage engine architecture maximizes flexibility.

Questions that may be asked in the interview:

CPU support to 64 cores

Can operate DDL online

Based on the multithreaded replication of the library, and when GTID is enabled, slave does not need to find binlog logs and POS points when doing synchronous replication.

Support for library-based multithreaded replication

Support InnoDB buffer pool automatic warm-up function (off by default). When you close MySQL, save the data in memory on disk and load it when you boot!

InnoDB begins to support full-text indexing

Optimized the relevant query operations, especially the subquery performance. For example, Index Condition Pushdown (ICP) is an optimization that MySQL uses the index to fetch data from the table.

Direct internal support for Memcached Nosql API

Performance_schema data dictionary is enabled by default, which is more powerful!

……

Enhanced optimization of InnoDB functions, such as InnoDB rewrite log file capacity increased to 2TB, can improve the load performance of write-intensive applications

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.