PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html
An SQL statement sent by the application to a server not in the required state produces an error. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the host. avg_latency The average wait time per timed occurrence of the stage event for the host. By default, rows are sorted by host and descending total latency. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the user. avg_latency The average wait time per timed occurrence of the stage event for the user. By default, rows are sorted by user and descending total stage latency.
https://dev.mysql.com/doc/refman/5.7/en/procedure-analyse.html
The arguments are optional and are used as follows: max_elements (default 256) is the maximum number of distinct values that ANALYSE() notices per column. max_memory (default 8192) is the maximum amount of memory that ANALYSE() should allocate per ... ANALYSE([max_elements[,max_memory]]) Note PROCEDURE ANALYSE() is deprecated as of MySQL 5.7.18, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...
https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. mysql may also be used in batch mode: you place your ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
Most full-text variables described in this section must be set at server startup time. Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. The innodb_ft_num_word_optimize option ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...