PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
If you have the PROCESS privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. Where can I ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. For this reason, DROP ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
mysql> CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; mysql> FLUSH PRIVILEGES; If binary logging was disabled, enable it again once the user has been created using SET SQL_LOG_BIN=1;. Group ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
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). SIGHUP causes the server to reload the grant tables and to flush tables, logs, the thread ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
How do I prevent GRANT and REVOKE statements from replicating to replica machines? A.14.13. How do I prevent GRANT and REVOKE statements from replicating to replica machines? Start the server with the --replicate-wild-ignore-table=mysql.% option to ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
When session 1 rolls back, it releases its exclusive lock on the row and the queued shared lock requests for sessions 2 and 3 are granted. When session 1 commits, it releases its exclusive lock on the row and the queued shared lock requests for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
Once granted, the duration of the exclusive metadata lock is brief. Session 3: mysql> SELECT * FROM t1; The SELECT statement issued in session 3 is blocked waiting for the exclusive metadata lock requested by the ALTER TABLE operation in session 2 ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-locks.html
This is reset to 0 when a lock is granted for a waiting request. The lock state is shown in the lock_state column; if this is W, the lock is waiting to be granted, and the waiting_for column shows the lock ID of the lock object this request is ...