Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
DEFINER The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format. SQL_MODE The SQL mode in effect when the trigger was created, and under which the trigger executes. CHARACTER_SET_CLIENT The ...To see information about a table's triggers, you must have the TRIGGER privilege for the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
An initial start erases any files created for recovery purposes by earlier instances of ndbd. An --initial start is to be used only when starting the ndbd process under very special circumstances; this is because this option causes all files to be ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.4/en/replace.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. There are no user-visible effects other than a possible difference in how the storage engine increments Handler_xxx status variables. REPLACE ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
Definer The account of the user who created the trigger, in 'user_name'@'host_name' format. row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
InnoDB user-created temporary tables and on-disk internal temporary tables are created in a temporary tablespace file named ibtmp1 in the MySQL data directory. For some statements, MySQL creates temporary SQL tables that are not hidden and have ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/global-error-reference.html
Error number: 36; Symbol: EE_FAILED_TO_CREATE_TIMER; Message: Failed to create timer (OS errno %d). Error number: 38; Symbol: EE_FAILED_TO_CREATE_TIMER_QUEUE; Message: Failed to create timer queue (OS errno %d). Error number: 40; Symbol: ... This ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. mysql> CREATE TABLE t (a ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages File-Per-Table Tablespace ... A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
You can do this by issuing a CREATE NODEGROUP command in the cluster management client. ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. REORGANIZE PARTITION statements for NDBCLUSTER tables ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...