MySQL Forums
Forum List  »  General

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, '')

Options: ReplyQuote


Subject
Written By
Posted
December 19, 2014 07:55AM
December 20, 2014 12:03AM
December 20, 2014 05:33AM
December 20, 2014 10:18AM
Re: Sending data in processlist
December 26, 2014 02:23AM
December 26, 2014 11:56AM
December 29, 2014 02:59AM
December 29, 2014 01:16PM
December 30, 2014 07:02AM
December 30, 2014 02:55PM
January 01, 2015 01:55AM
January 01, 2015 08:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.