PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.3Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...This is true as long as all data nodes are running and connected to the cluster; for a data node that is missing, there are no rows for the fragment replicas that it ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} ...ndb-distribution: Default distribution for new tables in NDBCLUSTER (KEYHASH or LINHASH, default is ... The following list includes command-line options, system ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. When viewed in terms of events, the process of checking table options is the same for both row-based ...One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 19.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. The threads table contains a ...Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. CREATE TABLE, ALTER TABLE, and DROP TABLE are valid ...Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system ... MySQL Server provides flexible ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. It is strongly recommended that you never change the SQL ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ...As with table partitioned by RANGE, you can use MAXVALUE to represent a value such that any legal value inserted into a given column is always less than this ...