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/locking-issues.html
External locking occurs when the server and other programs lock MyISAM table files to coordinate among themselves which program can access the tables at which time. MySQL manages contention for table contents using locking: Internal locking is ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
Maximum and minimum word length values are configurable using the innodb_ft_max_token_size and innodb_ft_min_token_size variables. The stopword list is loaded and searched for full-text queries using the server character set and collation (the ...
https://dev.mysql.com/doc/refman/5.7/en/binlog.html
This statement can execute only format description events and row events. It is generated by the mysqlbinlog program as the printable representation of certain events in binary log files. (See Section 4.6.7, “mysqlbinlog — Utility for Processing ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | rewriter_enabled | ON | ... Note If ...
https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html
A user with the SUPER or REPLICATION CLIENT privilege may execute this statement. SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. This statement is used as part of the procedure described in Section 13.4.1.1, “PURGE ...
https://dev.mysql.com/doc/refman/5.7/en/show-profiles.html
SHOW PROFILES The SHOW PROFILES statement, together with SHOW PROFILE, displays profiling information that indicates resource usage for statements executed during the course of the current session. Note The SHOW PROFILE and SHOW PROFILES statements ...
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
Log flushing occurs when you issue a FLUSH LOGS statement; execute mysqladmin with a flush-logs or refresh argument; or execute mysqldump with a --flush-logs option. You can control the general query and slow query logs during runtime. MySQL Server ...
https://dev.mysql.com/doc/refman/5.7/en/close.html
If not closed explicitly, a cursor is closed at the end of the BEGIN ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-events.html
An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by ...In ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
If a statement uses subqueries, there can be mutliple preparations, optimizations, and executions, as well as subquery-specific transformations. Now we can examine the trace, whose first column (QUERY), containing the original statement to be ...