Search Results
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
MySQL allocates buffers and caches to improve performance of database operations. This memory is not released by the corresponding REVOKE, DROP USER, DROP SERVER, and UNINSTALL PLUGIN statements, so for a server that executes many instances of the ...The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. For example, a second session blocks if it attempts any of these operations: DROP TABLE t; ALTER TABLE t ...; DROP TABLE nt; ALTER TABLE nt ...Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and locks acquired with the locking service described in Section 7.6.9.1, “The Locking ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
The following characteristics are relevant for this purpose: READ ONLY READ WRITE ISOLATION LEVEL WITH CONSISTENT SNAPSHOT Available Session State Trackers To support the session-tracking activities, notification is available for these types of ...A ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
mysql schema tables fall into two broad categories: Data dictionary tables, which store database object metadata. Placing the host name and user name together means that index lookup can be used, which improves performance for CREATE USER, DROP ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If one client session had a uncommitted transaction that caused a DROP TABLE statement in another client session to be blocked, a third client session hung when trying to issue a USE DATABASE statement. (Bug #37570206) Audit Log Notes ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
int mysql_stmt_execute(MYSQL_STMT *stmt) Description mysql_stmt_execute() executes the prepared query associated with the statement handler. The currently bound parameter marker values are sent to server during this call, and the server replaces ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
If the parser plugin is dropped, any index associated with it becomes unusable. Any attempt to use a table for which a plugin is not available results in an error, although DROP TABLE is still possible. INFORMATION_SCHEMA Plugins INFORMATION_SCHEMA ... The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation and strength checking Protocol tracing Query rewriting Secure keyring storage and retrieval The following sections provide an overview of these plugin ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
ndbinfo Information Database: At table create and drop time, access of ndbinfo tables such as operations_per_fragment and memory_per_fragment sometimes examined data which was not valid. To fix this, during scans of these ndbinfo tables, we ignore ... MySQL NDB Cluster 8.4.4 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in version 8.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-metadata.html
It does so by querying the metadata database and live state information from MySQL's performance schema. Note Dropping cluster metadata using MySQL Shell, such as dba.dropMetadataSchema(), causes Router to drop all current connections and forbid new ... MySQL Router works by sitting in between applications and MySQL ...