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/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-performance-spin_lock_polling.html
On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or rw-lock becomes available during this period, the thread can continue ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. mysqld_safe tries to use the sleep and date system utilities to determine how many times per second it has ...A ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
OpenSSL also imposes a maximum key length of 10,000 bits and 16,384 bits for DSA and RSA keys, respectively, for create_asymmetric_priv_key(), and a maximum key length of 10,000 bits for create_dh_parameters(). If those maximum values are too high, ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
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/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. Command Syntax Meaning default Reset every optimization to its default value opt_name=default Set the named optimization to its default value opt_name=off Disable the named ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
Notes: The upgrade operation just described is safe to execute at any time because it makes the mysql_native_password plugin explicit only for accounts that already use it implicitly. To upgrade these accounts to use mysql_native_password ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
OLDEST_QUEUED How long in milliseconds the oldest queued statement has been waiting for execution. There is at most one thread ready to start executing if the active threads become stalled or blocked. There can be a maximum of four connection ...
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/sys-io-global-by-wait-by-bytes.html
max_latency The maximum single wait time of timed occurrences of the I/O event. These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences ...By default, rows are sorted by descending total I/O (bytes read and ...