<pre name="code" class="html"># User@Host: zjzc_app[zjzc_app] @ [10.171.243.55] Id: 1621705
# Query_time: 10.666552 Lock_time: 0.000392 Rows_sent: 15 Rows_examined: 24829551
SET timestamp=1452566321;
SELECT
*
FROM
(SELECT
c.sn,
c.userNick,
c.mobilePhone,
DATE_FORMAT(c.registerTime, '%Y/%m/%d') registerTime,
cp.personName,
cp.personCardNo,
cp.gender,
cp.personAuthStatus,
IF(1407 = asm.clientManagerSn
OR 1407 IS NULL, cei.policyAreaSn, NULL) AS policyAreaSn,
IF(1407 = asm.clientManagerSn
OR 1407 IS NULL, area.areaName, NULL) AS policyAreaName,
logstash 通过mysql 慢日志了解(?m)
最新推荐文章于 2024-04-15 04:06:54 发布
本文探讨了如何使用Logstash解析MySQL的慢查询日志,通过示例展示了匹配表达式对于日志解析的重要性,包括User@Host、Query_time、Lock_time等关键信息的提取,并提到了在使用codec/multiline时关于回车换行匹配的注意事项。
摘要由CSDN通过智能技术生成