Skip navigation links
1.4.2 MySQL 5.4 Feature Summary »
Section Navigation      [Toggle]

1.4.1. What Is New in MySQL 5.4

MySQL 5.4 is based on MySQL 5.1 but includes small, high-impact changes to enhance scalability and performance in MySQL Server. The following list summarizes MySQL 5.4 areas of emphasis. Section 1.4.2, “MySQL 5.4 Feature Summary”, provides additional detail.

  • Scalability improvements.  The principal emphasis is to improve scalability on multi-core CPUs. The trend in hardware development now is toward more cores rather than continued increases in CPU clock speeds, which renders “wait until CPUs get faster” a nonviable means of improving database performance. Instead, it is necessary to make better use of multiple cores to maximally exploit the processing cycles they make available. MySQL 5.4 takes advantage of features of SMP systems and tries to eliminate bottlenecks in MySQL architecture that hinder full use of multiple cores. The focus has been on InnoDB, especially locking and memory management.

  • InnoDB I/O Subsystem changes.  InnoDB I/O subsystem changes enable more effective use of available I/O capacity.

  • Enhanced Solaris support.  Several modifications improve operation of MySQL Server on Solaris.

  • Diagnostic and monitoring capabilities.  There is better access to execution and performance information. Diagnostic improvements include DTrace probes, expanded SHOW ENGINE INNODB STATUS output, and a new status variable.

  • Configuration changes.  The “out of box” configuration provides better choices of default option and system variable values for MySQL operation on up to 16-way x86 servers and 64-way CMT servers with 4GB or more memory.

The following constructs are deprecated and will be removed in a future MySQL release. Where alternatives are shown, applications should be updated to use them.