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/create-table-select.html
The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax error. If any errors occur while copying the data to the table, it is automatically dropped and not created. If ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
When a memcached operation inserts, updates, or deletes data in the underlying InnoDB table, the change might be committed to the InnoDB table instantly (if daemon_memcached_w_batch_size=1) or some time later (if the daemon_memcached_w_batch_size ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
With modern disks, the mean time for this is usually lower than 10ms, so we can in theory do about 100 seeks a second. As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 25.4.1, “Performance Schema Event Timing”. For example, the events_transactions_history and events_transactions_history_long tables are ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. The event scheduler thread does not run, is not shown in the output of SHOW PROCESSLIST, and no scheduled events ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...The exception to this rule is that the query sees the changes made by earlier statements within the same ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
COLUMN_KEY Whether the column is indexed: If COLUMN_KEY is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, nonunique index. on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
You should now be able to invoke any MySQL executable program by typing its name at the DOS prompt from any directory on the system, without having to supply the path. If mysqld does not start, check the error log to see whether the server wrote any ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_hosts_lost The number of times a row could ...Performance_schema_digest_lost The number of digest instances that could not be instrumented in the events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
A warning is added to the SHOW WARNINGS table each time such a statement is executed. Type binlog_format SLC RLC Error / Warning Logged as * * No No Error: Cannot execute statement: Binary logging is impossible since at least one engine is involved ...If a statement is logged by row and the session that executed the statement has any temporary tables, logging by row is used for all subsequent statements (except for those accessing temporary tables) until all temporary tables in use by that session are ...