PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/thread-information.html
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 5 User: ...
https://dev.mysql.com/doc/refman/8.0/en/using-gdb-on-mysqld.html
It is very hard to debug MySQL under gdb if you do a lot of new connections the whole time as gdb does not free the memory for old threads. On most systems you can also start mysqld from gdb to get more information if mysqld crashes. With some ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
To disable myevent, use this ALTER EVENT statement: ALTER EVENT myevent DISABLE; The ON SCHEDULE clause may use expressions involving built-in MySQL functions and user variables to obtain any of the timestamp or interval values which it contains.
https://dev.mysql.com/doc/refman/8.0/en/channels-startup-options.html
In MySQL 8.0, the FILE setting is deprecated, and TABLE is the default, so the system variables can be omitted. From MySQL 8.0.23, they must be omitted because their use is deprecated from that release. The values set for the following startup ...
https://dev.mysql.com/doc/refman/8.0/en/charset-database.html
The CHARACTER SET and COLLATE clauses make it possible to create databases with different character sets and collations on the same MySQL server. Example: CREATE DATABASE db_name CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL chooses the ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-object-cache.html
Similar to other cache mechanisms used by MySQL, the dictionary object cache uses an LRU-based eviction strategy to evict least recently used objects from memory. Both caches store table definitions but serve different parts of the MySQL server. The ... The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk ...
https://dev.mysql.com/doc/refman/8.0/en/error-log.html
The error log contains a record of mysqld startup and shutdown times. This section discusses how to configure the MySQL server for logging of diagnostic messages to the error log. For example, if mysqld notices that a table needs to be ...For ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
For example, if you are running a statement in one session that is taking a long time to complete, using EXPLAIN FOR CONNECTION in another session may yield useful information about the cause of the delay. To obtain the execution plan for an ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only process that requires access to tables. If the server is run with external locking enabled, you can use myisamchk at any time for ... External locking is the use of file system locking to manage contention for MyISAM database tables by multiple ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
MySQL also determines when to evaluate functions based on types of arguments, whether the arguments are table columns or constant values. For example: SELECT * FROM t WHERE partial_key=5 AND some_column=RAND(); If the optimizer can use partial_key ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...