PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
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/index-condition-pushdown-optimization.html
Applicability of the Index Condition Pushdown optimization is subject to these conditions: ICP is used for the range, ref, eq_ref, and ref_or_null access methods when there is a need to access full table rows. The goal of ICP is to reduce the number ... Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an ...