Geek Answers Handbook

Mysql memory table cannot exceed 2G size

I installed max_heap_table_sizein 5G (5368709120), but my memory table cannot grow more than 2G. The Mysql process is 64 bits, so it has a lot of memory and also has physical memory. But despite this, I received an error messageERROR 1114 (HY000) at line 1: The table 'my_cache' is full

Over time, there is an increase in size:

data_mb index_mb total
2048.00 1178.28 3226.28
2048.00 984.57  3032.57
2048.00 792.84  2840.84
1795.40 599.13  2394.53
1218.23 407.41  1625.64
665.04  221.68  886.71

What's wrong?

UPD I increased max_heap_table_sizeto 10G, and it worked, and there was no error!

Growth Statistics:

2048.00 1563.72 3611.72
2048.00 1370.00 3418.00
2048.00 1178.28 3226.28
2048.00 984.57  3032.57
2048.00 792.84  2840.84
1795.40 599.13  2394.53

What happened?

+4
source share
2 answers
  • MEMORY . , max_heap_table_size . MAX_ROWS CREATE TABLE

percona

0
  • show variables like 'max_heap_table_size', .
  • set max_heap_table_size=xxxxxxx;
  • Alter, . truncate table table_name;, alter table table_name ENGINE=MEMORY;
  • max_heap_table_size mysql, mysql.
0

More articles:


All Articles