MySQL configuration for local development

my.cnf

[client]
default-character-set=utf8

[mysqld]
slow_query_log=1
long_query_time=.3

default_storage_engine=InnoDB
character-set-server = utf8
collation-server = utf8_general_ci
lower_case_table_names=2

query-cache-type = 1
query-cache-size = 8M

innodb_file_format=barracuda
innodb_doublewrite=0

skip-sync-frm=OFF
transaction-isolation = SERIALIZABLE