PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
During startup, discovered tablespace files are used instead those referenced in the data dictionary, and the data dictionary is updated to reference the relocated files. If moving system tablespace files, undo tablespaces, or the data directory, ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. Example: INSTALL COMPONENT 'file://component1', 'file://component2'; A component is named using a URN that begins with ...
https://dev.mysql.com/doc/refman/8.0/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. MySQL is a trademark of Oracle Corporation ...MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed ...
https://dev.mysql.com/doc/refman/8.0/en/invoking-programs.html
To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to do. $> represents the prompt for your ...$> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this capability, two things must be true: Your system must be configured to support IPv6. IPv6 addresses can be specified in account names in ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-plugin.html
As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. Security standards such as PCI, FIPS, and others require use of key management systems to secure, manage, and protect encryption keys in key vaults or ... Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. The ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
Warning Normally, you should never have two servers that update data in the same databases. If (despite this warning) you run multiple servers using the same data directory and they have logging enabled, you must use the appropriate options to ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-services.html
The procedures for installing, controlling, and removing a single MySQL service are described in Section 2.3.4.8, “Starting MySQL as a Windows Service”. For the following instructions, suppose that you want to run the mysqld server from two ...
https://dev.mysql.com/doc/refman/8.0/en/my-print-defaults.html
For example, the mysqlcheck program reads the [mysqlcheck] and [client] option groups. To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client ...