PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications in character units. Column definitions ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). Output is larger than for physical backup, particularly when saved in text ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. Full backups are necessary, but it is not always convenient to create them. They are not optimal in the sense that each successive full backup ...For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
The first of these cases occurs when no hash or ordered indexes exists to handle the query, in which case the query is executed by performing a full table scan. (NDB 7.5.0) Specifies the number of local scan records if many scans are not fully ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-binary.html
To do this, create a new text file in Notepad or another text editor. To do this, create a new text file in Notepad or another text editor and enter the following text: [mysql_cluster] # Options for data node process: ndb-connectstring=198.51.100.10 ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
Note Full permissions are granted to the user executing MySQL Installer to all generated files, such as my.ini. If you installed the full (not web) MySQL Installer package, all .msi files were loaded to the Product Cache folder during the initial ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-top.html
Output is available as plain text or an ASCII graph; you can specify this using the --text (-x) and --graph (-g) options, respectively. For measured load, blue is used for execution time, yellow for send time, red for time spent in send buffer full ... ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
BLOB and TEXT columns only contribute 9 to 12 bytes toward the row size limit because their contents are stored separately from the rest of the row. You have to change some columns to TEXT or BLOBs mysql> CREATE TABLE t (a VARCHAR(10000), b ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
These differences can be combined with other schema differences supported by ndb_restore, including changes to blob and text columns requiring the use of staging tables. --fields-optionally-enclosed-by Command-Line Format ... The NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains ...The INNODB_FT_DELETED table has these columns: DOC_ID The document ID of the newly deleted ...