Re: CPU usage too low

[A R]

Solved.

The issue was the default innodb_flush_log_at_trx_commit = 1.

I solved by adding the following line in my /etc/mysql/my.cnf file in the InnoDB part:

innodb_flush_log_at_trx_commit=2


Then restarted my server and the script works nice and fast!


I read in the reference manual that

"For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, use innodb_flush_log_at_trx_commit=1 and sync_binlog=1 in your master server my.cnf file."


Since I am using this database for scientfic research, should I worry about replicability or is "replication" a technical term unrelated to scientific replicability in the context of RDBMS?


Thanks a lot for your help.
AR