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/views.html
Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
It is not possible under normal circumstances in NDB Cluster to create an NDB Cluster table using any partitioning type other than [LINEAR] KEY, and attempting to do so fails with an error. The maximum number of partitions that can be defined for an ... The following limitations apply to the use of storage engines with user-defined partitioning of ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). --recover, -r Command-Line Format --recover Do a repair that can fix ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication.html
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers at ... This chapter explains MySQL Group Replication and how to install, configure and monitor ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-close.html
The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files is incremented. (The table may still be okay because MySQL always issues writes for everything between each statement.) A table was ... Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed ...
https://dev.mysql.com/doc/refman/5.7/en/using-gdb-on-mysqld.html
In this case, you can only have one thread active at a time. It is very hard to debug MySQL under gdb if you do a lot of new connections the whole time as gdb does not free the memory for old threads. On most systems you can also start mysqld from ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
We use the phrase “the SQL standard” to mean the current version of the SQL Standard at any time. It is the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
If the replica stops before the SQL thread has executed all the fetched statements, the I/O thread has at least fetched everything so that a safe copy of the transactions is stored locally in the replica's relay logs, ready for execution the next ...
https://dev.mysql.com/doc/refman/5.7/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'mysql_firewall_mode'; +---------------------+-------+ | Variable_name | Value | +---------------------+-------+ | mysql_firewall_mode | ON | ...