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/x-plugin-sha2-cache-plugin.html
You can use X Plugin to authenticate against such accounts using non-SSL connections with SHA256_MEMORY authentication and SSL connections with PLAIN authentication. The X Plugin authentication cache stores hashes of user account passwords, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-and-plugins.html
Time spent executing the code while the plugin was loaded was still spent even if the plugin is unloaded later. For additional information about the effect of plugin installation and removal, see Section 29.7, “Performance Schema Status ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html
By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used. The statements_with_temp_tables and x$statements_with_temp_tables views have these columns: query The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For a discussion of ...For that reason, this section addresses the modification of tables partitioned by hash or by key ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rotation.html
If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is writing. For example, assuming a log file name of host_name.err, use ...
https://dev.mysql.com/doc/refman/8.0/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-management.html
As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage devices. Within these constraints, InnoDB tries to optimize the database work and the organization of disk files ...The ACID design model requires a certain amount of I/O that might seem redundant, but helps to ensure data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-download.html
You can either: Start MySQL Shell in SQL mode and import the file by issuing: mysqlsh -u root --sql --file /tmp/world_x-db/world_x.sql Enter password: **** Set MySQL Shell to SQL mode while it is running and source the schema file by issuing: \sql ... As part of this quick-start guide, an example schema is provided which is referred to as the world_x ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-download.html
You can either: Start MySQL Shell in SQL mode and import the file by issuing: mysqlsh -u root --sql --file /tmp/world_x-db/world_x.sql Enter password: **** Set MySQL Shell to SQL mode while it is running and source the schema file by issuing: \sql ... As part of this quick-start guide, an example schema is provided which is referred to as the world_x ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...