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/sys-io-global-by-file-by-bytes.html
These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes views have these ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. The maximum index width for ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-show-tables.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
In the latter case, the error log should contain a reason indicating why the option is disabled. SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-checkpoints.html
Although in the past large log files could make crash recovery take excessive time, starting with MySQL 5.5, performance enhancements to crash recovery make it possible to use large log files with fast startup after a crash. Making your log files ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”. After completing the installation process, you can edit the default option file ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-send-buffers.html
This is a way to save memory when many nodes are in use, as long as the maximum amount of memory is never required by all transporters at the same time. To be backward-compatible with existing configurations, this parameter takes as its default ...
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
Once the user has been configured, use the CHANGE MASTER TO statement to configure the server to use the given credentials for the group_replication_recovery replication channel the next time it needs to recover its state from another member. Group ...