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/backup-methods.html
You can also create a binary backup simply by copying the table files, as long as the server is not updating anything. Making Delimited-Text File Backups To create a text file containing a table's data, you can use SELECT * INTO OUTFILE 'file_name' ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
Leftover Digits Number of Bytes 0 0 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 Date and Time Type Storage Requirements For TIME, DATETIME, and TIMESTAMP columns, the storage required for tables created before MySQL 5.6.4 differs from tables created from 5.6.4 ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. You can use OPTIMIZE TABLE or myisamchk -r to ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. The grant tables must be properly set up so that the server can use them for access control. For some distribution types (such as ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and re-create each index. Some variable changes require that you rebuild the FULLTEXT indexes in your tables. Note Minimum and maximum ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-remarks.html
However, all data and indexes added to tables created after a new node group has been added are distributed automatically among all cluster data nodes, including those added as part of the new node group. Normal DML operations using NDB Cluster data ...The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are distributed across all data nodes, including the new ones, by means of the ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. Note Loading a dump file that contains a MySQL 5.7 mysql schema re-creates two tables that are no ...For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & If there are encrypted InnoDB tablespaces, use the --early-plugin-load option to load the keyring ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
Note Named time zones can be used only if the time zone information tables in the mysql database have been created and populated. The MySQL installation procedure creates the time zone tables, but does not load them. This section describes the time ...Beginning with MySQL 8.0.19, time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
One symptom of fragmentation is that a table takes more space than it “should” take. Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
] HANDLER tbl_name CLOSE The HANDLER statement provides direct access to table storage engine interfaces. OPEN statement opens a table, making it accessible using subsequent HANDLER ... This table object is not shared by other sessions and is not ...