Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins.html
Authentication plugins enable the use of authentication methods other than the built-in method of passwords stored in the mysql.user system table. An authentication plugin can be written for the server side or the client side. Server-side plugins ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
The component_keyring_file keyring component stores keyring data in a file local to the server host. Security standards such as PCI, FIPS, and others require use of key management systems to secure, manage, and protect encryption keys in key vaults ...Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components are not intended as a regulatory compliance ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
The mysql-files directory provides a convenient location to use as the value for the secure_file_priv system variable, which limits import and export operations to a specific directory. MySQL compressed tar file binary distributions have names of ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
For REPAIR TABLE, the same principle applies, but because the repair is done by the server, you set server system variables instead of myisamchk variables. For example: SET @old_myisam_sort_buffer_size = @@GLOBAL.myisam_max_sort_file_size; SET ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
MySQL stores the sql_mode system variable setting in effect when a routine is created or altered, and always executes the routine with this setting in force, regardless of the current server SQL mode when the routine begins executing. The exception ...This behavior can be changed by disabling the automatic_sp_privileges system ...See Section 11.2.5, “Function Name Parsing and Resolution”, for the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
--connect-delay=# Command-Line Format --connect-delay=# Deprecated Yes Type Numeric Default Value 5 Minimum Value 0 Maximum Value 3600 Determines the time to wait between attempts to contact a management server when starting (the number of attempts ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-airportdb-quickstart.html
The MySQL HeatWave airportdb Quickstart shows how to import data into the DB System using the MySQL Shell Dump Load utility, loading data into MySQL HeatWave Cluster using Auto Parallel Load, and running queries. This quickstart contains the ...For ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
If you want transaction consistency guaranteed for every transaction in the group, you can do this using the group_replication_consistency system variable. You can also set the system variable for individual sessions to protect particularly ...If a ... In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-details.html
MySQL HeatWave node See Table 4-5 Table 4-4 DB System Details Field Description Name The name of the DB System that the MySQL HeatWave Cluster is associated with State The state of the DB System that the MySQL HeatWave Cluster is associated with.
https://dev.mysql.com/doc/refman/8.4/en/faqs-thread-pool.html
The Thread Pool plugin increases server performance by efficiently managing statement execution threads for large numbers of client connections, especially on modern multi-CPU/Core systems. When should I use the Thread Pool? There are a few rules of ...The default thread-handling model in MySQL Server executes statements using one thread per client ...