PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. For date and time types other than TIMESTAMP, the default is the appropriate “zero” value for the type. This is also true for TIMESTAMP if the ... Data ...
https://dev.mysql.com/doc/refman/9.7/en/disk-issues.html
This makes both the seek and read times better, assuming that the disk is not used for other purposes as well. RAID N can be a problem if you have many writes, due to the time required to update the parity bits. You can also set the parameters for ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...
https://dev.mysql.com/doc/refman/9.7/en/expressions.html
For the - operator, INTERVAL expr unit is permitted only on the right side, because it makes no sense to subtract a date or datetime value from an interval. This is analogous to the way that MySQL interprets TIME values as representing elapsed time ... This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
The firewall database can be the mysql system database (the default) or one determined at install time (see Installing the MySQL Enterprise Firewall Component). System variables and status variables specific to the firewall plugin enable firewall ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-plugin.html
System variables and status variables specific to the firewall plugin enable firewall configuration and provide runtime operational information, respectively. 8.4.9.1.2 Installing or Uninstalling the MySQL Enterprise Firewall Plugin MySQL Enterprise ... This section contains information about the MySQL Enterprise Firewall ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-boolean.html
| +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which + stands for AND - stands for NOT [no operator] implies OR Boolean ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-fine-tuning.html
Most full-text variables described in this section must be set at server startup time. The innodb_ft_num_word_optimize option defines the number of words that are optimized each time OPTIMIZE TABLE is run. The default setting is 2000, which means ...
https://dev.mysql.com/doc/refman/9.7/en/gone-away.html
The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. You can change the time limit by setting the wait_timeout variable when you start mysqld. You got a timeout from the TCP/IP ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-network-partitioning.html
For example, in the above scenario of 5 servers where 3 leave at once, if the 3 leaving servers warn the group that they are leaving, one by one, then the membership is able to adjust itself from 5 to 2, and at the same time, securing quorum while ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-trx-table.html
TRX_WAIT_STARTED The time when the transaction started waiting on the lock, if TRX_STATE is LOCK WAIT; otherwise NULL. During times of contention, it counts down to zero, and statements release the latch immediately after each row lookup. The ...