PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
On the source server, the output from SHOW PROCESSLIST looks like this: mysql> SHOW PROCESSLIST\G *************************** 1. If you see no Binlog Dump threads on a source server, this means that replication is not running; that is, no replicas ... The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html
To avoid this overhead, do not install the plugin unless you plan to use it. To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script located in the share directory of your MySQL installation: install_rewriter.sql: ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-file-context.html
If you enabled the use of this directory by setting secure_file_priv, you may need to set the context like so: semanage fcontext -a -t mysqld_db_t "/var/lib/mysql-files/(/.*)?" restorecon -Rv /var/lib/mysql-files Edit this path if you used a ... The ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. This mode ...It takes a list of one or more characteristic values separated by ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
This statement requires some privilege for any column in the table. To update this number, run ANALYZE TABLE or (for MyISAM tables) myisamchk -a. Take this into account when specifying a prefix length for a nonbinary string column that uses a ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
For a comparison of this statement with other sources, see Sources of Process Information. MySQL reserves one extra connection to be used by accounts that have the SUPER privilege, to ensure that administrators should always be able to connect and ... SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
You can also retrieve this number from the warning_count system variable: SHOW COUNT(*) WARNINGS; SELECT @@warning_count; A difference in these statements is that the first is a diagnostic statement that does not clear the message list. In this ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
In this case, the server converts and caches the entire program body. Suppose that a client prepares this statement: PREPARE s1 FROM 'SELECT * FROM t1'; The SELECT * expands in the internal structure to the list of columns in the table. If the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
This statement may be a compound statement made up of several statements separated by semicolon (;) characters. The following example shows how to do this for the dorepeat() procedure just shown. This enables the ; delimiter used in the procedure ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
This has several implications: When the routine is invoked, an implicit USE db_name is performed (and undone when the routine terminates). This can be used to refer to a routine that is not in the current database. This means the client must use a ... A stored routine is either a procedure or a ...