PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
For additional information, see the description of the Performance Schema metadata_locks table at Section 25.12.12.1, “The metadata_locks Table”. waiting_thread_id The thread ID of the thread that is waiting for the lock. waiting_pid The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-session-ssl-status.html
For each connection, this view displays the SSL version, cipher, and count of reused SSL sessions. The session_ssl_status view has these columns: thread_id The thread ID for the connection.
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-elements.html
To identify them, use this query: SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%thread_pool%'; For more information, see Chapter 25, MySQL Performance Schema. MySQL Enterprise Thread Pool comprises these elements: A plugin ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Changing the ; end-of-statement delimiter (for example, to //) permit ; to be used in a program body. This means that no transactional savepoint is set at the start of the instruction block and the BEGIN clause used in this context has no effect on the current ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
Sometimes the “during query” form happens when millions of rows are being sent as part of one or more queries. If you know that this is happening, you should try increasing net_read_timeout from its default of 30 seconds to 60 seconds or longer, ...Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-server-config.html
The MySQL server listens on a single network socket for TCP/IP connections. This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces. To specify an address, set bind_address=addr at server ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-block-size.html
But setting the size of key nodes equal to the size of the I/O buffer does not always ensure the best overall performance. It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable.
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ...If the cache contains any dirty blocks, the server saves them to disk before destroying and re-creating the ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...