PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
ALTER TABLE t1 COMPRESSION="None"; OPTIMIZE TABLE t1; Page Compression Metadata Page compression metadata is found in the Information Schema INNODB_SYS_TABLESPACES table, in the following columns: FS_BLOCK_SIZE: The file system block size, which is ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
The WORK_COMPLETED column shows the number of buffer pool pages loaded. The WORK_ESTIMATED column provides an estimate of the remaining work, in pages. To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most ...
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
Table 12.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...Also beginning with MySQL 5.7.22: “pretty-printing” of JSON values in an easy-to-read format can be obtained using the JSON_PRETTY() ...
https://dev.mysql.com/doc/refman/5.7/en/key-space.html
Space compression makes the index file smaller than the worst-case figure if a string column has a lot of trailing space or is a VARCHAR column that is not always used to the full length. You can roughly calculate the size for the index file as ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
The OBJECT_TYPE column says USER LEVEL LOCK and the OBJECT_NAME column indicates the lock name. While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained successfully, 0 if the attempt timed ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-formats.html
Two of them, fixed and dynamic format, are chosen automatically depending on the type of columns you are using. 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 ...The third, compressed format, can be created only with the myisampack utility (see Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
The Len column indicates the number of bytes for each key part. For a multiple-column index, the key size is the sum of the Len values for all key parts. myisamchk uses no more memory than its memory-related variables are set to. If you are going to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-api-statistics.html
A number of types of statistical counters relating to actions performed by or affecting Ndb objects are available. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-arbitrator-validity-summary.html
The arbitrator_validity_summary table provides a composite view of the arbitrator with regard to the cluster's data nodes. If it has more than 1 row for longer than a few moments, then either not all nodes are connected to the arbitrator, or all ...