Have a question about "max_binlog_cache_size"

2

23.999k

Guest
Today, I use the "load data" way to restore the database.But there is a error,
  • ERROR 1197 (HY000) at line 1: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again
The memory is 16G, max_binlog_cache_size = 2G.
And then i use "mysql -u -p db_name < db_name.sql" way to restore the same database.There isn't error.
Help me!
Please tell me why ?
 


R

ryanvade

Guest
the process must have use the full 2 GB. How many gigabytes of information did you try to import? Perhaps you should try using ulimit?
 
2

23.999k

Guest
Five gigabytes of information. And my system "ulimit -n" are 51200...
Now I are through the temporary increase "max_binlog_cache_size" values for data recovery
 

Members online


Top