Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.19
-
None
-
Microsoft Windows Server 2012 R2 Standard
Description
Every 4 seconds following errors logged in to error log.
I tried setting Global Variable
log_warnings=2
and tried
log_warnings=3
and tried
log_warnings=0
irrespective of setting above , the below error message continues
=======================================================================================
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start merge-sorting index `id`-temporary- (1 / 1), estimated cost : 20.0000
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of merge-sorting index `id`-temporary- (1 / 1)
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start building index `id`-temporary- (1 / 1), estimated cost : 30.0000
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of building index `id`-temporary- (1 / 1)
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Start applying row log
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : End of applying row log
2017-03-21 14:42:20 12860 [Note] InnoDB: Online DDL : Completed
=======================================================================================
Following statement is inside a stored procedure and the procedure is called in
scheduled event that repeats every on minute.
do you think following statement may be the reason for the above messages continuously in the error log
CREATE TEMPORARY TABLE tableau_reporting.temp310
SELECT id,
(SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 1) AS RH1,
(SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 2) AS RH2,
(SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 3) AS RH3,
(SELECT rh FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 4) AS RH4,
(SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 1) AS Sum1,
(SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 2) AS Sum2,
(SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 3) AS Sum3,
(SELECT RH_Zero_Counter FROM v1dm10_temp_hum_90days b WHERE b.id = a.id - 4) AS Sum4
FROM v1dm10_temp_hum_90days a
WHERE RH_Zero_Counter = 1 ;
CREATE INDEX id
ON tableau_reporting.temp310(id);
=======================================================================================
Attachments
Issue Links
- duplicates
-
MDEV-10509 Excessive InnoDB logging on release server
- Closed