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/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
This message indicates an issue that requires DBA action: 2018-10-02T03:20:39.410387Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. This section discusses how error messages originate within MySQL and the elements they contain.
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
The InnoDB storage engine offers full ACID transactions with row-level locking, multi-versioning, nonlocking repeatable reads, and all four SQL standard isolation levels. Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-thread-pool.html
If this variable consistently exceeds a region where the server won't operate optimally (usually going beyond 40 for InnoDB workloads), the Thread Pool should be beneficial, especially in extreme parallel overload situations. If you are using the ...
https://dev.mysql.com/doc/refman/5.7/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. The sample collation is like latin1_swedish_ci but treats the '-' character as a letter rather than as a punctuation character so ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
InnoDB might escalate to a range-key lock rather than taking a single row lock for one matching row. A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
Storage Engines Replication Framework Group Replication Settings Storage Engines For Group Replication, data must be stored in the InnoDB transactional storage engine (for details of why, see Section 17.3.1, “Group Replication Requirements”).
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
The CREATE TABLE statement in InnoDB is processed as a single transaction. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
This may affect some queries if you change a MyISAM or InnoDB table to a hash-indexed MEMORY table. Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...