Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET PASSWORD statement assigns a password to a MySQL user account. The password may be either explicitly ...For example: ALTER USER user IDENTIFIED BY 'auth_string'; Note Clauses for random password generation, password verification, and secondary passwords apply only to accounts that use an authentication plugin that stores credentials internally to ...
https://dev.mysql.com/doc/refman/8.4/en/purge-binary-logs.html
The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name or date. (Bug #18199, Bug #18453) To handle such errors, edit the .index file (which is a simple text file) manually ...The log consists of a set of binary log files, plus an index file (see Section 7.4.4, “The Binary ... PURGE BINARY LOGS { TO 'log_name' | BEFORE datetime_expr } The ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-select.html
SELECT always performs an implicit commit (Section 15.3.3, “Statements That Cause an Implicit Commit”). ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. With storage engines that support ...If the destination table does not exist, logging occurs as ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Enable profiling by setting profiling to 1 or ON: mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-type.html
These views summarize information about statements executed, grouped by host and statement type. The host_summary_by_statement_type and x$host_summary_by_statement_type views have these columns: host The host from which the client connected. total ...By default, rows are sorted by host and descending total ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-type.html
These views summarize information about statements executed, grouped by user and statement type. The user_summary_by_statement_type and x$user_summary_by_statement_type views have these columns: user The client user name. total The total number of ...By default, rows are sorted by user and descending total ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced ...TABLE does not allow for any arbitrary filtering of rows; that is, TABLE does not support any WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. The size of the table slows down the insertion of indexes by log N, assuming B-tree indexes. You ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. For InnoDB, Data_length is the approximate amount of space allocated for the clustered index, in bytes.