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/forcing-innodb-recovery.html
For example, you can add the following line to the [mysqld] section of your option file before restarting the server: [mysqld] innodb_force_recovery = 1 For information about using option files, see Section 6.2.2.2, “Using Option Files”. Only ...
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/innodb-enabling-monitors.html
Both the InnoDB Standard Monitor and InnoDB Lock Monitor must be enabled to have InnoDB Lock Monitor data printed periodically. Both the InnoDB standard Monitor and InnoDB Lock Monitor must be enabled to have InnoDB Lock Monitor data printed ...On ...
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/innodb-recovery.html
Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a backup. In some cases, apparent database page corruption is actually due to the operating system ...After ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Using MySQL Enterprise Backup is the recommended method for backing up InnoDB data. Hot Backups The ... The ...
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 ...