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/sys-sys-config.html
This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The sys_config table has these columns: variable The configuration ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-ndb-transid-mysql-connection-map-table.html
For this table to be created, the MySQL Server must be a binary supplied with the NDB Cluster distribution, or one built from the NDB Cluster sources with NDB storage engine support enabled. The ndb_transid_mysql_connection_map table provides a ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-memory-tables.html
Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional ...B-tree ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
For example, DDL statements such as CREATE TABLE and ALTER TABLE are always logged as statements, without regard to the logging format in effect, so the following statement-based rules for --binlog-do-db always apply in determining whether or not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
A change in max_heap_table_size takes effect for MEMORY tables that are created or updated using ALTER TABLE ... When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-extensions-table.html
The COLUMNS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about column attributes defined for primary and secondary storage engines. The COLUMNS_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-connection-control-table-reference.html
Table 28.8 INFORMATION_SCHEMA Connection Control Tables Table Name Description CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account .
https://dev.mysql.com/doc/refman/8.0/en/information-schema-firewall-table-reference.html
Table 28.9 INFORMATION_SCHEMA Firewall Tables Table Name Description Deprecated MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles Yes MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists Yes .
https://dev.mysql.com/doc/refman/8.0/en/information-schema-thread-pool-table-reference.html
Table 28.7 INFORMATION_SCHEMA Thread Pool Tables Table Name Description TP_THREAD_GROUP_STATE Thread pool thread group states TP_THREAD_GROUP_STATS Thread pool thread group statistics TP_THREAD_STATE Thread pool thread information .
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. Examples in this section use the city table in the world_x schema. city Table Description The city table has five columns (or fields). You can combine traditional data ...