PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
To turn on all restrictions, you can simply use TRADITIONAL mode, which includes both strict mode values and ERROR_FOR_DIVISION_BY_ZERO: SET sql_mode='TRADITIONAL'; If a number is inserted into an exact type column (DECIMAL or integer), it is ...For ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ...(Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or CURRENT_USER is ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
(You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that has a size of 128KB, with the size of block buffers for caching table index blocks set to 2048 bytes. For ...A ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
If you have set a password for the root account, deleted the anonymous account, or created a new user account, then to connect to the MySQL server you must use the appropriate -u and -p options with the commands shown previously. For more ...(Be ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
Communication latency between these processes can directly affect the observed performance and latency of user queries. When setting timeout values such as HeartbeatIntervalDbDb and HeartbeatIntervalDbApi for NDB Cluster, care must be taken care to ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-networking-issues.html
Also see Section 21.4.1, “Quick Test Setup of NDB Cluster”, for configuration examples using HostName with API nodes. We show an example of an NDB Cluster setup using such a physically segregated network here: Figure 21.9 NDB Cluster with ...It ... In this section, we discuss basic network security issues as they relate to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-compared.html
Since both NDB and InnoDB can serve as transactional MySQL storage engines, users of MySQL Server sometimes become interested in NDB Cluster. See Section 21.2.6.3, “NDB and InnoDB Feature Usage Summary”, for a comparison of the relative ...While ... MySQL Server offers a number of choices in storage ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
USER_LOCK_WAITS The number of THD_WAIT_USER_LOCK waits for a special lock constructed by the user thread. QUERIES_QUEUED The number of statements received that were queued for execution. For InnoDB, this most likely means deteriorating performance ...The TP_THREAD_GROUP_STATS table has these columns: TP_GROUP_ID The thread group ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. statement_latency The total wait time of timed statements for the host.