PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html
SQL_MODE The SQL mode in effect when the trigger was created, and under which the trigger executes. DEFINER The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format. 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.0/en/innodb-persistent-stats.html
You can also configure automatic statistics recalculation for individual tables by specifying the STATS_AUTO_RECALC clause when creating or altering a table. To override these system-wide settings and configure optimizer statistics parameters for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-configuration.html
In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration files. (Create the file if it does not exist.) For example: $> vi /etc/my.cnf Note We show vi being used here to create the file, but ...For our four-node, four-host NDB Cluster (see Cluster nodes and host computers), it is necessary to write four configuration files, one per node ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-binary.html
Some OS distributions create these as part of the operating system installation process. Change location to the directory containing the downloaded file, unpack the archive, and create a symbolic link named mysql to the mysql directory. This ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/no-login-pluggable-authentication.html
To refer to the no-login authentication plugin in the IDENTIFIED WITH clause of a CREATE USER statement, use the name mysql_no_login. Note Because the nologin account cannot be used directly, the operations required to set up objects that it uses ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/replace.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | ...