Re: Sending data in processlist
Posted by:
CD Ben
Date: December 26, 2014 02:23AM
Hi James,
Sorry for late reply. Actually I was trying to update the MySQL(v5.6.22.0) and Connector(5.3.4-winx64) but did not success there was some other problem with the new database. That I will see letter.
I tried with your suggestion but did not success.
The processlist shows :
Select queries status are (Sending data, opening tables, closing tables, (NULL), waiting for query cache lock)
Insert queries status (opening tables, closing tables)
Select queries :
================
select * from test354 where time_of_ping between '2014-12-26 04:59' and '2014-12-26 13:27' order by 2 desc
SELECT b.shutDownFlag, b.time_of_ping, b.observedstate, b.simulatedstate FROM (SELECT max(time_of_ping) AS last_ping from test100 where !(observedstate=4 and powercost=0)) AS a JOIN test100 AS b ON b.time_of_ping = a.last_ping
Insert queries :
================
INSERT INTO test79 (time_of_ping, observedstate, predictedstate, controlledstate, observedSmoothened, weightedHistorical, decision, powerconsumption, actualpowerconsumption, simulatedpowerconsumption, powercost, actualpowercost, powercostpredicted, simulatedstate, shutDownFlag, UserSatisfied, actualSavings, cpuUser, cpuSystem, cpuIdle, cpuTemperature, suspendFailureReason, overAllSavings, isRecoveredData, isWakeupCommandIssued, accessIssue) VALUES ('2014-12-25 23:19:10', 1, 0, 0, 0.00, 0.00, 0.00, 1.25, 3.33, 3.33, 1.25, 3.00, 3.00, 1, '', 1, 0.00, 0.00, 0.00, 0.00, 0.00, NULL, 1.21, 0, 0, '')