Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
On dedicated servers, up to 80% of physical memory is often assigned to the buffer pool. Ideally, you set the size of the buffer pool to as large a value as practical, leaving enough memory for other processes on the server to run without excessive ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Because the statistics in the INNODB_CMP_PER_INDEX table are expensive to collect, you must enable the configuration option innodb_cmp_per_index_enabled before querying that table, and you might restrict such testing to a development server or a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. A server restart might fail if the data file is not found at the expected path. There are different reasons for creating ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL operation. You might also use this clause if the server is supposed to be idle, to avoid unexpected table ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
In MySQL 8.4, the DELAYED keyword is accepted but ignored by the server. SELECT statements are handled the same way as multiple-row inserts because the server does not examine the result set from the SELECT to see whether it returns a single row. If ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-restructuring.html
For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value that differs from the component's current value, the server destroys the cache's ... A key cache can be restructured at any time by updating its parameter ...
https://dev.mysql.com/doc/refman/8.4/en/large-page-support.html
Check any configuration files such as my.cnf used by the server, and make sure that innodb_buffer_pool_chunk_size is set larger than the huge page size. Large page support in the MySQL server is disabled by default. You can also do so by adding the ... Some hardware and operating system architectures support memory pages greater than the default (usually ...
https://dev.mysql.com/doc/refman/8.4/en/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. (On Windows, the debugging server is named mysqld-debug rather than mysqld.) Start the mysqld server with a trace log in ...To do ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
When two or more threads executing in the server need to access the same resource, the threads compete against each other. After adding the performance-schema-instrument rules to your configuration file, restart the server. A mutex is a ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
When data from any table index block must be accessed, the server first checks whether it is available in some block buffer of the key cache. If it is, the server accesses data in the key cache rather than on disk. Otherwise, the server chooses a ...