PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE [FUNCTION|PROCEDURE]. ALTER and DROP statements for stored procedures and functions are also replicated. Where ...
https://dev.mysql.com/doc/refman/8.0/en/full-disk.html
Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ALTER TABLE statement. The exception is that for ALTER TABLE, the old table is left unchanged. This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
HAS_DEFAULT A boolean value indicating whether a column that was added instantly using ALTER TABLE ... DEFAULT_VALUE The initial default value of a column that was added instantly using ALTER TABLE ... For related usage information and examples, see ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
TRX_WEIGHT The weight of a transaction, reflecting (but not necessarily the exact count of) the number of rows altered and the number of rows locked by the transaction. Transactions that have changed nontransactional tables are considered heavier ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-extensions-table.html
The SCHEMATA_EXTENSIONS table (available as of MySQL 8.0.22) augments the SCHEMATA table with information about schema options. The SCHEMATA_EXTENSIONS table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. Specify a value that is too small, and the CREATE TABLE or ALTER TABLE statement fails. Because processors and cache memories have increased in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
\! ls -l data/test/big_table.ibd CREATE TABLE key_block_size_4 LIKE big_table; ALTER TABLE key_block_size_4 key_block_size=4 row_format=compressed; INSERT INTO key_block_size_4 SELECT * FROM big_table; commit; -- Check how much space is needed for a ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
INSTANT_COLS shows number of columns in the table prior to adding the first instant column using ALTER TABLE ... The HAS_DEFAULT and DEFAULT_VALUE columns only apply to columns added instantly using ALTER TABLE ... You can extract metadata about ...