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/binary-log.html
You should not manually edit this file while mysqld is running; doing so would confuse mysqld. However, the benefits of the binary log in enabling you to set up replication and for restore operations generally outweigh this minor performance ... The ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the ...Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
Users can invoke the mysql_ssl_rsa_setup utility manually (deprecated as of MySQL 8.0.34). In this case, the MySQL distribution need not have been compiled using OpenSSL as long as the openssl command is available. Automatic SSL and RSA File ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
The location of this default directory is the same as for the keyring_file_data system variable. See the description of that variable for details, as well as for considerations to take into account if you create the directory manually. The location ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 8.4.4.3, “Keyring Plugin ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html
This could involve making file copies, manually copying them, and so on. This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
In this case, either remove the statement manually before replaying the dump file, or output the dump file without the statement. Only use this option for a server where GTIDs are in use if you are sure that the required GTID set is already present ...To work around this issue, use the --result-file option, which creates the output in ASCII format: mysqldump [options] --result-file=dump.sql It is not recommended to load a dump file when GTIDs are enabled on the server (gtid_mode=ON), if your dump file includes system ...
https://dev.mysql.com/doc/refman/8.0/en/server-side-help-support.html
MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP Statement”). This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/windows-start-service.html
To do this, use the --install-manual option rather than the --install option: C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --install-manual Removing the service To remove a server that is installed as a service, first stop it if it is ...This command invokes the MySQL administrative utility mysqladmin to connect to the server and tell it to shut ... On Windows, the recommended way to run MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html
Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server. To set a larger value, start mysql like this: $> mysql ... A ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
(This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON logging, it uses the directory containing the current audit log file as the location to search for readable ...