Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement. It can do the following: Optimize the loading of data sorted by primary key. Use a second session to monitor bulk load progress: If the data is sorted, there is a single stage: ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36142157) Following an unplanned shutdown and restart, the file that was in use by the server for writing at the time may be broken or otherwise unreadable. (Bug #36006295) Character Set Support When the character_set_server system variable ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
The client program and the server communicate, with the client sending to the server the client user name (the operating system user name by default) and password: The client user name is the external user name. To uninstall it, use UNINSTALL ...
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
A time instant is said to be preserved when it always refers to the same point in time when its value is being stored to or retrieved from a database, no matter what time zones the database server and the clients are operating in. To preserve time ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
A time instant is said to be preserved when it always refers to the same point in time when its value is being stored to or retrieved from a database, no matter what time zones the database server and the clients are operating in. To preserve time ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
binary log files Binary log files from the server, which are included in a backup by default (except when the backup is created with the --use-tts option). They allow a snapshot of the server to be taken, so a server can be cloned to its exact state. A copy of the index file on the MySQL server that lists all the used binary log files, with the locations of the binary log files properly updated to point to the files' locations in the backup, is included into the backup as well also under the datadir ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
For programs that use the C API, call mysql_options() to specify the RSA public key file by passing the MYSQL_SERVER_PUBLIC_KEY option and the name of the file, or request the public key from the server by passing the MYSQL_OPT_GET_SERVER_PUBLIC_KEY ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
For convenience, MySQL Enterprise Backup can also read settings from the [client] section, for configuration options that are common between MySQL Enterprise Backup and other programs that connect to the MySQL server. MySQL Enterprise Backup A ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the source. LOCAL assigns a GTID including the replica's own UUID (the server_uuid setting). uuid assigns a GTID ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. mysqlslap runs in three stages: Create schema, table, and optionally any stored programs or data to use for the test. For ...Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing ...