Hello,
We have a lot of small databases, about 7 thousand with about 300 tables in each of them. Open tables are limited to 100,000.
When mysql crashed innodb_dict_size was set to 4Gb.
BUFFER POOL AND MEMORY ---------------------- Total memory allocated 37632000000; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 1326803568 (581048824 + 745754744) Page hash 36316328 Dictionary cache 23604963972 (145264208 + 23459699764) File system 83536 (82672 + 864) Lock system 90822072 (90789784 + 32288) Recovery system 0 (0 + 0) Threads 408112 (406936 + 1176) Dictionary memory allocated 23459699764 Buffer pool size 2239999 Buffer pool size, bytes 36700143616 Free buffers 0 Database pages 2194481 Old database pages 810052 Modified db pages 866 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 20778188, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 20983317, created 3975656, written 43405370 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 2194481, unzip_LRU len: 0 I/O sum[1143]:cur[0], unzip sum[0]:cur[0]
Please let me know if any extra details are needed. We can also try to reproduce an issue and collect needed data.
--- Regards, Eugene Shelepov
Hello,
We have a lot of small databases, about 7 thousand with about 300 tables in each of them. Open tables are limited to 100,000.
When mysql crashed innodb_dict_size was set to 4Gb.
BUFFER POOL AND MEMORY ------- ------- -
-------
Total memory allocated 37632000000; in additional pool allocated 0
Internal hash tables (constant factor + variable factor)
Adaptive hash index 1326803568 (581048824 + 745754744)
Page hash 36316328
Dictionary cache 23604963972 (145264208 + 23459699764)
File system 83536 (82672 + 864)
Lock system 90822072 (90789784 + 32288)
Recovery system 0 (0 + 0)
Threads 408112 (406936 + 1176)
Dictionary memory allocated 23459699764
Buffer pool size 2239999
Buffer pool size, bytes 36700143616
Free buffers 0
Database pages 2194481
Old database pages 810052
Modified db pages 866
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 20778188, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 20983317, created 3975656, written 43405370
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s
LRU len: 2194481, unzip_LRU len: 0
I/O sum[1143]:cur[0], unzip sum[0]:cur[0]
Please let me know if any extra details are needed. We can also try to reproduce an issue and collect needed data.
---
Regards,
Eugene Shelepov