Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\BI\AppData\Roaming\MySQL\Workbench\log\wb.log]
My program runs the query :
insert into revealer1.live_data(workorderno,Proname,Batch,customername,lastname,Mktggroup,Plan_Date,sole,Target_Date,
upper,plan,actual,Target_Pairs,w_batch,w_workorderno,w_proname,Arrears,Art_No,Created_date,Created_time)
select p.workorderno ,p.proname,p.batch,p.customername,
p.lastname,p.mktggroup,p.PlanDate,p.sole,p.TargetDate,
p.upper,p.Plan,p.actual,p.TargetPairs,
w.batch,w.workorderno,w.proname,w.Arrears,p.ArtNo,curdate(),curtime()
from revealer1.woarrear_live w
left outer join revealer1.woplan_live p
on (w.workorderno=p.workorderno and w.batch=p.batch and w.proname=p.proname)
union all
select p.workorderno ,p.proname,p.batch,p.customername,p.lastname,p.mktggroup,p.PlanDate,p.sole,p.TargetDate,p.upper,p.Plan,p.actual,p.TargetPairs,
w.batch,w.workorderno,w.proname,w.Arrears,p.ArtNo,curdate(),curtime()
from revealer1.woarrear_live w
left outer join revealer1.woplan_live p
on (w.workorderno=p.workorderno and w.batch=p.batch and w.proname=p.proname)
where w.workorderno is null;
As i am inserting data using the insert command given above, from two tables 1.woarrear_live 2.woplan_live
into live_data table, where woarrear_live contains 138450 rows and woplan_live contains 156256 rows , Mysql Server is taking long time and finally data is not get loaded.
We have the schedule process to insert the data into live_data table at different time intervals. We are running events at schedule time to load the data into live_data table.
If i Restart the Services of Mysql, then the Insert query taking less time to load the data.
Please help me to run Insert query in time with out running the services of Mysql, Every time in Schedule processing.
How to repeat:
As i am inserting data using the insert command given above, from two tables 1.woarrear_live 2.woplan_live
into live_data table, where woarrear_live contains 138450 rows and woplan_live contains 156256 rows , Mysql Server is taking long time and finally data is not get loaded.
We have the schedule process to insert the data into live_data table at different time intervals. We are running events at schedule time to load the data into live_data table.
Suggested fix:
We have the schedule process to insert the data into live_data table at different time intervals. We are running events at schedule time to load the data into live_data table.
If i Restart the Services of Mysql, then the Insert query taking less time to load the data.
Please help me to run Insert query in time with out running the services of Mysql, Every time in Schedule processing.
