Skip to content

Instantly share code, notes, and snippets.

@smathy
Created March 18, 2011 20:27
Show Gist options
  • Save smathy/876769 to your computer and use it in GitHub Desktop.
Save smathy/876769 to your computer and use it in GitHub Desktop.
[server]
character_set_server=utf8
collation_server=utf8_unicode_ci
skip_character_set_client_handshake
default_table_type=innodb
transaction-isolation=READ-COMMITTED
innodb_file_per_table
local_infile=0
max_allowed_packet=1G
socket = /tmp/mysql.sock
[client]
socket = /tmp/mysql.sock
# vim: filetype=dosini
@jesusabarca
Copy link

If using Mysql 5.5+, the default_table_type option is not needed anymore, since InnoDB is the default storage engine. If not removed/commented, it will throw an error at server startup.

Reference:
http://dev.mysql.com/doc/refman/5.5/en/storage-engine-setting.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment