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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disks. The recommended way to do this is to symlink entire database ... You ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
This section describes how the MySQL server and client programs respond to signals. This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). This ...