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/multiple-unix-servers.html
For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not installed because it is unnecessary. For information about using systemd to handle ... Note The discussion here uses mysqld_safe to launch multiple instances of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. For example, if you need to write ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...Normally, you must write your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a backup. InnoDB automatically checks the logs and performs a roll-forward of the database to the present.
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a utf8mb3 character set and the maximum of 3 bytes for each character. This section describes limits for InnoDB ...A ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-subpartitions.html
Otherwise, you may set any desired option for the subpartition or allow it to assume its default setting for that option. An exception to this is that SUBPARTITION BY KEY (unlike PARTITION BY KEY) does not currently support a default column, so the ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-checkpoints.html
There is no need to flush the buffer pool in one single batch, which would disrupt processing of user SQL statements during the checkpointing process. It knows that all modifications to the database before the label are present in the disk image of ...It often makes sense to set the total size of the log files as large as the buffer pool or even ...
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/deploy-mysql-nonlinux-docker.html
Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. This section discusses ...
https://dev.mysql.com/doc/refman/5.7/en/show-binlog-events.html
Note Some events relating to the setting of user and system variables are not included in the output from SHOW BINLOG EVENTS. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. The LIMIT ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
When using GTIDs you can take advantage of auto-positioning and automatic fail-over, as well as use WAIT_FOR_EXECUTED_GTID_SET(), session_track_gtids, and monitor replicated transactions using Performance Schema tables. The ability to configure the ...This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ... To be ...