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/show-create-trigger.html
SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-function.html
SHOW CREATE FUNCTION func_name This statement is similar to SHOW CREATE PROCEDURE but for stored functions.
https://dev.mysql.com/doc/refman/5.7/en/show-function-code.html
SHOW FUNCTION CODE func_name This statement is similar to SHOW PROCEDURE CODE but for stored functions.
https://dev.mysql.com/doc/refman/5.7/en/show-function-status.html
SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr] This statement is similar to SHOW PROCEDURE STATUS but for stored functions.
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-main.html
The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding replication. The following example illustrates how the three main replication threads, the binary log dump thread, ...
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. The event scheduler thread does not run, is not shown in the ... Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
performance_schema_show_processlist Command-Line Format --performance-schema-show-processlist[={OFF|ON}] Introduced 5.7.39 System Variable performance_schema_show_processlist Scope Global Dynamic Yes Type Boolean Default Value OFF The SHOW ...This ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
If the --verbose option is given, the output is like that of SHOW FULL PROCESSLIST. (See Section 13.7.5.29, “SHOW PROCESSLIST Statement”.) reload Reload the grant tables. --relative, -r Command-Line Format --relative Show the difference between ...You can use it to check the server's configuration and current status, to create and drop databases, and ...