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/replication-options-binary-log.html
Important Before enabling this variable, you must make certain that there are no dependencies between transactional and nontransactional tables; an example of such a dependency would be the statement INSERT INTO myisam_table SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege for the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
A view cannot be referenced by a user who does not have the appropriate privilege for it (SELECT to select from it, INSERT to insert into it, and so forth). Stored programs (procedures, functions, triggers, and events) and views are defined prior ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
As an alternative to explicitly escaping special characters, many MySQL APIs provide a placeholder capability that enables you to insert special markers into a statement string, and then bind data values to them when you issue the statement. A ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
A subquery's outer statement can be any one of: SELECT, INSERT, UPDATE, DELETE, SET, or DO. This applies to statements such as DELETE, INSERT, REPLACE, UPDATE, and (because subqueries can be used in the SET clause) LOAD DATA. All subquery forms and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-index-statistics.html
insert_latency The total wait time of timed inserts into the index. The schema_index_statistics and x$schema_index_statistics views have these columns: table_schema The schema that contains the table. select_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics-with-buffer.html
insert_latency The total wait time of timed insert I/O events for the table. These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics.html
insert_latency The total wait time of timed insert I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.