Search Results
https://dev.mysql.com/doc/refman/8.4/en/my-print-defaults.html
my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified option groups. For example, the mysqlcheck program reads the [mysqlcheck] and ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. Have you edited ... The ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
MYSQL_HOME is an environment variable containing the path to the directory in which the server-specific my.cnf file resides. Suppose that a my.cnf file contains this line: !include /home/mydir/myopt.cnf And suppose that /home/mydir/myopt.cnf looks ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
It may be preferable to set such variables in my.cnf rather than in mysqld-auto.cnf. The MySQL server maintains system variables that configure its operation. A system variable can have a global value that affects server operation as a whole, a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Optimistic backup is a feature for improving performance for backing up and restoring huge databases in which only a small number of tables are modified frequently. During a hot backup of a huge database (say, in the order of terabytes), huge redo ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
Restore backup of s2 onto the host for s3: s3> mysqlbackup --defaults-file=/etc/my.cnf \ --datadir=/var/lib/mysql \ --backup-image=/backups/my.mbi_2206_1429 \ --backup-dir=/tmp/restore_`date +%d%m_%H%M` copy-back-and-apply-log Note The command above ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
You can configure InnoDB buffer pool size offline or while the server is running. For additional information about configuring buffer pool size online, see Configuring InnoDB Buffer Pool Size Online. When increasing or decreasing ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
You can dynamically set the value of the binlog_rows_query_log_events system variable to ON, put the new value in the [mysqld] section of your MySQL configuration file (my.cnf) so it remains in effect when you restart the server. Severity Minor ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
The following is a typical command for restoring a single-file backup containing encrypted InnoDB tablespaces: $ mysqlbackup --defaults-file=/usr/local/mysql/my.cnf --backup-image=/home/admin/backups/my.mbi \ --backup-dir=/home/admin/restore-tmp ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...