56,673
社区成员
发帖
与我相关
我的任务
分享
/*-- 记录到文件的格式
# Time: 2018-01-24T09:03:04.440933Z
# User@Host: dba_jack[dba_jack] @ localhost [::1] Id: 4
# Query_time: 47.920177 Lock_time: 0.016016 Rows_sent: 1 Rows_examined: 28853938
use db;
SET timestamp=1516784584;
select ;
*/
-- 从表中导出时,通过拼字符串的方式组织各列
SELECT
CONCAT(
'# Time: ',
DATE_FORMAT(
start_time - INTERVAL TIMESTAMPDIFF(Minute, UTC_TIMESTAMP(), NOW()) MINUTE,
'%Y-%m-%dT%h:%i:%s'),
'.', LPAD(MICROSECOND(start_time), 6, '0'), 'Z\n',
'# User@Host: ', user_host, ' Id: ', lpad(thread_id,5,' '), '\n',
'# Query_time: ',CAST(query_time as decimal(24,6)),
' Lock_time: ', CAST(lock_time as decimal(24,6)),
' Rows_sent: ', rows_sent,
' Rows_examined: ',rows_examined, '\n',
'use ', db, ';\r',
'SET timestamp=', UNIX_TIMESTAMP(start_time), ';\n',
CONVERT(sql_text using utf8), ';'
)
-- INTO OUTFILE '/xx/slow.log' FIELDS TERMINATED BY '' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n'
FROM mysql.slow_log