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/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
Prior to MySQL 8.0.16, CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. The encryption clause is not shown for tables created in general tablespaces. When creating a table with strict mode ...The ...
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 ...