Have a question about "max_binlog_cache_size"

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

  1. 23.999k

    23.999k New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    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 ?

  2. ryanvade

    ryanvade Administrator Staff Member Staff Writer

    Messages:
    889
    Likes Received:
    288
    Trophy Points:
    63
    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 New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    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. ryanvade

    ryanvade Administrator Staff Member Staff Writer

    Messages:
    889
    Likes Received:
    288
    Trophy Points:
    63
  5. 23.999k

    23.999k New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Thank you very much!

Share This Page