Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.privileges.html
The mysqlbackup command connects to the MySQL server using the credentials supplied with the --user and --password options. Here are the privileges required by mysqlbackup: The minimum privileges for the MySQL user with which mysqlbackup connects ...You can either create a new user with a limited set of privileges, or use an administrative account such as ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-diskio.html
To force smaller, periodic flushes of data from the operating system cache, you can use the innodb_fsync_threshold variable to define a threshold value, in bytes. Use fdatasync() instead of fsync() On platforms that support fdatasync() system calls, ...This memory area is important enough that it is typically recommended that innodb_buffer_pool_size is configured to 50 to 75 percent of system ... If you follow best practices for database ...
https://dev.mysql.com/doc/refman/9.7/en/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ...If a ...If ... If connection problems occur such as communication errors or aborted connections, use these sources of information to diagnose problems: The error ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-undo-tablespaces.html
If default undo tablespaces are moved while the server is offline, the server must be started with the innodb_undo_directory variable configured to the new directory. The innodb_rollback_segments variable can be configured at startup or while the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-backups-rawdata.html
If the server was not started with that variable set, the directory location is the value of the tmpdir system variable. The location of this directory is the value of the system variable replica_load_tmpdir. To guarantee the integrity of the files ...You can use any suitable copying or archive utility, including cp, tar or ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-aws-component.html
The component_keyring_aws keyring component stores keys encrypted by AWS KMS, using the Customer Managed Key (CMK) service, in a file local to the server host. To use component_keyring_aws for keystore management, you must: Write a manifest that ...
https://dev.mysql.com/doc/refman/9.7/en/show-processlist.html
A value of system user refers to a nonclient thread spawned by the server to handle tasks internally, for example, a delayed-row handler thread or an I/O (receiver) or SQL (applier) thread used on replica hosts. The value of this column corresponds ...The MySQL process list indicates the operations currently being performed by the set of threads executing within the ... SHOW [FULL] PROCESSLIST ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-conflict-resolution.html
In this scenario, primary and secondary roles are assigned to the two sources by setting the ndb_conflict_role system variable to the appropriate value on each source (usually one each of PRIMARY, SECONDARY). You can see how many rows have been ...
https://dev.mysql.com/doc/refman/9.7/en/reset-persist.html
Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the ...If ...
https://dev.mysql.com/doc/refman/9.7/en/error-message-language.html
The server searches for the error message file using these rules: It looks for the file in a directory constructed from two system variable values, lc_messages_dir and lc_messages, with the latter converted to a language name. The lc_messages_dir ...