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/mysql-cluster-limitations-transactions.html
When a row referenced by a unique index in the user-created NDB table is updated, the hidden index table is subject to an exclusive lock by the transaction in which the update is performed. This means that any read operation on the same ...See ...To ... A number of limitations exist in NDB Cluster with regard to the handling of ...
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/optimizing-innodb-diskio.html
(It is necessary to use the mount option rather than setting innodb_flush_method if you want direct I/O for the log files.) Users of the Veritas file system VxFS should use the convosync=direct mount option. If database write performance is an ...If ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-show-tables.html
--type, -t Can be used to restrict the output to one type of object, specified by an integer type code as shown here: 1: System table 2: User-created table 3: Unique hash index Any other value causes all NDB database objects to be listed (the ...By ... ndb_show_tables displays a list of all NDB database objects in the ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
The user has a column-level privilege for any of the involved tables. Queries that use different databases, different protocol versions, or different default character sets are considered different queries and are cached separately. It refers to ...
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/thread-pool-operation.html
While a thread executes a statement from a user connection, Performance Schema instrumentation accounts thread activity to the user connection. For guidelines on setting this variable, see Section 5.5.3.4, “Thread Pool Tuning”. The default time ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an error occurs). SET autocommit disables or enables the default autocommit mode for the current session. To disable ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
[WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], ...] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [PROCEDURE procedure_name(argument_list)] [into_option] [FOR UPDATE | LOCK IN SHARE MODE] ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. Note There are easier alternatives to generating the files required for SSL than the procedure described here: Let ...The first two examples are intended for use on Unix and both use the openssl command that is part of ...