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/insert-optimization.html
When loading a table from a text file, use LOAD DATA. To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates ...
https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html
As system root, open the file /etc/sysctl.conf in a text editor, and add the line shown here, where P is the number of large pages obtained in the previous step: vm.nr_hugepages=P Using the actual value obtained previously, the additional line ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. It is a good ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-formats.html
When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you can force the table format to FIXED or DYNAMIC with the ROW_FORMAT table option. Two of them, fixed and dynamic format, are chosen automatically depending on ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-connection-strings.html
Write the connection string for each executable into a text file named Ndb.cfg and place this file in the executable's startup directory. With the exception of the NDB Cluster management server (ndb_mgmd), each node that is part of an NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects. One or more undo log files are assigned to a log file group, which is then ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-storage-requirements.html
In a Disk Data table, the first 256 bytes of a TEXT or BLOB column are stored in memory; only the remainder is stored on disk. The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle. As an alternative to the method described in this section, Oracle provides MySQL Repositories for ...