Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-lock-waits-ref.html
To enable this instrument, add the following to the my.cnf file of the monitored server: [mysqld] performance-schema-instrument='wait/lock/metadata/sql/mdl=ON' This report retrieves data on MySQL 5.7 table metadata locks from ... To open the Lock ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
MySQL Enterprise Audit enables standard, policy-based monitoring and logging of connection and query activity, providing an auditing and compliance solution for applications that are governed by both internal and external regulatory guidelines.
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-block-encryption-mode.html
Set this option to aes-256-cbc, for example, under the [mysqld] option group in the MySQL configuration file (/etc/my.cnf): block_encryption_mode=aes-256-cbc When using the AES_ENCRYPT() function, an initialization vector (the key_str value) must be ... If you use the AES_ENCRYPT() encryption function, a block encryption mode with a CBC mode value and key length of 256 is ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configuration-file.html
Upon the completion of the deployment described in this guide, the MySQL configuration file (/etc/my.cnf) contains these configuration settings: [mysqld] datadir=/usr/local/mysql/data socket=/tmp/mysql.sock port=3306 ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configure-authentication.html
To install the server-side auth_socket plugin: Add these options under the [mysqld] option group in the MySQL configuration file (/etc/my.cnf): plugin-load-add=auth_socket.so auth_socket=FORCE_PLUS_PERMANENT plugin-load-add=auth_socket.so Loads the ... When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the account row from the mysql.user ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html
Add these options under the [mysqld] option group in the MySQL configuration file (/etc/my.cnf) so that you can adjust them as necessary. The validate_password component serves to test user-specified passwords and improve security. The component ...
https://dev.mysql.com/doc/refman/8.4/en/alter-logfile-group.html
You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
You may optionally follow size with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
You should also check for configuration files such as /etc/my.cnf or the /etc/mysql directory and delete them. These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a number of platforms, ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
Starting mysqld with --binlog-transaction-compression on the command line or in a my.cnf file causes ndb_log_transaction_compression to be enabled automatically and any setting for the --ndb-log-transaction-compression option to be ignored; to ...