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/replace-utility.html
The replace utility program changes strings in place in files or on the standard input. Note The replace utility is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0. Invoke replace in one of the following ways: replace from to [from to] ... < file_name from represents a string to look for and to represents its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-api-statistics.html
On platforms without sufficient (nanosecond) time resolution, small changes in the value of the WaitNanosCount NDB API counter due to SQL statements that execute very quickly may not always be visible in the values of ...Table 21.61 NDB API ... A ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
As InnoDB evolves, data file formats that are not compatible with prior versions of InnoDB are sometimes required to support new features. To help manage compatibility in upgrade and downgrade situations, and systems that run different versions of ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
For both InnoDB and MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum AUTO_INCREMENT column value plus one. An exclusive metadata lock on the table may ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Committing hundreds of times a second puts a cap on performance (limited by the write speed of your storage device). Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
sql_kill_blocking_query The KILL statement to execute to kill the blocking statement. sql_kill_blocking_connection The KILL statement to execute to kill the session running the blocking statement. These views display which sessions are blocked ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-coordinator-table.html
LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent SQL/coordinator error occurred. replication_applier_status_by_coordinator Column SHOW SLAVE STATUS Column THREAD_ID None SERVICE_STATE Slave_SQL_Running ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA ...