更改参数mysql参数，大幅提高写性能

innodb_flush_log_at_trx_commit = 0 

# If set to 1, InnoDB will flush (fsync) the transaction logs to the                                                                                                             

# disk at each commit, which offers full ACID behavior. If you are                                                                                                               
# willing to compromise this safety, and you are running small                                                                                                                   
# transactions, you may set this to 0 or 2 to reduce disk I/O to the                                                                                                             
# logs. Value 0 means that the log is only written to the log file and                                                                                                           
# the log file flushed to disk approximately once per second. Value 2                                                                                                            
# means the log is written to the log file at each commit, but the log                                                                                                           
# file is only flushed to disk approximately once per second.                                                                                                                    

sync_binlog = 0
If the value of this variable is greater than 0, the MySQL server synchronizes its binary log to disk (using fdatasync()) after every sync_binlog writes to the binary log. There is one write to the binary log per statement if autocommit is enabled, and one write per transaction otherwise. The default value of sync_binlog is 0, which does no synchronizing to disk. A value of 1 is the safest choice because in the event of a crash you lose at most one statement or transaction from the binary log. However, it is also the slowest choice (unless the disk has a battery-backed cache, which makes synchronization very fast).
If the value of sync_binlog is 0 (the default), no extra flushing is done. The server relies on the operating system to flush the file contents occasionally as for any other file.