PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients. For a complete list of options, run this command: mysqld --verbose --help MySQL Server also has a set of ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-turning-off.html
Oracle recommends InnoDB as the preferred storage engine for typical database applications, from single-user wikis and blogs running on a local system, to high-end applications pushing the limits of performance. In MySQL 5.7, InnoDB is the default ...The --skip-innodb option is deprecated and has no effect, and its use results in a ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. The creator of a routine is the account used to execute the ...
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 ...A comparison between a nonbinary string and binary string is treated as a comparison of binary ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client requests. The same restrictions apply to internal temporary tables created to hold the result set ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
When you use KILL, a thread-specific kill flag is set for the thread. Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID ... KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
If you specify a value for innodb_log_write_ahead_size that is larger than the innodb_page_size value, the innodb_log_write_ahead_size setting is truncated to the innodb_page_size value. Setting the value too high may have a slight impact on fsync ... Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-restrictions.html
CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions, procedures, functions, and triggers when using GTIDs (that is, when the enforce_gtid_consistency system variable is set to ON). For information about ...This section provides information about restrictions on and limitations of replication with ... Because GTID-based replication is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) ...A ...Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read ...