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/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. (DROP FUNCTION is also used ... DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
Section 23.4.6, “The Event Scheduler and MySQL Privileges”, discusses the privileges required to work with events and the ramifications that events have with regard to privileges when executing. If you are upgrading to MySQL 5.7 from an earlier ... The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that follows. Starting the MySQL server with the --skip-grant-tables ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked. As of MySQL 5.7.32, LOCK TABLES checks that the view definer has the proper privileges on the tables underlying the view. If a session issues a LOCK ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
Any privileges granted specifically for a renamed table or view are not migrated to the new name. You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... If clients encounter Too many connections errors when attempting to ...
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 ...