Member Avatar for riahc3
riahc3 50  

I want to prepare MySQL Server 5.6 for thousands/millions of inserts. Ive found this:

•innodb_doublewrite = 0
•innodb_buffer_pool_size = 50%+ system memory
•innodb_log_file_size = 512M
•log-bin = 0
•innodb_support_xa = 0
•innodb_flush_log_at_trx_commit = 0

Is there anything else I can do?

Thank you

  • 1 Contributor
  • 0 Replies
  • 90 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.