Search Results
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
X Plugin supports compression of messages sent over X Protocol connections. Connections can be compressed if the server and the client agree on a mutually supported compression algorithm. Enabling compression reduces the number of bytes sent over ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/refman/8.4/en/year.html
The YEAR type is a 1-byte type used to represent year values. It can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) with an explicit display width. Note he YEAR(4) data type using an explicit display ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-compression-options.html
For an overview on backup compression, see Section 4.3.4, “Making a Compressed Backup”. For a regular backup, among all the storage engines supported by MySQL, only data files of the InnoDB format are compressed, and they bear the .ibz ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
For an overview of incremental backups and usage examples for these options, see Section 4.3.3, “Making a Differential or Incremental Backup” and Section 5.1.3, “Restoring an Incremental Backup”. To take an incremental backup, specify the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
This section describes the performance considerations for backing up a database with MySQL Enterprise Backup. When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-report-options.html
There are two options for controlling the progress reporting function of mysqlbackup: --show-progress and --progress-interval: --show-progress[={stderr|stdout|file:FILENAME|fifo:FIFONAME|table|variable}] Command-Line Format ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/standard-options.html
The general options are options of a general nature, or options that are not classified under any other specific option group: The following general options also exist for the mysql command. Full descriptions for these options can be found in the ...