PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. This is NULL for an internal thread, or for a user session that failed to authenticate. To set the table size explicitly, set the ... The accounts table contains ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/innodb-init-startup-configuration.html
This section provides information about specifying InnoDB settings in a configuration file, viewing InnoDB initialization information, and important storage considerations. Note InnoDB does not open all user tables and associated data files at ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Post-filtering is performed on a per-user basis because individual users select which of the available events are of interest. Reasons to use ...The ... Events are processed in a producer/consumer fashion: Instrumented code is the source for events and produces events to be ...| wait/synch/mutex/sql/LOCK_global_read_lock | YES | YES | | ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
To detect this condition, you can set up a handler for it or for a NOT FOUND condition. statement can be a simple statement such as SET var_name = value, or a compound statement written using BEGIN and END (see Section 13.6.1, “BEGIN ... It can ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-collations.html
A given nonbinary character set can have several collations, each of which defines a particular comparison and sort order for the characters in the set. The binary collation differs from _bin collations in several respects, discussed in the ... This ...Binary strings are sequences of bytes and the numeric values of those bytes determine comparison and sort ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, REPAIR TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. You may be able to ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
The log table implementation has the following characteristics: In general, the primary purpose of log tables is to provide an interface for users to observe the runtime execution of the server, not to interfere with its runtime execution. For users ...Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system ...Log Control at Server Startup Log Control at Runtime Log Table Benefits and ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
To change the ranges for a subset of partitions defined using VALUES LESS THAN or the value lists for a subset of partitions defined using VALUES IN. Employing MAX_ROWS to force the number of table partitions is deprecated in NDB 7.5.4 and later; ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
InnoDB performs row-level locking in such a way that when it searches or scans a table index, it sets shared or exclusive locks on the index records it encounters. A SPATIAL index contains minimum bounding rectangle (MBR) values, so InnoDB enforces ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...