当前位置：网站首页>Whether the SQL that fails to execute MySQL is counted into the slow query?
Whether the SQL that fails to execute MySQL is counted into the slow query?
2022-07-26 04:36:00 【tin】
Excuse me, the execution failed sql, For example, after a certain period of time （ Slow query threshold reached ）, Lost connection , Whether the slow query log will be recorded ？
Other answers 1：
I won't , If you lose the connection, you will directly report an error
Other answers 2：
I did this experiment
There is a row of records in the table
perform
select *,sleep(10)from t
Then force it off workbench. But quotation sentences still appear in slow queries .
Other answers 3：
I've tested it before , If a big query , For example, to scan 100w That's ok , Scanning in the middle 10w That's ok , By ctrl+c 了 , So slow, there will be record scanning in the query 10w Time for .
Other answers 4：
Tested under ,SQL The execution time , Just over slowlog The threshold of (long_query_time), Even if the final execution fails , It will also record .
边栏推荐
- Sangi diagram of machine learning (for user behavior analysis)
- Weights & biases (II)
- 解决 Incorrect string value: ‘\xF0\x9F\x98\xAD“,...‘ for column ‘commentContent‘ at row 1 报错
- [C language foundation] 13 preprocessor
- Add watermark to ffmpeg video
- AWS Support Plan
- 2022 Hangdian multi school DOS card (line segment tree)
- 5、 Domain objects share data
- SwiftUI一日速成
- How does win11 set the theme color of the status bar? Win11 method of setting theme color of status bar
猜你喜欢
Ffmpeg video coding
Integrated architecture of performance and cost: modular architecture
Steam科学教育赋予课堂教学的创造力
Use Baidu PaddlePaddle easydl to complete garbage classification
性能和成本的综合架构：单元化架构
MySQL - multi table query - Cartesian product sum, correct multi table query, equivalent connection and unequal connection, inner connection and outer connection
I.MX6U-系统移植-6-uboot图形化配置
Wu Enda's machine learning after class exercises - logical regression
Spark Structured Streaming HelloWorld
Wu Enda's machine learning after class exercises - linear regression
随机推荐
Function knowledge points
FFmpeg 视频添加水印
数组排序2
MySQL log classification: error log, binary log, query log, slow query log
Steam科学教育赋予课堂教学的创造力
Array sort 3
2022河南萌新联赛第（三）场：河南大学 L - 合成游戏
计算离散点的曲率（matlab）
Dijango learning
TIA botu WinCC Pro controls the display and hiding of layers through scripts
2022 Henan Mengxin League game (3): Henan University a - corn cannon
The difference between positive samples, negative samples, simple samples and difficult samples in deep learning (simple and easy to understand)
Array sort 2
Creative design principle of youth maker Education
UE4 获取玩家控制权的两种方式
Solve the error string value: '\xf0\x9f\x98\xad',... 'for column' commentcontent 'at row 1
2022河南萌新联赛第（三）场：河南大学 J - 神奇数字
View and modify the number of database connections
Wu Enda's machine learning after class exercises - linear regression
How does win11 change the power mode? Win11 method of changing power mode