Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-character-set.html
SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...
https://dev.mysql.com/doc/refman/8.4/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html
SHOW BINARY LOG STATUS This statement provides status information about binary log files on the source server, and requires the REPLICATION CLIENT privilege (or the deprecated SUPER privilege). row *************************** File: ...
https://dev.mysql.com/doc/refman/8.4/en/show-master-status.html
This statement is no longer supported, and has been replaced by SHOW BINARY LOG STATUS.
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest table. The in_views parameter and the ...The views are calculated based ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. For information about MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Enables use of the DATA DIRECTORY or INDEX DIRECTORY table option for the CREATE TABLE statement. INDEX Enables use of statements that create or drop (remove) indexes. If you have the CREATE privilege for a table, you can include index definitions ...Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...For ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...This ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while ...