Search Results
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
However, enabling FIPS mode does not require that an encrypted connection must be used, or that user credentials must be encrypted. MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system.
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
cat t1.ibd | innochecksum --write=crc32 - > a.ibd Running innochecksum on Multiple User-defined Tablespace Files The following examples demonstrate how to run innochecksum on multiple user-defined tablespace files (.ibd files). On Windows systems, ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: Initialization In the initialization phase, the server determines how much concurrency is permitted during the operation, taking into account storage ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
Such a server could access any file on the client host to which the client user has read access. In this environment, the client with respect to the MySQL server actually is the Web server, not a remote program being run by users who connect to the ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
Users: You may need (or want) to create a specific mysql user to own the MySQL directory and data. You can do this through the Directory Utility, and the mysql user should already exist. For use in single user mode, an entry for _mysql (note the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-size-pl.html
(Many Linux and other operating system distributions provide their own packages for this library.) A MySQL user account having the necessary privileges. If you do not wish to use an existing account, then creating one using GRANT USAGE ON ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-innodb-cluster-introduction.html
Operations enable you to create MySQL Router users at the cluster level, to work with the MySQL Routers bootstrapped against the cluster, and so on. Advanced users can also take advantage of a multi-primary mode, where all instances are primaries.
https://dev.mysql.com/doc/refman/8.4/en/mysql-server.html
To run the server as some specific user, add an appropriate user option to the [mysqld] group of the global /etc/my.cnf option file, as shown later in this section. To start up MySQL using this method, append a command like the one following to the ... MySQL distributions on Unix and Unix-like system include a script named mysql.server, which starts the MySQL server using ...
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Moreover, the apply-log step for preparing a backup for restoration can take a very long time as mysqlbackup has huge ibbackup_logfile files (created from the big redo log files) to apply to the backup. Therefore, users should be careful in ...