flagflag  
7: 2013-04-24 (Wed) 12:39:50 iseki source 8: 2013-04-24 (Wed) 17:25:09 iseki source
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.l​og 
-#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 


Front page   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMay 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Today

Who's Online

37 user(s) are online (2 user(s) are browsing xpwiki)

Members: 0
Guests: 37

more...

Access Counter

Today : 2194219421942194
Yesterday : 3883388338833883
Total : 2369470423694704236947042369470423694704236947042369470423694704
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com