Jump to Navigation
Home

Languages

  • English

Login

Search form

  • About us
  • Services
  • Software
  • Resources
  • Download

Redo Log

InnoDB Log Buffer is too small for large transactions

Mon, 2019-12-23 14:05 — Shinguz

Your InnoDB Redo Log Buffer is too small for large transactions. Make the InnoDB Redo Log Buffer (innodb_log_buffer_size) bigger if you have enough RAM available to avoid additional I/O.
1 Mibyte is good for databases with small transactions. 8 Mibyte is good for medium size transactions. 64 MiByte is good for large transactions.

See also for MariaDB MySQL.

tags: 
fpmmm triggers and rules
innodb
transaction log
redo log
  • Read more about InnoDB Log Buffer is too small for large transactions
Subscribe to RSS - Redo Log
  • About us

    • News
    • About FromDual
    • Contact
    • Partner
    • References
    • Newsletter
    • Press
  • Services

    • Consulting
    • Support
      • MySQL
      • DB Development
    • Remote-DBA
    • Training
      • Training Modules
      • Class Schedule
      • for Developer
      • for Administrators
      • Galera Cluster
  • Software

    • Performance Monitor
    • Ops Center
    • Backup and Recovery Manager
    • MyEnv
    • Download
  • Resources

    • Blog
    • Presentations
    • SQL Formatter
    • Database Health Check
    • Performance Tuning Key
    • Consulting tools
    • MySQL Configuration
  • Download

  • Recent content

Trademarks

RSS LinkedIn X / Twitter Facebook Flickr Bluesky YouTube Mastodon Matrix PeerTube Codeberg twitter

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB®, the sea lion logo and MaxScale® are registered trademarks of MariaDB Corp. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner.