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/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%statement/%'; mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%stage/%'; Ensure that ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to cause the server to load it ...To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
This section describes aspects of how the MySQL server manages client connections. Individual server plugins or components may implement their own connection interface: X Plugin enables MySQL Server to communicate with clients using X Protocol.
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
The following statements cause that error because the named condition is associated with a MySQL error number: DECLARE no_such_table CONDITION FOR 1051; SIGNAL no_such_table; If a condition with a given name is declared multiple times in different ...For information about the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics ...SIGNAL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. Reduced locking and waiting for MySQL ...An exclusive metadata lock on the table may be taken briefly during the execution phase of the ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
By default this is 1024, but the value may be changed at compile time when MySQL is built from source. If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. Most tables ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, is used with the SET {ACTIVE | INACTIVE} clause to mark an InnoDB undo tablespace as active or inactive. The ENCRYPTION clause enables or disables page-level data encryption for an InnoDB general ...It ...
https://dev.mysql.com/doc/refman/8.0/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. For example, to specify a directory to be used by MySQL client programs, list it in the [client] group of your option file. The examples given here show what the setting might ...To change these defaults, use the --character-set-server and --collation-server options when you start the ...