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/innodb-deadlock-detection.html
For techniques to organize database operations to avoid deadlocks, see Section 14.7.5, “Deadlocks in InnoDB”. At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ...Built-In Function Name Parsing Function Name Resolution Built-In Function Name Parsing The parser uses default rules for parsing names of built-in ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
The innodb_io_capacity parameter sets an upper limit on the I/O activity performed by InnoDB background tasks such as merging data from the change buffer. How much space does InnoDB use for the change buffer? A.16.5. Where can I find additional ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
The information in these tables is system-wide: it summarizes the compression statistics across all compressed tables in your database. Based on the information in the INNODB_CMP and INNODB_CMP_PER_INDEX tables and overall application performance ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Parameters in_db VARCHAR(64): The name of the database in which to check for table existance. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
For example, for the MyISAM tables in the mysql database, there must be no administrative changes to MySQL accounts during the backup. The MySQL binary logs are important for recovery because they form the set of incremental backups. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
If the variable is set to ALWAYS (or 2), concurrent inserts at the end of the table are permitted even for tables that have deleted rows. If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays. For example, if you store death date in the database, you can easily calculate how old a pet ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
When binary log events were written in row-based format and you want to read or recover from a replication or database failure you can use this command to read contents of the binary log. For other scenarios, setting slave_exec_mode to STRICT is ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
Invalid values for ENUM and SET columns are handled as described in Section 1.6.3.4, “ENUM and SET Constraints”. You can select stricter treatment of input values by using the STRICT_TRANS_TABLES or STRICT_ALL_TABLES SQL modes: SET sql_mode = ...