New answers tagged myisam
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
