Archive for August, 2014

Speed up mysql restoring

Increase key buffer size as much as you can

Add this header in your dump file

SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, AUTOCOMMIT = 0;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS = 0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0;

 

Add this in the end

 

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET AUTOCOMMIT = @OLD_AUTOCOMMIT;

Advertisements

Leave a comment

Amazon AWS xennet: skb rides the rocket

Saw some time ago this problem in one server

 

 xennet: skb rides the rocket

 

Seems like we had  some kernel driver or hardware interaction problem when dealing with lots of sockets or jumbo frames.

 

To solve that, I had configured MTU to 1500 and 

ethtool -K eth0 gso off

ethtool -K eth0 tso off

 

Leave a comment