Search Results
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
To alleviate the problem, take the following actions: To continue, you only have to free enough disk space to insert all records. This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports automatic function loading during server ...
https://dev.mysql.com/doc/refman/8.4/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-privileges-table.html
In the output from SHOW FULL COLUMNS, the privileges are all in one column and in lowercase, for example, select,insert,update,references. The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-metrics-table.html
row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
TRX_ROWS_MODIFIED The number of modified and inserted rows in this transaction. The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
Although you can select INFORMATION_SCHEMA as the default database with a USE statement, you can only read the contents of tables, not perform INSERT, UPDATE, or DELETE operations on them. INFORMATION_SCHEMA provides access to database metadata, ...