PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-index-columns.html
This table provides information about indexes on NDB tables. The columns of the index_columns table are listed here, along with brief descriptions: table_id Unique ID of the NDB table for which the index is defined Name of the database containing ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
For a VARCHAR, this often involved adding more spaces than there were characters in the original string. The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.42, as compared to earlier ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
Here is a sample session that demonstrates use of mysqlimport: $> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test $> ed a 100 Max Sydow 101 Count Dracula . The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
See Section 10.4.2.2, “Optimizing for Character and String Types” for reasons why a binary VARCHAR column is sometimes preferable to an equivalent BLOB column. When storing a large blob containing textual data, consider compressing it first. Do ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
For column values less than 8KB in size, use binary VARCHAR instead of BLOB. For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). OPTIMIZE TABLE reorganizes the physical storage of ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
For example: CREATE TABLE t1 ( FTS_DOC_ID BIGINT unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL DEFAULT '', text mediumtext NOT NULL, PRIMARY KEY (`FTS_DOC_ID`) ) ENGINE=InnoDB; CREATE UNIQUE INDEX FTS_DOC_ID_INDEX on t1(FTS_DOC_ID); ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
For MyISAM tables that change frequently, try to avoid all variable-length columns (VARCHAR, BLOB, and TEXT). Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk ...