Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
statement_performance_analyzer.limit, @sys.statement_performance_analyzer.limit The maximum number of rows to return for views that have no built-in limit. This table contains sys schema configuration options, one row per option. Configuration ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.