Internals and Portability: • Written in C and C++. • Tested with a broad range of different compilers. • Works on many different platforms. See Section 2.1.1, “Operating Systems Supported by MySQL Community Server”. • For portability, uses CMak...
Localization: • The server can provide error messages to clients in many languages. See Section 10.2, “Setting the Error Message Language”. • Full support for several different character sets, including latin1 (cp1252), german, big5, ujis, and more. For example, the Scandinavian characters “å”, ...
Lock Probes The lock probes are called whenever an external lock is requested by MySQL for a table using the corresponding lock mechanism on the table as defined by the table's engine type. There are three different types of lock, the read lock, write lock, and unlock operations. Using the probes...
Locking Options for Online DDL While an InnoDB table is being changed by a DDL operation, the table may or may not be locked, depending on the internal workings of that operation and the LOCK cla...
MySQL and Virus Checking Software Using virus scanning software such as Norton/Symantec Anti-Virus on directories containing MySQL data and temporary tables can cause issues, both in terms of the performance of MySQL and the virus-scanning s...
MySQL Cluster. MySQL Cluster is released as a separate product, with new development for version 7.3 of the NDB storage engine being based on MySQL 5.6. Clustering support is not available in mainline MySQL Server 5.6 releases. For more information about MySQL Cluster NDB 7.3, see Chapter 17, MyS...
MySQL Community Support on Internet Relay Chat (IRC) In addition to the various MySQL mailing lists and forums, you can find experienced community people on Internet Relay Chat (IR...
MySQL Configuration and Third-Party Tools Third-party tools that need to determine the MySQL version from the MySQL source can read the VERSION file in the top-level source directory. The file lists the pieces of the version separately. For example, if the version is 5.5.8, the file looks like th...
MySQL databases are relational. A relational database stores data in separate tables rather than putting all the data in one big storeroom. The database structures are organized into physical files optimized for speed. The logical model, with objects such as databases, tables, views, rows, and co...
MySQL Development History This section describes the general MySQL development history, provides an overview about features that have been implemented in previous series and that are new in MySQL 5.6, the release series covered in this manual. Th...
