- View the diff current.
- View the source.
- Go to MySQL/Configuration.
7: 2013-04-24 (Wed) 12:39:50 iseki | 8: 2013-04-24 (Wed) 17:25:09 iseki | ||
---|---|---|---|
Line 38: | Line 38: | ||
mysql> create database db_name default character set utf8; | mysql> create database db_name default character set utf8; | ||
#br | #br | ||
- | *** Log [#xaa6ec18] | ||
- | **** query log [#y7ca8dc2] | ||
- | - /etc/init.d/mysql(d) で mysqld_safe の起動に ''--general_log'' オプションを付ける | ||
- | - log ファイル名は my.cnf の ''general_log_file=...'' で指定.デフォルトはデータベースのディレクトリ | ||
- | general_log_file=/var/log/mysql/query.log | ||
- | #br | ||
- | |||
- | **** slow query log [#m69f9bc7] | ||
- | - my.cnf | ||
- | slow_query_log | ||
- | slow_query_log-file=/var/log/mysql/slow.log | ||
- | long_query_time=5 これ以上の時間(秒)がかかるクエリをスロークエリとする | ||
- | #br | ||
- | **** binary log [#ba964975] | ||
- | - my.cnf | ||
- | log-bin=mysql-bin | ||
- | expire_logs_days=30 |
- Backup list of MySQL/Configuration
- Backup diff of MySQL/Configuration(No. All)
- 1: 2009-04-20 (Mon) 23:15:38 iseki
- 2: 2009-04-20 (Mon) 23:45:28 iseki
- 3: 2009-04-21 (Tue) 02:56:47 iseki
- 4: 2009-06-11 (Thu) 21:28:56 iseki
- 5: 2009-11-15 (Sun) 16:28:26 iseki
- 6: 2012-05-23 (Wed) 17:06:01 iseki
- 7: 2013-04-24 (Wed) 12:39:50 iseki
- 8: 2013-04-24 (Wed) 17:25:09 iseki
- Cur: 2020-08-23 (Sun) 13:55:19 iseki