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/faqs-thread-pool.html
The Thread Pool then manages client connections within configurable thread groups, where they are prioritized and queued based on the nature of the work they were submitted to accomplish. If you are using the innodb_thread_concurrency to limit the ...What is the Thread Pool and what problem does it solve? ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
Grouping DML Operations with Transactions By default, connection to the MySQL server begins with autocommit mode enabled, which automatically commits every SQL statement as you execute it. If autocommit mode is enabled, each SQL statement forms a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
For example, it can be used with GROUP BY OBJECT_INSTANCE_BEGIN to see whether the load on 1,000 mutexes (that protect, say, 1,000 pages or blocks of data) is spread evenly or just hitting a few bottlenecks. The table stores one row per thread ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-global-by-current-bytes.html
These views summarize memory use, grouped by allocation type (that is, by event). By default, rows are sorted by descending amount of memory used. The memory_global_by_current_bytes and x$memory_global_by_current_bytes views have these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-avg-latency.html
These views summarize wait class average latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_avg_latency and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-latency.html
These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_latency and ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...