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/memory-storage-engine.html
This limits scalability when load increases, particularly for statement mixes that include writes. To enforce different size limits for MEMORY tables, change the value of this variable. You can set the size for individual tables as described later ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
What character set should the server translate statements to after receiving them? To determine this, the server uses the character_set_connection and collation_connection system variables: The server converts statements sent by the client from ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
If a statement raises multiple conditions, this part of the diagnostics area has a condition area for each one. If a statement raises no conditions, this part of the diagnostics area is empty. For a statement that produces three conditions, the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
This issue does not occur for queries that use index or table scans, even against NDB tables having BLOB or TEXT columns. To avoid modification of the index during this double-read operation, the row found in the hidden index table is locked. This ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(See also Section 16.4.1.8, “Replication of CURRENT_USER()”.) This is also true for VERSION() and RAND(). This means that the value as returned by the call to this function on the source is replicated to the replica. For this reason, if you ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
If this is true of the statement, we refer to the statement as safe; otherwise, we refer to it as unsafe. However, certain nondeterministic functions are not considered unsafe (see Nondeterministic functions not considered unsafe, later in this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
This section describes the impact of an unexpected halt of a replica during replication, and how to configure a replica for the best chance of recovery to continue replication. In older MySQL Server versions, this repository could only be created as ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
It starts by pushing a diagnostics area to the top of the stack, which now looks like this: DA 1. ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. SET is ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/5.7/en/preface.html
This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 5.7 and ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
Note This must be the first option on the command line if it is used, except that if the server is started with the --defaults-file and --install (or --install-manual) options, --install (or --install-manual) must be first. For this reason, do not ...The best way to ensure this is to list them in an option ... When you start the mysqld server, you can specify program options using any of the methods ...