https://dev.mysql.com/sql-mode.html
The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs can set the global SQL mode to match site server operating requirements, ...
https://dev.mysql.com/number-literals.html
In MySQL, types that are synonymous with FLOAT or DOUBLE are DOUBLE PRECISION and REAL. Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Numbers may be preceded by - or + to ...
https://dev.mysql.com/mysql-cluster-computer-definition.html
The [computer] section has no real significance other than serving as a way to avoid the need of defining host names for each node in the system. Id Table 22.7 This table provides type and value information for the Id computer configuration ...
https://dev.mysql.com/mysql-cluster-config-starting.html
NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...
https://dev.mysql.com/innodb-locking.html
The supremum is not a real index record, so, in effect, this next-key lock locks only the gap following the largest index value. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks ...
https://dev.mysql.com/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/faqs-replication.html
(This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW PROCESSLIST, the number of seconds displayed for the slave SQL thread is the number of seconds between the timestamp of the last replicated event and the real time ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/innodb-memcached-internals.html
If the number sent by a client is larger, the server considers it to be a real Unix time value rather than an offset from the current time. The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from ...
https://dev.mysql.com/replication-gtids-failover.html
Copying over binary logs to the target server in advance is usually faster than reading the entire transaction execution history from the master in real time. There are a number of techniques when using MySQL Replication with Global Transaction ...
https://dev.mysql.com/innodb-memcached-porting-mysql.html
A more descriptive name value might be used in a real-world application. Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces ...
