目前修改的是mysql的設定檔/etc/my.cnf

目前修改的是mysql的設定檔/etc/my.cnf

僅增加以下設定值

innodb_thread_concurrency=32

innodb_buffer_pool_size=768M

innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=2

innodb_flush_method=O_DIRECT

innodb_lock_wait_timeout=1