PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
Table 12.5 Abbreviated Shift Syntax Abbreviated Syntax Nonabbreviated Syntax <pc>xyz</pc> <p>x</p><p>y</p><p>z</p> <sc>xyz</sc> <s>x</s><s>y</s><s>z</s> <tc>xyz</tc> <t>x</t><t>y</t><t>z</t> <ic>xyz</ic> <i>x</i><i>y</i><i>z</i> An expansion is a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. Online operations are noncopying; that is, they do ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
| Connections | 30023 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 3 | | Created_tmp_tables | 2 | ... | Threads_created | 217 | | Threads_running | 88 | | Uptime | 1389872 | +-----------------------------------+------------+ Many status ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The CREATE INDEX statement only finishes after all transactions that are accessing the table are completed, so that the initial state of the index reflects the most recent contents of the table. Online DDL support for adding secondary indexes means ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
For example, Create DB and Change user correspond to COM_CREATE_DB and COM_CHANGE_USER, respectively. The value is composed from a sequence number and timestamp, in the format SEQ_TIMESTAMP. When the audit log plugin opens the audit log file, it ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
--initialize, -I Command-Line Format --initialize[={OFF|ON}] Type Boolean Default Value OFF This option is used to initialize a MySQL installation by creating the data directory and populating the tables in the mysql system schema. When you start ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. mysqlslap runs in three stages: Create schema, table, and optionally ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
If compression or encryption are enabled, the effective file name (the name actually used to create the log file) differs from the configured file name because it has additional suffixes: If compression is enabled, the plugin adds a suffix of .gz.
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
See the description of that variable for details, as well as for considerations to take into account if you create the directory manually. At plugin startup, if the value assigned to keyring_aws_data_file specifies a file that does not exist, the ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. The following sections illustrate the syntax for creating both kinds of indexes. Characteristics of MEMORY Tables The MEMORY ...Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas or read-only caches for data pulled from other ...