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/innodb-file-defragmenting.html
Another way to perform a defragmentation operation is to use mysqldump to dump the table to a text file, drop the table, and reload it from the dump file. Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
Restoring from a Logical Backup You can use a utility such as mysqldump to perform a logical backup, which produces a set of SQL statements that can be executed to reproduce the original database object definitions and table data for transfer to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
The following are examples of long running transactions that could cause the History list length to increase: A mysqldump operation that uses the --single-transaction option while there is a significant amount of concurrent DML. InnoDB does not ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `i` int DEFAULT NULL, `j` int DEFAULT NULL, `k` int DEFAULT NULL /*!80023 INVISIBLE */ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci mysqldump and ...An ...
https://dev.mysql.com/doc/refman/8.0/en/invoking-programs.html
$> 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 options. To invoke a MySQL program from the command line ...
https://dev.mysql.com/doc/refman/8.0/en/kerberos-pluggable-authentication.html
The plugin variable name is valid using either underscores or dashes: [mysql] plugin_authentication_kerberos_client_mode=GSSAPI Or: [mysql] plugin-authentication-kerberos-client-mode=GSSAPI At runtime from the command line using the mysql or ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
For example, if you write a data file with mysqldump -T or by issuing a SELECT ... The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write data from a table to a ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
A mysqldump dump includes statements to recreate those tables so that they are not missing after reloading the dump file. MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-rpm.html
To administer the SQL node (MySQL server), you should also install the client RPM, as shown here: $> rpm -Uhv mysql-cluster-community-client-8.0.43-1.el7.x86_64.rpm This installs the mysql client and other MySQL client programs, such as mysqladmin ... This section covers the steps necessary to install the correct executables for each type of NDB Cluster 8.0 node using RPM packages supplied by ...