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/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/linux-installation-native.html
This section provides basic instructions for installing MySQL using those package management systems. This can mean that you install a large number of packages in addition to the main MySQL package. You can manually start and stop the server using: ... Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation.html
To use this method, you need to open a Terminal window. You do not need administrator privileges using this method; you can install the MySQL server anywhere using this method. For more information on using this method, you can use the generic ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
In this case, rebuild any such indexes to avoid problems such as incorrect query results. Additional Resources Example showing how to add a collation for full-text searches: Section 14.9.7, “Adding a User-Defined Collation for Full-Text ...