Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
Successful use of LOCAL load operations within mysqlimport also requires that the server permits local loading; see Section 8.1.6, “Security Considerations for LOAD DATA LOCAL” --lock-tables, -l Command-Line Format --lock-tables Lock all tables ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
performance_schema_max_metadata_locks Command-Line Format --performance-schema-max-metadata-locks=# System Variable performance_schema_max_metadata_locks Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value -1 (signifies ...The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
Employing this method with a table using a storage engine that has complex caching or logging algorithms requires extra steps to produce a perfect “point in time” snapshot: the initial copy command could leave out cache information and logging ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
A role when created is locked, has no password, and is assigned the default authentication plugin. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) While locked, a role ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-save.html
To prevent other simultaneous calls to save the configuration, ps_setup_save() acquires an advisory lock named sys.ps_setup_save by calling the GET_LOCK() function. ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
Each block of data is 1024 InnoDB data pages, typically totalling 16MB. --no-locking Disables all locking during backup (see The Backup Process for details). --lock-wait-timeout Command-Line Format --lock-wait-timeout=S Type Numeric Default Value 60 ... These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
BatchSizePerLocalScan: Used to calculate number of lock records for scan with hold lock. LockPagesInMainMemory: 0=disable locking, 1=lock after memory allocation, 2=lock before memory allocation. MaxLCPStartDelay: Time in seconds that LCP polls for ... ApiFailureHandlingTimeout: Maximum time for API node failure handling before ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/services-for-plugins.html
locking_service: A service that implements locks with three attributes: Lock namespace, lock name, and lock mode. This locking interface is accessible at two levels: 1) At the SQL level, as a set of loadable functions that each map onto calls to the ... MySQL server plugins have access to server “plugin services.” The plugin services interface exposes server functionality that plugins can ...
https://dev.mysql.com/doc/internals/en/mysys-directory.html
There are 125 *.c programs in this directory: array.c --- Dynamic array handling charset.c --- Using dynamic character sets, set default character set, ... For example, the main functions in my_getwd.c are described thus: "int my_getwd _A((string ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...