Purchase Linux CDs / DVDs / Flash Drives at OSDisc.com

Welcome to Our Community

While Linux.org has been around for a while, we recently changed management and had to purge most of the content (including users). If you signed up before April 23rd, 2017 please sign up again. Thanks!

Have a question about "max_binlog_cache_size"

Discussion in 'Database' started by 23.999k, Jul 12, 2013.

  1. 23.999k

    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 ?

    (Log in to hide this advertisement)

  2. ryanvade

    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?
  3. 23.999k

    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
  4. 23.999k

    23.999k Guest

    Thank you very much!

Share This Page