Search Results
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
At connect time, proxy_user must represent a valid externally authenticated MySQL user, and proxied_user must represent a valid locally authenticated user. The second user is a “proxied user” (a user whose identity and privileges can be assumed ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. This clause always begins with PARTITION BY, ...Simply using a partition_options clause with ALTER TABLE on a partitioned table repartitions the table according to the partitioning scheme defined by the ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
Logged information is buffered during the startup sequence while the InnoDB storage engine is initialized, which is sometimes prolonged by operations such as recovery and data dictionary upgrade that occur during the InnoDB startup sequence. The ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
The default password policy implemented by validate_password requires that passwords contain at least one uppercase letter, one lowercase letter, one digit, and one special character, and that the total password length is at least 8 characters. Be ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
During a restore, the information in the file is used to delete the tables from the full backup that has been removed between the time of the full backup and the time of the incremental backup. Their inclusion saves the time and resources required ...In the case of a single-file backup, unpack the file into a backup directory structure using the extract or the image-to-backup-dir command to view the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
MySQL also supports ', 'a wide range of data types, including integers, floating-point numbers, dates, and strings. The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin ...If ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. It can hold multiple tables, and supports all table row formats. One data file is created and added to the tablespace using this statement. This means that each Disk Data object ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory is required in the buffer pool, and less I/O is required to write out updated values. The row format of a table determines how its rows are ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-table-export.html
Like the MySQL server with the SELECT...INTO OUTFILE statement, MySQL Shell does not validate the field- and line-handling options that you specify. About the Utility Requirements and Restrictions Running the Utility Options Options for OCI Cloud ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
It is important to minimize the number of times B-tree nodes are split, as well as to minimize the need to uncompress and recompress their content. Updates and inserts of small records may be written to this modification log without requiring the ...