PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
Role names have syntax and semantics similar to account names; see Section 8.2.4, “Specifying Account Names”. As stored in the grant tables, they have the same properties as account names, which are described in Grant Table Scope Column ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is not altered. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. For example, you cannot have two events in the same database with the names anEvent and AnEvent. (See also Bug ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
The unique_subquery and index_subquery subquery-specific access methods also have “or NULL” variants. When the optimizer uses a triggered condition to create some kind of index lookup-based access (as for the first two items of the preceding ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
Do not symlink tables on systems that do not have a fully operational realpath() call. To determine whether your system supports symbolic links, check the value of the have_symlink system variable using this statement: SHOW VARIABLES LIKE ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-by-host-by-current-bytes.html
The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes views have these columns: host The host from which the client connected. current_count_used The current number of allocated memory blocks that have not been freed yet for the ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-by-thread-by-current-bytes.html
The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes views have these columns: thread_id The thread ID. current_count_used The current number of allocated memory blocks that have not been freed yet for the thread. By ...
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-by-user-by-current-bytes.html
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes views have these columns: user The client user name. current_count_used The current number of allocated memory blocks that have not been freed yet for the user. By default, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.