#ANALYSIS

#UPDATE 2014-11-04 21:06 EST

#SUGGESTION #1

#SUGGESTION #2

#SUGGESTION #3

#SUGGESTION #4

ANALYSIS

UPDATE 2014-11-04 21:06 EST

SUGGESTION #1

SUGGESTION #2

SUGGESTION #3

SUGGESTION #4

• Sep 25, 2013 : Why should I use InnoDB and MySql instead of XtraDB and MariaDB?
• Mar 26, 2012 : Percona vs MySQL
• Nov 24, 2011 : Why mysql 5.5 slower than 5.1 (linux,using mysqlslap)
• Oct 05, 2011 : Query runs a long time in some newer MySQL versions
• Jun 19, 2011 : How do I properly perform a MySQL bake-off?

• Jun 01, 2012 : I've got 16GB of ram, how should I configure MySQL Server?
• May 07, 2012 : MySQL Server Performance
• Apr 26, 2012 : Is the CPU performance relevant for a database server?
• Mar 16, 2012 : Using multiple cores for single MySQL queries on Debian
• Oct 07, 2011 : Should I use a storage engine other than MyISAM to optimise these tables or should I get better disks?
• Sep 20, 2011 : Multi cores and MySQL Performance
• Sep 12, 2011 : Possible to make MySQL use more than one core?
• May 26, 2011 : About single threaded versus multithreaded databases performance

• Sep 25, 2013 : Why should I use InnoDB and MySql instead of XtraDB and MariaDB?
• Mar 26, 2012 : Percona vs MySQL
• Nov 24, 2011 : Why mysql 5.5 slower than 5.1 (linux,using mysqlslap)
• Oct 05, 2011 : Query runs a long time in some newer MySQL versions
• Jun 19, 2011 : How do I properly perform a MySQL bake-off?

• Jun 01, 2012 : I've got 16GB of ram, how should I configure MySQL Server?
• May 07, 2012 : MySQL Server Performance
• Apr 26, 2012 : Is the CPU performance relevant for a database server?
• Mar 16, 2012 : Using multiple cores for single MySQL queries on Debian
• Oct 07, 2011 : Should I use a storage engine other than MyISAM to optimise these tables or should I get better disks?
• Sep 20, 2011 : Multi cores and MySQL Performance
• Sep 12, 2011 : Possible to make MySQL use more than one core?
• May 26, 2011 : About single threaded versus multithreaded databases performance

Your innodb_log_buffer_size is 8M by default. Try making it 256M to increase log write performance.

Your innodb_log_buffer_size is 8M by default. Try making it 256M to increase log write performance.

#SUGGESTION #4

Your innodb_log_file_size is 512M. Try making it 2G to increase log write performance. If you apply this setting, then set innodb_log_buffer_size to 512M.