i read innodb supposed better @ writing mysql myisam, however, i'm trying out, running 3000 mysql queries(inserting rows, 8 columns + id)... results haven't turned out how i'd hoped.
using innodb execution time around 5.3 seconds while myisam takes around 2.2 seconds.
my current mysql configuration is:
innodb_io_capacity = 8000 innodb_read_io_threads = 64 innodb_write_io_threads = 64 innodb_log_buffer_size = 32m innodb_log_file_size = 564m innodb_buffer_pool_size = 6g innodb_buffer_pool_instances = 6 innodb_thread_concurrency = 0 everything else @ default value.
server running: ubuntu 14.04 x64
has 12gb ram
6 cores
, using ssd (service provider says provides 10,000 iops)
what best configuration innodb if use innodb, , best configuration myisam (like reason faster if disable innodb while not using it.)?
right thinking of using server storing stuff, , need write more data, reading it... while later on, thinking of reading more writing.
not sure if matters, right running nginx (do not have apache on server), php 5.6 , mysql 5.6.19.
myisam not crash safe, or transactional.. innodb , ensuring data synced disk (myisam not) before finishing statement (or commit).
try bulking writes single transaction (begin; insert, insert; commit), or, running multiple inserts in parallel rather sequentially (or both @ same time).. these things improve performance significantly.
i read through link suggested stuart wagner.
Comments
Post a Comment