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/table-size-limit.html
If the pointer size is too small for an existing table, you can change the options with ALTER TABLE to increase a table's maximum permissible size. ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only ... The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
To make the generated invisible primary key on auto_1 visible, execute this ALTER TABLE statement: mysql> ALTER TABLE auto_1 ALTER COLUMN my_row_id SET VISIBLE; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
NO_ENGINE_SUBSTITUTION Control automatic substitution of the default storage engine when a statement such as CREATE TABLE or ALTER TABLE specifies a storage engine that is disabled or not compiled in. For ALTER TABLE, a warning occurs and the table ...When working with InnoDB tables, consider also the innodb_strict_mode system ... The MySQL server can operate in different SQL modes, and can apply these modes ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...The THREAD_ID and EVENT_ID values taken together uniquely identify the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. If the memcached server is used for multiple applications, or with more than one InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
These rules also apply to existing nonpartitioned tables that you wish to partition using ALTER TABLE ... The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must ... This section discusses the relationship of partitioning keys with primary keys and unique ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. As of MySQL 8.0.14, a derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
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 XML. By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
The row format of a table can also be defined explicitly using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. If you create the table, load data, and then run ALTER TABLE to add a primary key later, that operation is much ...