my.cnf in pauldowman-ec2onrails-0.9.10.0

- old
+ new

@@ -40,10 +40,12 @@
 datadir         = /mnt/mysql_data
 tmpdir          = /mnt/mysql_data/tmp
 language        = /usr/share/mysql/english
 skip-external-locking
 default-storage-engine = InnoDB
+character-set-server   = utf8
+collation-server       = utf8_general_ci
 
 #
 # Instead of skip-networking the default is now to listen only on
 # localhost which is more compatible and is not less secure.
 #bind-address            = 127.0.0.1
@@ -71,11 +73,11 @@
 #
 # Error logging goes to syslog. This is a Debian improvement :)
 #
 # Here you can see queries with especially long duration
 log_slow_queries        = /mnt/log/mysql/mysql-slow.log
-long_query_time = 2
+long_query_time = 1
 log-queries-not-using-indexes
 #
 # The following can be used as easy to replay backup logs or for replication.
 #server-id              = 1
 log_bin                 = /mnt/log/mysql/mysql-bin.log
@@ -124,9 +126,10 @@
 quick
 quote-names
 max_allowed_packet      = 16M
 
 [mysql]
+default-character-set   = utf8
 #no-auto-rehash # faster start of mysql but no tab completition
 
 [isamchk]
 key_buffer              = 16M
 