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/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. You ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...After deleting a large part of a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-networking-issues.html
Applications using the cluster and user of those applications must not be permitted to have direct access to the management and data node hosts. It is extremely important to remember that NDB Cluster “out of the box” is not secure; you or your ... In this section, we discuss basic network security issues as they relate to NDB ...Also see Section 25.4.1, “Quick ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
In the worst case, you might have a new clean index file without information about the data file, and then the next operation you perform could overwrite the data file. QUICK If you use the QUICK option, REPAIR TABLE tries to repair only the index ...Important Make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data ...Although normally ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
For object definitions that refer to the utf8mb4 character set, you can dump them with mysqldump prior to downgrading, edit the dump file to change instances of utf8mb4 to utf8, and reload the file in the older server, as long as there are no 4-byte ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...Note This discussion focuses primarily on converting between utf8mb3 ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
If you encounter an error with InnoDB tables, restart the server and see whether the problem persists, or whether the error affected only cached data in memory. If the problem occurs during compilation, include the exact error messages and also a ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
To initiate replication, the binary logs required for the recipient to catch up to the donor must not be purged between the time that the data is cloned and the time that replication is started. Note that if the settings master_info_repository=FILE ...In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which enables using the clone plugin for provisioning Group Replication members and ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. This means that, if the index requires unique values, duplicate-key errors occur for values ... A BLOB is a binary large object that can hold a variable amount of ...In most respects, you can ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
This does not apply to files and directories for specific products, such as the MySQL server data directory in %ProgramData% that is owned by SYSTEM. This includes defining custom file paths for the error log, general log, slow query log (including ...Note Full permissions are granted to the user executing MySQL Installer to all generated files, such as ...Unlike the initial ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
An NDB tablespace to be dropped must not contain any data files; in other words, before you can drop an NDB tablespace, you must first drop each of its data files using ALTER TABLESPACE ... Similar to the system tablespace, truncating or dropping ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
To restore data from the binary log, you must know the name and location of the current binary log files. By default, the server creates binary log files in the data directory, but a path name can be specified with the --log-bin option to place the ...The source of information for point-in-time recovery is the set of binary log files generated subsequent to the full backup ...Viewing log ...