Method: Brillo::Adapter::MySQL#header

Defined in:
lib/brillo/adapter/mysql.rb

#header ⇒ Object 



4
5
6
7
8
9
10
11
12
 
# File 'lib/brillo/adapter/mysql.rb', line 4

def header
  super + "  -- Disable autocommit, uniquechecks, and foreign key checks, for performance on InnoDB\n  -- http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html\n  SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, AUTOCOMMIT = 0;\n  SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS = 0;\n  SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0;\n  SQL\nend\n"