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/innodb-information-schema-examples.html
The tables that contain information about InnoDB transactions and data locks enable you to determine which transaction is waiting for another, and which resource is being requested. (For descriptions of these tables, see Section 14.16.2, “InnoDB ... Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). This query ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-source.html
If you compile MySQL with clustering support, and perform the default installation (using make install as the system root user), mysqld is placed in /usr/local/mysql/bin. This section provides information about compiling NDB Cluster on Linux and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-source.html
Oracle provides precompiled NDB Cluster binaries for Windows which should be adequate for most users. However, if you wish, it is also possible to compile NDB Cluster for Windows from source code. The procedure for doing this is almost identical to ...However, there are two major differences: Building NDB Cluster requires using the NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat.html
The cpustat table provides per-thread CPU statistics gathered each second, for each thread running in the NDB kernel.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-locks.html
This may be useful for correlating locking patterns with specific MySQL user sessions, queries, or use cases. The server_locks table is similar in structure to the cluster_locks table, and provides a subset of the information found in the latter ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-threadstat.html
The threadstat table provides a rough snapshot of statistics for threads running in the NDB kernel. Since this table contains counts taken at a given point in time, for best results it is necessary to query this table periodically and store the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-telemetry.html
It enables users to instrument their applications in order to export observability data: traces, metrics and logs, enabling increased granularity of debugging and testing. The MySQL telemetry component is based on the OpenTelemetry (OTel) project, ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...
https://dev.mysql.com/doc/refman/5.7/en/reserved-accounts.html
During data directory initialization, MySQL creates user accounts that should be considered reserved: 'root'@'localhost: Used for administrative purposes. This account is locked so that it cannot be used for client connections. This account is ...