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/stored-routines-privileges.html
The ALTER ROUTINE privilege is needed to alter or drop stored routines. If the automatic_sp_privileges system variable is 0, the EXECUTE and ALTER ROUTINE privileges are not automatically granted to and dropped from the routine creator. The account ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
By direct grant-table modification using statements such as INSERT and UPDATE. This method is discouraged but possible for users with the appropriate privileges on the mysql system schema that contains the grant tables. Privileges for the mysql ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). In particular, installing only the CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/8.0/en/csv-storage-engine.html
When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. When you store data into the table, the storage engine saves it into the data file in comma-separated ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
For example, you can save the state of the buffer pool after reaching a stable throughput under a steady workload. Only tablespace IDs and page IDs necessary to locate the appropriate pages are saved to disk. By default, tablespace ID and page ID ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions-limitations.html
You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name ... This section describes restrictions and limitations of the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
InnoDB offers all four transaction isolation levels described by the SQL:1992 standard: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. You can enforce a high degree of consistency with the default REPEATABLE READ level, for ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
The size of the table slows down the insertion of indexes by log N, assuming B-tree indexes. If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to make data insertion even faster. When loading a table from ... To optimize insert speed, combine many small operations into a single large ...