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/sys-io-by-thread-by-latency.html
max_latency The maximum single wait time of timed I/O events for the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread. total_latency The total wait time of timed I/O events for the thread. min_latency ...The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the ...
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of digits following the decimal point for fractional parts of seconds. MySQL supports SQL data types in several categories: ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
The maximum disk space required is determined by the following expression: (length of what is sorted + sizeof(row pointer)) * number of matched rows * 2 The row pointer size is usually four bytes, but may grow in the future for really big tables.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
If an error occurs, the column value is the GTID of the transaction being executed by the worker when the error occurred. LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent worker error occurred. If gtid_mode ... If the replica is not multithreaded, this table shows the status of the applier ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
mysql> CHANGE MASTER TO MASTER_HOST='localhost', MASTER_USER='root', MASTER_PASSWORD='', MASTER_PORT = 13000, MASTER_LOG_FILE='0.000001, MASTER_LOG_POS=114; Start the replica. mysql> START SLAVE; If the error log prints output similar to the ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
Inserting a string into a string column (CHAR, VARCHAR, TEXT, or BLOB) that exceeds the column maximum length. If you use the IGNORE modifier, ignorable errors that occur while executing the INSERT statement are ignored. If any of the rows to be ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
For any operation not permitted within the session, the server returns an ER_MUST_CHANGE_PASSWORD error: mysql> USE performance_schema; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. If ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| statement/sql/load | YES ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. row *************************** Trigger: ins_sum Event: INSERT Table: account ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
gtid_executed_compression_period Command-Line Format --gtid-executed-compression-period=# System Variable gtid_executed_compression_period Scope Global Dynamic Yes Type Integer Default Value 1000 Minimum Value 0 Maximum Value 4294967295 Compress the ...The set of transactions that can be found in the binary logs at any given time is equal to GTID_SUBTRACT(@@GLOBAL.gtid_executed, @@GLOBAL.gtid_purged); that is, to all transactions in the binary log that have not yet been ...