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/windows-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
Normally, InnoDB is initialized when the MySQL server is started for the first time. You can place InnoDB options in the [mysqld] group of any option file that your server reads when it starts. The locations of MySQL option files are described in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
There are many reasons why you might want to import tables: To run reports on a non-production MySQL server instance to avoid placing extra load on a production server. The page size of the tablespace must match the page size of the destination ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement. InnoDB in MySQL 8.0.17 and later supports addition of multi-valued indexes on JSON columns using a key_part specification can take the form ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
MySQL NDB Cluster also supports tablespaces using the NDB storage engine. The UNDO keyword, introduced in MySQL 8.0.14, must be specified to create an undo tablespace. The rounding just described is done explicitly, and a warning is issued by the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group member. MySQL then checks each transaction against the ...The use of a PRIVILEGE_CHECKS_USER account helps secure a replication channel against the unauthorized or accidental use of privileged or unwanted ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
row *************************** EXPLAIN: -> Filter: (t3.i > 8) (cost=1.75 rows=5) (actual time=0.019..0.021 rows=6 loops=1) -> Table scan on t3 (cost=1.75 rows=15) (actual time=0.017..0.019 rows=15 loops=1) mysql> EXPLAIN ANALYZE SELECT * FROM t3 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
InnoDB tries to maintain 32 redo log files in total, with each file equal in size to 1/32 * innodb_redo_log_capacity; however, file sizes may differ for a time after modifying the innodb_redo_log_capacity setting. Stop the MySQL server and make sure ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the client with the --xml option). To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. To see the current set of optimizer flags, select the variable value: mysql> SELECT @@optimizer_switch\G *************************** 1. In MySQL 8.0.18 and later, this also ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...