mariadb/storage/innobase
Marko Mäkelä 8fb09426b9 MDEV-36759: Huge performance drop
In commit b6923420f3 (MDEV-29445)
some hash tables were accidentally created with the minimum size
(101 entries) instead of correctly deriving the size from the
initial innodb_buffer_pool_size. This led to very long hash bucket
chains, which are very slow to traverse.

ut_find_prime(): Assert that the size is nonzero in order to catch
this type of regression in the future.

innodb_init_params(): Do not bother reading buf_pool.curr_size()
when it is known to be 0,

srv_start(): Correctly initialize srv_lock_table_size to 5 times
buf_pool.curr_size(), that is, the buffer pool size in pages,
between invoking buf_pool.create() and lock_sys.create().

btr_search_enable(), dict_sys_t::create(), dict_sys_t::resize():
Correctly refer to buf_pool.curr_pool_size(), that is,
innodb_buffer_pool_size in bytes, when calculating the hash table size.
In MDEV-29445 the expressions buf_pool_get_curr_size() were
accidentally replaced with buf_pool.curr_size().
2025-05-13 12:27:50 +03:00
..
btr MDEV-36759: Huge performance drop 2025-05-13 12:27:50 +03:00
buf MDEV-36781: Assertion i < BUF_BUDDY_SIZES failed in buf_buddy_shrink() 2025-05-13 12:27:46 +03:00
data Merge 10.7 into 10.8 2022-11-01 08:50:28 +02:00
dict MDEV-36759: Huge performance drop 2025-05-13 12:27:50 +03:00
eval MDEV-26938 Support descending indexes internally in InnoDB 2022-01-26 18:43:05 +01:00
fil Merge branch '10.6' into 10.11 2025-01-30 11:55:13 +01:00
fsp MDEV-35000 preparation: Clean up dict_table_t::stat 2025-02-28 08:55:16 +02:00
fts MDEV-35000: dict_table_close() breaks STATS_AUTO_RECALC 2025-02-28 09:00:16 +02:00
fut MDEV-32175: Reduce page_align(), page_offset() calls 2024-11-21 11:01:30 +02:00
gis Merge 10.5 into 10.6 2025-03-26 17:09:57 +02:00
ha MDEV-35472 Server crash in ha_storage_put_memlim upon reading from INNODB_LOCKS 2024-11-25 10:31:57 +02:00
handler MDEV-36759: Huge performance drop 2025-05-13 12:27:50 +03:00
ibuf MDEV-29445: Reimplement SET GLOBAL innodb_buffer_pool_size 2025-03-26 17:05:44 +02:00
include MDEV-36781: Assertion i < BUF_BUDDY_SIZES failed in buf_buddy_shrink() 2025-05-13 12:27:46 +03:00
lock MDEV-36639 innodb_snapshot_isolation=1 gives error for not committed row changes 2025-04-22 20:41:43 +03:00
log Merge 10.6 into 10.11 2025-04-23 08:53:53 +03:00
mem Cleanup: Remove duplicated code 2024-11-29 14:16:34 +02:00
mtr MDEV-36760 log_t::append_prepare_wait(): Bogus assertion on write_lsn 2025-05-13 12:27:41 +03:00
mysql-test/storage_engine Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
os MDEV-35983 Avoid install failures by using retry logic for file operations 2025-04-15 18:58:32 +02:00
page Merge 10.6 into 10.11 2024-11-29 13:43:17 +02:00
pars Merge 10.6 into 10.11 2025-02-25 10:23:24 +02:00
que MDEV-24035 Failing assertion: UT_LIST_GET_LEN(lock.trx_locks) == 0 causing disruption and replication failure 2024-12-12 18:02:00 +02:00
read MDEV-34515: Contention between purge and workload 2024-08-26 12:23:06 +03:00
rem Merge 10.6 into 10.11 2024-03-28 09:16:57 +02:00
row MDEV-36504 Memory leak after CREATE TABLE..SELECT 2025-04-17 12:04:09 +05:30
srv MDEV-36759: Huge performance drop 2025-05-13 12:27:50 +03:00
sync Merge 10.6 into 10.11 2024-10-03 10:55:08 +03:00
trx Merge branch '10.6' into 10.11 2025-04-21 11:23:11 +02:00
unittest MDEV-35587 unit.innodb_sync leaks memory on mac 2024-12-12 10:27:36 +11:00
ut MDEV-36759: Huge performance drop 2025-05-13 12:27:50 +03:00
.clang-format-old switch off storage/innobase/.clang-format: InnoDB uses a common formatting style for all new code 2021-03-17 11:01:15 +03:00
CMakeLists.txt MDEV-35000: dict_table_close() breaks STATS_AUTO_RECALC 2025-02-28 09:00:16 +02:00
COPYING.Google
COPYING.Percona