PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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/refman/8.0/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
How about age? That might be of interest, but it is not a good thing to store in a database. Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
As the database operates, pages in the buffer pool that are not accessed “age” by moving toward the tail of the list. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-fulltext_index-tables.html
Before querying any of them, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). YourSQL','In the following database ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
The INDEX_ID is an identifier for the index that is unique across all databases in an instance. Example 17.4 Joining InnoDB INFORMATION_SCHEMA Schema Object Tables This example demonstrates joining three InnoDB INFORMATION_SCHEMA schema object ...