New answers tagged

1

If you have access to the Aria engine or another non-transactional engine, then yes. Very short proof of concept, tested on MariaDB 10.5.4: CREATE TABLE test_aria_engine ( a int, b varchar(1000) ) ENGINE=Aria DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 TRANSACTIONAL=1 TABLE_CHECKSUM=1 COMMENT='test-aria_engine with transactional on 1' The transactional in Aria is ...


1

Rate Per Second = RPS Suggestions to consider for your my.ini [mysqld] section max_connections=750 # from 1500 to conserve RAM and have 50% more capacity than your expected 500 users thread_cache_size=100 # from 9 to minimize threads_created overhead innodb_io_capacity=1900 # from 200 to enable more of your SSD IOPS capacity read_rnd_buffer_size=64K # ...


0

There is about 8 bytes of overhead per index entry. So, if the key is typically 6 bytes, and the key_buffer block size is 1KB, and the BTree is 69% full: 1024 * .69 / (8+6) says there will be about 50 rows. So, 3 levels of BTree can handle up to 50^3 = 125K rows. The .69 comes from assuming lots of random inserts -- leading to each block oscillating ...


Top 50 recent answers are included