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/mysqldumpslow.html
mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. The MySQL slow query log contains information ...-a Do not abstract all numbers to N and strings to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html
The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. To do so, create a text file text_file that contains ...For this you can insert statements like this: SELECT '<info_to_display>' AS ' '; The statement shown outputs ...
https://dev.mysql.com/doc/refman/8.0/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes take place) writes updates and changes as “events” to the binary ...The information in the binary log is stored in different logging formats according to the database changes being ...
https://dev.mysql.com/doc/refman/8.0/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password and caching_sha2_password plugins. Note There are easier alternatives to generating the files required for RSA than the procedure described here: Let the server autogenerate them or use the mysql_ssl_rsa_setup program (deprecated as of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io-type.html
These views summarize file I/O, grouped by host and event type. The host_summary_by_file_io_type and x$host_summary_by_file_io_type views have these columns: host The host from which the client connected. total The total number of occurrences of ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-file-io-type.html
These views summarize file I/O, grouped by user and event type. The user_summary_by_file_io_type and x$user_summary_by_file_io_type views have these columns: user The client user name. total The total number of occurrences of the file I/O event for ...Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files.html
The following discussion describes how to create the files required for SSL and RSA support in MySQL. File creation can be performed using facilities provided by MySQL itself, or by invoking the openssl command directly. RSA key files enable MySQL ...SSL certificate and key files enable MySQL to support encrypted connections using ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io.html
The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the client connected. ios The total number of file I/O events for the host. io_latency The total wait time of timed file I/O events for the ...By default, rows are sorted by descending total file I/O ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. ios The total number of file I/O events for the user. io_latency The total wait time of timed file I/O events for the user. By default, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. Example 17.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate ...The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | +-----------------------------------------------+ | INNODB_BUFFER_PAGE_LRU | | INNODB_BUFFER_PAGE | | INNODB_BUFFER_POOL_STATS | +-----------------------------------------------+ Table Overview INNODB_BUFFER_PAGE: Holds information about each page in the InnoDB buffer ...