PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
An update of the following form is very fast: UPDATE tbl_name SET count_col=count_col+1 WHERE key_col=constant; This is very important when you use MySQL storage engines such as MyISAM that has only table-level locking (multiple readers with single ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
The FROM clause, if present, restricts the tables shown to those present in the db_name database. SHOW OPEN TABLES output has these columns: Database The database containing the table. In_use The number of table locks or lock requests there are for ... SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
SET forms of the statement insert rows based on explicitly specified values. For example, if you specify a column list that does not name all the columns in the table, unnamed columns are set to their default values. If both the column list and the ...[ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] SET assignment_list [ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
For a comparison of JSON_INSERT(), JSON_REPLACE(), and JSON_SET(), see the discussion of JSON_SET(). \ Please use JSON_MERGE_PRESERVE/JSON_MERGE_PATCH instead 1 row in set (0.00 sec) For additional examples, see the entry for JSON_MERGE_PRESERVE().
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition.html
Normally it is not necessary to define TCP/IP connections; NDB Cluster automatically sets up such connections for all data nodes, management nodes, and SQL or API nodes. It is also possible to change the default values for these parameters by ...To ...
https://dev.mysql.com/doc/refman/5.7/en/error-log.html
For information about selecting the error message character set and language, see Section 10.6, “Error Message Character Set”, and Section 10.12, “Setting the Error Message Language”. This section discusses how to configure the MySQL server ...The error log contains a record of mysqld startup and shutdown ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. (In other words, any ...The LEFT JOIN condition is used to decide how to retrieve rows from table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-model.html
Memory used depends on the load actually seen, not the load estimated or explicitly configured for. As the Performance Schema collects data, memory is allocated in the corresponding buffer. With the value set to 0: The corresponding internal buffer ...The buffer size is unbounded, and may grow with the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-index.html
--database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in which the table resides. --ndb-connectstring Command-Line Format --ndb-connectstring=connection_string Type String Default Value [none] Set ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
For example, the following stored procedure has a body made up of a BEGIN ... The following example shows how to do this for the dorepeat() procedure just shown. The delimiter is changed to // to enable the entire definition to be passed to the ...