PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
The overhead of index creation is negligible compared to the cost of query execution without the index. If ref access would result in higher cost than some other access method, the optimizer creates no index and loses nothing. The optimizer handles ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. The client may display the error message so the user can take corrective measures, ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
We also know of users who use MySQL Server with 200,000 tables and about 5,000,000,000 rows. MySQL Connector/NET enables developers to easily create .NET applications that require secure, high-performance data connectivity with MySQL. This section ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
WAKE_THREAD_STALL_CHECKER The number of times the stall check thread decided to wake or create a thread to possibly handle some statements or take care of the waiter thread role. USER_LOCK_WAITS The number of THD_WAIT_USER_LOCK waits for a special ...The TP_THREAD_GROUP_STATS table has these columns: TP_GROUP_ID The thread group ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The TP_THREAD_STATE table has one row per thread created by the thread pool to handle connections. The TP_THREAD_STATE table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
$> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. If autocommit mode is enabled, each SQL statement forms a single transaction on ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
FOR UPDATE) in each transaction; create indexes on the columns used in SELECT ... To view the last deadlock in an InnoDB user transaction, use SHOW ENGINE INNODB STATUS. A deadlock is a situation in which multiple transactions are unable to proceed ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-purge-configuration.html
The reason that a long running transaction can cause the History list length to increase is that under a consistent read transaction isolation level such as REPEATABLE READ, a transaction must return the same result as when the read view for that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
The default setting is ibtmp1:12M:autoextend, which creates the ibtmp1 temporary tablespace data file in the data directory. If the MySQL server is started with --innodb-read-only but the data directory is still on writeable media, the root user can ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...