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/innodb-change-buffer.html
You can set the innodb_change_buffering variable in the MySQL option file (my.cnf or my.ini) or change it dynamically with the SET GLOBAL statement, which requires privileges sufficient to set global system variables. The change buffer is a special ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
Changing the setting at runtime requires privileges sufficient to set global system variables. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
Changing the value at runtime requires privileges sufficient to set global system variables. Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
You can set the value of this parameter in the MySQL configuration file, or change it dynamically with the SET GLOBAL statement, which requires privileges sufficient to set global system variables. A read-ahead request is an I/O request to prefetch ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”.
https://dev.mysql.com/doc/refman/5.7/en/kill.html
The ability to see which threads are available to be killed depends on the PROCESS privilege: Without PROCESS, you can see only your own threads. The ability to kill threads and statements depends on the SUPER privilege: Without SUPER, you can kill ... KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
The default value is 'en_US' regardless of your system's locale setting, but you can set the value at server startup, or set the GLOBAL value at runtime if you have privileges sufficient to set global system variables; see Section 5.1.8.1, “System ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-prefpane.html
You may be prompted for the username and password of a user with administrator privileges to start the MySQL server. You may be prompted for the username and password of a user with administrator privileges to stop the MySQL server. The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation.html
The user you use to perform the installation must have administrator privileges. You do not need administrator privileges using this method, as you can install the MySQL server anywhere using this method. For a list of macOS versions that the MySQL ...