PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction.
https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html
When the timeout value is reached, the issuing client returns an error message and stops waiting, but the STOP SLAVE instruction remains in effect. If the replica is stopped unexpectedly (for example due to an error in a worker thread, or another ...
https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html
On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files When you download MySQL Installer for the first time, a setup wizard guides you through the initial installation of MySQL products. As the following figure ...MySQL Installer detects existing MySQL products installed on the host during its initial setup and adds them to the list of products to be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting other database operations to proceed while the I/O is still in progress. On Linux and Windows platforms, InnoDB uses the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
A read-ahead request is an I/O request to prefetch multiple pages in the buffer pool asynchronously, in anticipation that these pages are needed soon. InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
For example, in a table containing information about people, you would not create a primary key on (firstname, lastname) because more than one person can have the same name, a name column may be left blank, and sometimes people change their names.
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
The maximum number of indexes per table and the maximum index length is defined per storage engine. If a search term exceeds the index prefix length, the index is used to exclude non-matching rows, and the remaining rows are examined for possible ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
For example: mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0" With a slow shutdown, InnoDB performs a full purge and change buffer merge before shutting down, which ensures that data files are fully prepared in case of file format ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
Attempting to use them with SET NAMES or SET CHARACTER SET produces an error. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode ...