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/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html
Use of SHOW CREATE VIEW requires the SHOW VIEW privilege, and the SELECT privilege for the view in question. SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/show-status.html
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...
https://dev.mysql.com/doc/refman/5.7/en/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...
https://dev.mysql.com/doc/refman/5.7/en/shutdown.html
A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, and sending an OK packet to the client. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reload-saved.html
That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). This procedure disables ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-save.html
That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This ...