Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
Example transaction event summary information: mysql> SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name LIMIT 1\G *************************** 1. row *************************** EVENT_NAME: transaction COUNT_STAR: 5 ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
The lower_case_table_names setting can only be configured when initializing the server.) When successfully executed from the mysql program, REVOKE responds with Query OK, 0 rows affected. To use these REVOKE statements, you must have the global ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
In addition, SET TRANSACTION can include an optional GLOBAL or SESSION keyword to indicate the scope of the statement. Transaction Characteristic Scope You can set transaction characteristics globally, for the current session, or for the next ...
https://dev.mysql.com/doc/refman/8.4/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. The LIKE clause, if present, indicates which collation names to match. By default, the output from SHOW COLLATION includes all available ...
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. The LIKE clause, if present, indicates which database names to match. If the server was started with the --skip-show-database ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. To see the current set of optimizer flags, select the variable value: mysql> SELECT ...This variable ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-single-file.html
Because the single-file backup can be streamed or piped to another process such as a tape backup or a command, you can use the technique to put the backup onto another storage device or server and avoid significant storage overhead on the original ... To avoid having a large number of backup files to keep track, store, and transport, mysqlbackup conveniently creates backups in a single-file ...It can also pack an existing backup directory into a single file, unpack the single file back to a backup directory, list the ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-binary-log-interface-usage.html
The initial SET statement sets the @source_binlog_checksum user-defined variable that the server takes as an indication that the client is checksum-aware. Program notes: mysql is assumed to be a valid connection handler. This client does nothing ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), available as of MySQL 8.0.23, enables defining attributes that apply to the next query sent to the server. Attributes ...For ...n_params: The number of attributes defined by the bind and name ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-row.html
Errors Errors are not reset between calls to mysql_fetch_row() CR_SERVER_LOST The connection to the server was lost during the query. Its asynchronous counterpart is mysql_fetch_row_nonblocking(), for use by applications that require asynchronous ...