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-features-triggers.html
If the new server is a replication source server and has old replicas that do not support multiple triggers, an error occurs on those replicas if a trigger is created on the source for a table that already has a trigger with the same trigger event ... With statement-based replication, triggers executed on the source also execute on the ...If under row-based replication the replica applied the triggers as well as the row changes caused by them, the changes would in ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
The optimizer choices are limited because only such plans enable outer joins to be executed using the nested-loop algorithm. This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
blocking_trx_age How long the blocking transaction has been executing, as a TIME value. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been ... These views summarize the InnoDB locks that transactions are waiting ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. If the server does not detect this change the next ...To avoid problems caused by metadata changes to tables or views referred to by the prepared statement, the server detects these changes and automatically reprepares the statement when it is next ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
Any time the high water mark is updated, the value of innodb_file_format_check is updated as well, so the command SELECT @@innodb_file_format_check; displays the name of the latest file format known to be used by tables in the currently open ib-file ...If you access an existing table in a format higher than the format the running software supports, the system tablespace tag is not updated, but table-level compatibility checking applies (and an error is issued), as described in Section 14.10.2.2, “Compatibility Check When a Table Is ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
Specify character settings at configuration time, if you build MySQL from source. If most or all applications use the same character set, specifying character settings at server startup or configuration time may be most convenient. Applications that ... For applications that store data using the default MySQL character set and collation (latin1, latin1_swedish_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/5.7/en/program-variables.html
For example, the first of the following lines is legal at program invocation time, but the second is not: $> mysql --max_allowed_packet=16M $> mysql --max_allowed_packet=16*1024*1024 Conversely, the second of the following lines is legal at runtime, ... Many MySQL programs have internal variables that can be set at runtime using the SET ...See Section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
Sometimes it is useful to join a table to itself, if you want to compare records in a table to other records in that same table. The pet table keeps track of which pets you have. If you want to record other information about them, such as events in ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-key-caches.html
If you want the association to take effect each time the server starts, one way to accomplish this is to use an option file: Include variable settings that configure your key caches, and an init_file system variable that names a file containing ...