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/show-variables.html
A WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
Transactions are replicated in a format that is used to apply row transformations only, without having to re-execute transactions again (row-based format). Furthermore, given that changes are propagated and applied in row-based format, this means ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html
When tables, table rows, partitions, or indexes are deleted, associated pages remain in the buffer pool until space is required for other data. The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-limits.html
Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by the deleted rows available for re-use by inserts on the same table only. A rolling restart of the cluster also frees any memory used by ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. To set the table size explicitly, set the performance_schema_accounts_size system variable at server startup. For a description of how the Performance Schema ...For each account, the table counts the current and total number of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. For a description of how the Performance ...For each host name, the table counts the current and total number of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. To set the table size explicitly, set the performance_schema_users_size system variable at server startup. For a description of how the Performance Schema maintains ...For each user name, the table counts the current and total number of ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
All changes are subject to the internal row-size limit of 65,535 bytes, which may cause some attempts at data type changes to fail. See Section 10.4.7, “Limits on Table Column Count and Row Size”. In some cases, MySQL silently changes column ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmpmem.html
Each row of the two tables described here corresponds to a single page size. Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to 16KB. The INNODB_CMPMEM and INNODB_CMPMEM_RESET ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memoryusage.html
For the used_pages and total_pages columns, resources are measured in pages, which are 32K in size for DataMemory and 8K for IndexMemory. For long message buffer memory, the page size is 256 bytes. Querying this table provides information similar ...