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/mysql-tips.html
(The menu item mentioned previously sets the font and character set as just described.) To avoid those steps each time you run mysql, you can create a shortcut that invokes mysql.exe. For example, longer text values that include newlines often are ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
Per second averages provided in InnoDB Standard Monitor output are based on the elapsed time since InnoDB Standard Monitor output was last printed. youngs/s The per second average of accesses to old pages in the buffer pool LRU list that have ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such as Got error ... Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and Elements”. For lists of server-side, ...The GET DIAGNOSTICS statement may be used to inspect the diagnostic information in the diagnostics ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
On the right side of the IN() predicate, row constructors contain only runtime constants, which are either literals or local column references that are bound to constants during execution. The interval on the second line uses only one key part. The ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Performing point-in-time recovery of NDB Cluster ...At some later point, prior to restoring the cluster, make a backup of the mysql.ndb_binlog_index ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
MaxNoOfConcurrentTransactions: Maximum number of transactions executing concurrently on this data node, total number of transactions that can be executed concurrently is this value times number of data nodes in cluster. TransactionInactiveTimeout: ...LcpScanProgressTimeout: Maximum time that local checkpoint fragment scan can be stalled before node is shut down to ensure systemwide LCP ... The listings in this section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-error-reporter.html
ndb_error_reporter also accepts the options listed here: --connection-timeout=timeout Command-Line Format --connection-timeout=# Type Integer Default Value 0 Wait this many seconds when trying to connect to nodes before timing out. The archive is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html
By default, source and replica servers assume that they are in the same time zone. If you are replicating between servers in different time zones, the time zone must be set on both source and replica. Otherwise, statements depending on the local ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
The DEFINER clause specifies the MySQL account to be used when checking access privileges at event execution time. Within an event body, the CURRENT_USER function returns the account used to check privileges at event execution time, which is the ...