Compatibility Check When InnoDB Is Started To prevent possible crashes or data corruptions when InnoDB opens an ib-file set, it checks that it can fully support the file formats in use within the ib-file set. If the system is restarted following a...
Compressing BLOB, VARCHAR, and TEXT Columns In an InnoDB table, BLOB, VARCHAR, and TEXT columns that are not part of the primary key may be stored on separately allocated overflow pages. We refer to these columns as off-page columns. Their values...
Compression and the InnoDB Buffer Pool In a compressed InnoDB table, every compressed page (whether 1K, 2K, 4K or 8K) corresponds to an uncompressed page of 16K bytes (or a smaller size if innodb_page_size [1776] is set). To access the data in a ...
Compression and the InnoDB Redo Log Files Before a compressed page is written to a data file, MySQL writes a copy of the page to the redo log (if it has been recompressed since the last time it was written to the database). This is done to ensure...
Compression of B-Tree Pages Because they are frequently updated, B-tree pages require special treatment. It is important to minimize the number of times B-tree nodes are split, as well as to minimize the need to uncompress and recompress their content. One technique MySQL uses is to maintain som...
Configuration Changes • Beginning with MySQL 5.6.6, several MySQL Server parameters have defaults that differ from previous releases. The motivation for these changes is to provide better out-of-box performance and to
Configure the Distribution Change location into the top-level directory of the unpacked distribution: shell cd mysql-VERSION Configure the source directory. The minimum configuration command includes no options to override configuration defaults: shell cmake . On Windows, specify the developme...
Connecting to the MySQL Server For a client program to be able to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Each connection parameter has a default value...
Connectivity: • Clients can connect to MySQL Server using several protocols: • Clients can connect using TCP/IP sockets on any platform. • On Windows systems in the NT family (NT, 2000, XP, 2003, or Vista), clients can connect using named pipes if the server is started with the --enable-named-pi...
Controlling the History File The .mysql_history file should be protected with a restrictive access mode because sensitive information might be written to it, such as the text of SQL statements that contain passwords. See Section 6.1.2.1, “En...
