PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-params.html
The param_description, param_type, param_default, param_min, param_max, param_mandatory, and param_status columns were all added in NDB 7.5.0. The config_params table is a static table which provides the names and internal ID numbers of and other ...