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/sorted-index-builds.html
Reserving B-tree Page Space for Future Index Growth To set aside space for future index growth, you can use the innodb_fill_factor variable to reserve a percentage of B-tree page space. For example, setting innodb_fill_factor to 80 reserves 20 ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-elements.html
Tables in the mysql system database provide persistent storage of filter and user account data. A set of functions enables manipulation of filtering definitions that control logging behavior, the encryption password, and log file reading. System ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. You can copy the files that correspond to a database table into some other location and perform recovery operations on them there. myisamchk ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
To specify the password for encrypting the keyring data file, set the keyring_encrypted_file_password system variable. (The password is mandatory; if not specified at server startup, keyring_encrypted_file initialization fails.) The ...The ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ...Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database ...
https://dev.mysql.com/doc/refman/5.7/en/history.html
The name of the MySQL Dolphin (our logo) is “Sakila,” which was chosen from a huge list of names suggested by users in our “Name the Dolphin” contest. We started out with the intention of using the mSQL database system to connect to our ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
To perform point-in-time recovery of NDB Cluster, it is necessary to follow the steps shown here: Back up all NDB databases in the cluster, using the START BACKUP command in the ndb_mgm client (see Section 21.6.8, “Online Backup of NDB Cluster”). Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
Configuring Stage Event Collection Stage Event Progress Information Configuring Stage Event Collection To control whether to collect stage events, set the state of the relevant instruments and consumers: The setup_instruments table contains ... The ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
To turn on all restrictions, you can simply use TRADITIONAL mode, which includes both strict mode values and ERROR_FOR_DIVISION_BY_ZERO: SET sql_mode='TRADITIONAL'; If a number is inserted into an exact type column (DECIMAL or integer), it is ...For ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Use of ORDER BY for individual SELECT statements implies nothing about the order in which the rows appear in the final result because UNION by default produces an unordered set of rows. Therefore, ORDER BY in this context typically is used in ...