# Mysql Optimization

**URL:** <https://forum.inductiveautomation.com/t/mysql-optimization/2086>\
**Category:** Archived Topics\
**Created:** [July 27, 2010, 9:03pm UTC](https://forum.inductiveautomation.com/t/mysql-optimization/2086 "2010-07-27T21:03:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 27, 2010, 9:03pm UTC](https://forum.inductiveautomation.com/t/mysql-optimization/2086/1 "2010-07-27T21:03:01Z")

</div>

Can somebody post their my.cnf from Mysql (Linux OS)? I am looking for someone running a large database with heavy updates/inserts from Transactional groups. We are running 130 groups around 5000 to 6000 items with multiple table inserts a second or less and 6000 to 7000 SQL tags mostly writing to ALERT\_LOG at 1 sec update. Our innodb length = 5G. The innodb parameters and data/log files are confusing and I would like to compare. Also Mysql recommends in Linux to turn off the disk write-back cache. Has anyone done this? Has anyone had good success taking load off the disk?