Bug #89637 | Contribution by Facebook: Slow Query Log Changes | ||
---|---|---|---|
Submitted: | 13 Feb 2018 1:38 | Modified: | 15 Oct 2018 16:06 |
Reporter: | FBContrib Admin | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Logging | Severity: | S3 (Non-critical) |
Version: | 8.0.4 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[13 Feb 2018 1:38]
FBContrib Admin
[13 Feb 2018 1:38]
FBContrib Admin
Slow Query Log Changes (*) This code is contributed under the Facebook agreement
Contribution: fb_patch_27.txt (text/plain), 40.82 KiB.
[15 Oct 2018 16:06]
Paul DuBois
Posted by developer: Fixed in 8.0.14. A new system variable, log_slow_extra, if enabled, causes the server to write additional fields to slow query log lines that provide information about slow statements. In addition, SET lines written to the log to indicate statement timestamps now use the time from the beginning of statement execution, rather than the time at the end of execution. Thanks to Facebook for the contribution on which this feature is based.