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/innodb-online-ddl-space-requirements.html
Temporary log files: A temporary log file records concurrent DML when an online DDL operation creates an index or alters a table. If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
The data types may differ from what you expect them to be based on a CREATE TABLE statement because MySQL sometimes changes data types when you create or alter a table. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
An NdbTransaction is created each time a table schema operation (such as CREATE TABLE or ALTER TABLE) is performed on an NDB table. Note InnoDB mutexes and rwlocks can also be monitored using Performance Schema tables. Interpret buffer names as ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
If a stored program that modifies data is nondeterministic, it is not repeatable. To create or alter a stored function, you must have the SET_USER_ID privilege (or the deprecated SUPER privilege), in addition to the CREATE ROUTINE or ALTER ROUTINE ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...Statements that change the mysql database indirectly are logged as statements regardless of the value of ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory. When the optional DATA DIRECTORY [=] 'clone_dir' clause is not used, a cloning operation ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
To use a dictionary, it must first be added to the masking_dictionaries system table and given a name. The dictionaries are read from the table and loaded to the cache during initialization of the components (on server startup). Note Always edit ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. This occurs even when ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. You cannot define where within the system tablespace your tables are allocated. In a newly created ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-api-statistics.html
Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned scans; threads blocked while waiting for the completion of various operations; and data and events sent and ... A ...