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/select-benchmarking.html
To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is always zero, but mysql prints a line displaying approximately how long the statement took to ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by them. In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The ...
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name or ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
From MySQL 8.0.16, when insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. For an update event, the partition ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. The LIKE clause, if present, indicates which table names (not trigger names) to match and causes the statement to display triggers for those ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-use-cases.html
There is no need for server failover, and the multi-source update everywhere nature ensures that even updates are not blocked in the event of a single server failure. There is a distributed recovery procedure to ensure that when servers join the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-docker.html
Downloading a MySQL NDB Cluster Docker Image Downloading the Docker image in a separate step is not strictly necessary; however, performing this step before you create your Docker containers ensures your local image is up to date. To download the ...Follow the instructions on the right of the page to accept the license ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. Stored routine information is also available from the INFORMATION_SCHEMA PARAMETERS and ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens.html
MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. An application can use token locks to indicate to other ...The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
The idea of making pages in the buffer pool “young” or “not young” refers to transferring them between the sublists at the head and tail of the buffer pool data structure. For related usage information and examples, see Section 17.15.5, ...