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/kill.html
KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
Creation of a table of type MERGE does not check whether the underlying tables are compatible types. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld.html
mysql_thread_init() Call it in each thread you create that accesses MySQL. The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client application. The main benefits are increased speed and more simple ...
https://dev.mysql.com/doc/refman/5.7/en/loop.html
Example: CREATE PROCEDURE doiterate(p1 INT) BEGIN label1: LOOP SET p1 = p1 + 1; IF p1 < 10 THEN ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; END; . [begin_label:] LOOP statement_list END LOOP [end_label] LOOP implements a ...
https://dev.mysql.com/doc/refman/5.7/en/lz4-decompress.html
The lz4_decompress utility decompresses mysqlpump output that was created using LZ4 compression. Invoke lz4_decompress like this: lz4_decompress input_file output_file Example: mysqlpump --compress-output=LZ4 > dump.lz4 lz4_decompress dump.lz4 ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
If possible, classify reports as “live” or as “statistical”, where data needed for statistical reports is created only from summary tables that are generated periodically from the live data. This section lists a number of miscellaneous tips ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/mrr-optimization.html
The MRR optimization is not supported with secondary indexes created on virtual generated columns. Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-ftdump.html
Example: Suppose that the test database contains a table named mytexttable that has the following definition: CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ) ENGINE=MyISAM; The index on id is index 0 ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...