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/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. OPTIMIZE TABLE copies the data part of ...The reorganized tables require less disk I/O to perform full table ...When using COMPACT row format and variable-length character sets, such as utf8mb4 or sjis, ...
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/innodb-memcached-troubleshoot.html
loose-daemon_memcached_option='-c 64' To troubleshoot problems where the memcached daemon is unable to store or retrieve InnoDB table data, encode the -vvv memcached option in the daemon_memcached_option configuration parameter in the MySQL ...If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-metrics-table.html
[mysqld] innodb_monitor_enable = log,metadata_table_handles_opened,metadata_table_handles_closed When enabling multiple counters or modules in a configuration file, specify the innodb_monitor_enable variable followed by counter and module names ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
By default, the memcached protocol is used to read and write data directly to InnoDB, letting MySQL manage in-memory caching using the InnoDB buffer pool. Advanced users can configure the system as a traditional memcached server, with all data ...
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 ...