PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-server-operations.html
The server_operations table contains entries for all ongoing NDB operations that the current SQL node (MySQL Server) is currently involved in. It effectively is a subset of the cluster_operations table, in which operations for other SQL and API ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-transporters.html
In NDB 8.0.37 and later, you can obtain similar information about individual transporters from the transporter_details table. This information is shown in the table's status column, which can have any one of the following values: CONNECTING, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-count.html
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by using the MySQL statement SELECT COUNT(*) FROM tbl_name. Usage ndb_select_count [-c connection_string] -ddb_name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Client A creates a table containing two index records (90 and 102) and then starts a transaction that places an exclusive lock on index records with an ID greater than 100. Intention Locks InnoDB supports multiple granularity locking which permits ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
mysqlslap runs in three stages: Create schema, table, and optionally any stored programs or data to use for the test. --create=value Command-Line Format --create=value Type String The file or string containing the statement to use for creating the ...Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. | TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html
memory_tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. disk_tmp_tables The total number of internal on-disk temporary tables created by occurrences of the statement. These views list ...db ...