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/innodb-performance-optimizer-statistics.html
You can query optimizer statistics data in the mysql.innodb_table_stats and mysql.innodb_index_stats tables. You can view the last_update column of the mysql.innodb_table_stats and mysql.innodb_index_stats tables to see when statistics were last ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-server-clients.html
On Unix, set the MYSQL_UNIX_PORT and MYSQL_TCP_PORT environment variables to point to the Unix socket file and TCP/IP port number before you start your clients. If you normally use a specific socket file or port number, you can place commands to set ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared ...
https://dev.mysql.com/doc/refman/8.0/en/nested-join-optimization.html
As a result, the execution time for the query may improve immensely. The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard.
https://dev.mysql.com/doc/refman/8.0/en/programs-development.html
This section describes some utilities that you may find useful when developing MySQL programs. This works well for programs that use the last instance of an option that is specified multiple times. Check the source code of any of the standard MySQL ...In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given ...
https://dev.mysql.com/doc/refman/8.0/en/recovery-from-backups.html
| mysql For more information about using mysqlbinlog to process binary log files, see Section 9.5, “Point-in-Time (Incremental) Recovery”. The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < ... Now, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
You can also get this list using the mysqlshow --status db_name command. With the removal of .frm files in MySQL 8.0, this column now reports a hardcoded value of 10, which is the last .frm file version used in MySQL 5.7. For example, InnoDB stores ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-simple-8bit.html
This section describes how to add a simple collation for an 8-bit character set by writing the <collation> elements associated with a <charset> character set description in the MySQL Index.xml file. You can check the variable value as follows, ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. The BINARY and ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
To examine the source for the BLACKHOLE engine, look in the sql directory of a MySQL source distribution. The maximum key length is 3072 bytes as of MySQL 8.0.27. The “dummy” mysqld process acts as a replica, applying the desired combination of ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...