PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. When two or more threads executing in the server need to access the same resource, the threads compete ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 10.3.5, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
It reads the MyISAM index file directly, so it must be run on the server host where the table is located. Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. myisam_ftdump scans and dumps the entire ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysql-cluster-options-variables.html
This section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general information on using these, and for other options and variables not specific to NDB Cluster, see Section 7.1, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-retries Command-Line ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...