MySQLを使う
/etc/my.cnf をテキトーに編集する
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 port=3306 # default-character-set=utf8 character-set-server=utf8 # Semisynchronous Replication # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html # uncomment next line on MASTER ;plugin-load=rpl_semi_sync_master=semisync_master.so # uncomment next line on SLAVE ;plugin-load=rpl_semi_sync_slave=semisync_slave.so # Others options for Semisynchronous Replication ;rpl_semi_sync_master_enabled=1 ;rpl_semi_sync_master_timeout=10 ;rpl_semi_sync_slave_enabled=1 # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html performance_schema # memory tuning innodb_buffer_pool_size=512MB innodb_additional_mem_pool_size=20MB innodb_log_buffer_size=16MB innodb_log_file_size=128MB sort_buffer_size=4MB read_rnd_buffer_size=2MB join_buffer_size=256KB read_buffer_size=1MB key_buffer_size=256MB max_connections=200 log_output=TABLE general-log=ON # general-log-file=/var/log/mysqld-trace.log slow_query_log=ON # slow_query_log_file=/var/log/mysqld-slow.log long_query_time=2 # log-long-format [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid port=3306 default-character-set=utf8 #skip-character-set-client-handshake
使ってみたいので performance_schema をオンにした。
Performance Schema @ MySQL Casual #2
起動
/etc/init.d/mysql start
