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/handler-scope.html
END block is in scope only for the SQL statements following the handler declarations in the block. In the following example, handlers H1 and H2 are in scope for conditions raised by statements stmt1 and stmt2. But neither H1 nor H2 are in scope for ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the replication source servers using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication metadata repositories, and provisioned the ...Use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance_schema_users_lost The number of times a row could not be added to the users table because it was full. If this value is nonzero, you may wish to set performance_schema_session_connect_attrs_size to a larger value. Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM ... A ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
RESET SLAVE does not change any replication connection parameters such as the source's host name and port, or the replication user account name and its password. RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. However, the content of the tables in the performance_schema database misses events. For example, ...Names ...Other mutexes have an instance per connection, or per page in various caches and data buffers, so the number of instances varies over ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
MySQL represents each table by an .frm table format (definition) file in the database directory. For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-userguide.html
For documentation on the concepts and usage of X DevAPI, which is implemented in MySQL Shell, see X DevAPI User Guide. The AdminAPI enables database administrators to work with InnoDB Cluster, which provides an integrated solution for high ... MySQL ...MySQL Shell includes the following APIs implemented in JavaScript and Python which you can use to develop code that interacts with ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
For the binary log, you can set the expire_logs_days system variable to expire binary log files automatically after a given number of days (see Section 5.1.7, “Server System Variables”). To rename the general query log or slow query log at ...On ... As described in Section 5.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking ...