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/replication-formats.html
The logging format in a running MySQL server is controlled by setting the binlog_format server system variable. The rules governing when and how the new setting takes effect are the same as for other MySQL server system variables. Setting the ...The ... Replication works because events written to the binary log are read from the source and then processed on the ...
https://dev.mysql.com/doc/refman/5.7/en/selinux.html
An SELinux context (the label applied to a system object) has the following fields: user, role, type, and security level. SELinux policy modules use SELinux contexts to define rules for how processes, files, ports, and other system objects interact ... Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a security label referred to as an SELinux context to each system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
Aborting a Buffer Pool Load Operation To abort a buffer pool load operation, issue the following statement: SET GLOBAL innodb_buffer_pool_load_abort=ON; Monitoring Buffer Pool Load Progress Using Performance Schema You can monitor buffer pool load ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
A set of quick-reference tables providing basic information about these options and variables is also included. server_uuid In MySQL 5.7, the server generates a true UUID in addition to the server_id value supplied by the user. Note The presence of ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
These files therefore are owned by the user who executes mysqldump. The following command dumps the contents of the db1 database to files in the /tmp database: $> mysqldump --tab=/tmp db1 The .txt files containing table data are written by the ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
$> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you have created the NDB native backup using ndb_mgm, you must not make any schema changes before creating the backup of the schema, if you do so. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
Users are strongly urged not to use database files that contain Barracuda file format tables with releases of InnoDB older than the MySQL 5.1 with the InnoDB Plugin. All tables using any file format supported by a release can be read or written ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. With ...The ...
https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html
You need to tune the server settings, such as memory, cache, or InnoDB configuration information. Note When using the MySQL Installer to install MySQL Server, it creates the my.ini in the default location, and the user executing MySQL Installer is ...For options that are used every time the server starts, you may find it most convenient to use an option file to specify your MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related MySQL logs reflect the original times at which the transactions were executed. Your database has now been restored ... The last section, Section 7.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...