PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
The prepared statement API allows supported SQL statements (see SQL Syntax Permitted in Prepared Statements) to be re-executed without incurring the cost of parsing and optimization each time. The question mark or interrogation point (?) is used as ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-libraries.html
This section provides information about and examples of use of JavaScript libraries in JavaScript stored programs as supported by the Multilingual Engine (MLE) in MySQL Enterprise Edition. First we create a database jslib, and make it the current ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlresult.html
getExecutionTime(): Retrieves the time spent executing this query, to the nearest whole second. An SqlResult is produced whenever a query is executed using sqlExecute.execute(), PreparedStatement.execute(), or Session.runSql(). Methods supported by ...
https://dev.mysql.com/doc/refman/9.7/en/stop-group-replication.html
The default value is 300 seconds; this means that Group Replication components are stopped after 5 minutes if the situation is not resolved before that time, allowing the member to be restarted and rejoin. This statement requires the ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/sys-format-time.html
See Section 14.22, “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 format_time() is deprecated, and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...