Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
Source of
MySQL/log
[
Front page
]
[ ]
View the
diff
.
Go to
MySQL/log
.
** 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] - InnoDB ではバイナリログは使用できない. - my.cnf log-bin=mysql-bin expire_logs_days=30 #br
Backup source of MySQL/log(No. All)
Cur: 2013-04-24 (Wed) 17:25:52
iseki
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
Jun 2024
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
Today
Who's Online
37 user(s) are online (3 user(s) are browsing xpwiki)
Members: 0
Guests: 37
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com