PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
If the current replication event group has modified one or more nontransactional tables, STOP REPLICA waits for up to 60 seconds for the event group to complete, unless you issue a KILL QUERY or KILL CONNECTION statement for the replication SQL ...] ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
(You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that has a size of 128KB, with the size of block buffers for caching table index blocks set to 2048 bytes. A ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-time.html
See Section 14.21, “Performance Schema Functions” Given a Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the ... Note As of MySQL 8.0.16, format_time() is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-lock-waits.html
wait_age_secs How long the lock has been waited for, in seconds. These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html
time The time in seconds that the thread has been in its current state. For use with MySQL HeatWave Service and MySQL HeatWave, where the PRIMARY engine is InnoDB and SECONDARY engine is MySQL HeatWave (RAPID). The MySQL process list indicates the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-lock-waits.html
These views display which sessions are blocked waiting on metadata locks, and what is blocking them. For additional information, see the description of the Performance Schema metadata_locks table at Section 29.12.13.3, “The metadata_locks ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
First, modify the value in the table itself: mysql> UPDATE sys.sys_config SET value = 'OFF' WHERE variable = 'debug'; Second, to also ensure that procedure invocations within the current session use the changed value from the table, set the ... This ...
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
In this case, the second SELECT statement in the preceding scenario would execute before the UPDATE statement, and would not wait for the first SELECT to finish. InnoDB tables use row-level locking so that multiple sessions and applications can ...
https://dev.mysql.com/doc/refman/8.0/en/table.html
TABLE is a DML statement introduced in MySQL 8.0.19 which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit ...