Fusion-io iodrive 2 mysql ve bios ayarları
MySQL 5.5 sunucusunda tavsiye edilen ayarlar şunlar :
innodb_flush_method=O_DIRECT Use direct IO and fsync to flush data and log files.
innodb_max_dirty_pages_pct=60 Percentage of dirty pages to keep in the pool Keep at 60-80% of total system memory. Always monitor memory usage to make sure the system does not start to swap out pages.
innodb_write_io_threads=16 Number of background write I/O threads
innodb_read_io_threads=8 Number of background read I/O threads
innodb_adaptive_flushing=1 Adaptively flush dirty pages.
innodb_log_files_in_group=2 Default and recommended value is 2
innodb_log_file_size=2G Reduce checkpoint activity by increasing log file size. This also increases recovery time, but fast storage like ioMemory handles this well.
innodb_io_capacity=10000 Number of I/O operations
innodb_thread_concurrency=0 Set an unlimited number of threads. For CPU-bound workloads, it may make sense to limit this to 16.
innodb_purge_threads=1 Let the InnoDB purge operation run in a separate thread to reduce contention
BIOS tarafında ise benim yaptığım ayarlar aşağıda fakat siz kendi donanımınıza göre bu ayarlarla oynayabilirsiniz. Fusion IO sitesinde gerekli dökümanlar mevcut. Hyperthreading – disabled or enabled – try both & test with your application. Quite often disabling HT can help performance. Intel Virtualization Technology – if you’re not virtualizing, disable this VT-d – if you’re not virtualizing, disable this Power Technology – disabled Enhanced SpeedStep – disabled Turbo Mode – disabled P-STATE Coordination – if this option is still available, set to HW_ALL Package C State limit – C0, this option should effectively disable C-states for the server Fan Control – ideally I’d recommend that this was set to “Enhanced”. The ideal scenario is that you’re maximizing CPU usage by your application – enabling your server to support a larger workload. Turning the fans up will help cool that busy CPU and avoid any thermal throttling of the CPU.
Posted in Fusion IO, Linux, MySQL, Veritabanları on December 24th, 2012 by Kürşad DARA | | 0 Comments
