Skip to content

Instantly share code, notes, and snippets.

/gist:10784993

Created April 15, 2014 22:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/10784993 to your computer and use it in GitHub Desktop.
Save anonymous/10784993 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
use nova;
SET timestamp=1389973171;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.653835 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973171;
commit;
# Time: 140117 15:39:32
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.240820 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973172;
commit;
# Time: 140117 15:40:00
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.805949 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 1
use neutron;
SET timestamp=1389973200;
UPDATE agents SET heartbeat_timestamp='2014-01-17 15:39:58' WHERE agents.id = 'b082eb8e-3563-41ec-a8db-39fafcc57eed';
# Time: 140117 15:40:31
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.818055 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973231;
commit;
# Time: 140117 15:40:32
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.300174 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973232;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.148183 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973232;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.100758 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973232;
commit;
# Time: 140117 15:42:01
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.836204 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973321;
commit;
# Time: 140117 15:42:02
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.041672 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973322;
commit;
# Time: 140117 15:42:03
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.731352 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973323;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.713771 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973323;
commit;
# Time: 140117 15:43:32
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.078221 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973412;
commit;
# Time: 140117 15:43:34
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.828490 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973414;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.069002 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973414;
commit;
# Time: 140117 15:44:00
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.004486 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973440;
commit;
# Time: 140117 15:44:04
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.012347 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973444;
commit;
# Time: 140117 15:45:01
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.625128 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973501;
commit;
# Time: 140117 15:46:04
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.429653 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973564;
commit;
# Time: 140117 15:46:32
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.055798 Lock_time: 0.000056 Rows_sent: 0 Rows_examined: 1
use nova;
SET timestamp=1389973592;
UPDATE services SET updated_at='2014-01-17 15:46:30', report_count=513478 WHERE services.id = 5;
# Time: 140117 15:47:32
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.566626 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973652;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.093768 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973652;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.769828 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973652;
commit;
# Time: 140117 15:47:33
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.173675 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973653;
commit;
# Time: 140117 15:47:35
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.852923 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973655;
commit;
# Time: 140117 15:48:31
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.561506 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973711;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.139100 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973711;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.195567 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973711;
commit;
# Time: 140117 15:48:33
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.614980 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973713;
commit;
# Time: 140117 15:48:34
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.024994 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973714;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.983779 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973714;
commit;
# Time: 140117 15:49:02
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.385569 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973742;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.296804 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973742;
commit;
# Time: 140117 15:50:01
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.115218 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973801;
commit;
# Time: 140117 15:50:33
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.356885 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973833;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.875074 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973833;
commit;
# Time: 140117 15:51:31
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.376564 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973891;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.067189 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389973891;
commit;
# Time: 140117 15:52:32
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.528018 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973952;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.228864 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973952;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.066550 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389973952;
commit;
# Time: 140117 15:52:36
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.446096 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389973956;
commit;
# Time: 140117 15:53:32
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.415414 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974012;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.150474 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974012;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.113474 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974012;
commit;
# Time: 140117 15:53:35
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.097534 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974015;
commit;
# Time: 140117 15:54:33
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.127481 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974073;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.184947 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974073;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.561596 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974073;
commit;
# Time: 140117 15:55:04
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.654869 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 1
SET timestamp=1389974104;
UPDATE agents SET heartbeat_timestamp='2014-01-17 15:55:02' WHERE agents.id = 'b082eb8e-3563-41ec-a8db-39fafcc57eed';
# Time: 140117 15:56:03
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.044954 Lock_time: 0.000063 Rows_sent: 0 Rows_examined: 1
SET timestamp=1389974163;
UPDATE agents SET heartbeat_timestamp='2014-01-17 15:56:01' WHERE agents.id = '628be18a-b5c4-4440-be5a-7d669005598e';
# Time: 140117 15:56:32
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.579344 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974192;
commit;
# Time: 140117 15:56:36
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.173118 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974196;
commit;
# Time: 140117 15:57:33
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.381977 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974253;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.985973 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974253;
commit;
# Time: 140117 15:57:36
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.382563 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974256;
commit;
# Time: 140117 15:59:04
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.452500 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974344;
commit;
# Time: 140117 15:59:33
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.018784 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974373;
commit;
# Time: 140117 15:59:37
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.117952 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974377;
commit;
# Time: 140117 16:00:05
# User@Host: root[root] @ localhost []
# Query_time: 2.981746 Lock_time: 0.000054 Rows_sent: 1 Rows_examined: 1
use mysql;
SET timestamp=1389974405;
show table status like 'general\_log';
# Time: 140117 16:00:07
# User@Host: root[root] @ localhost []
# Query_time: 2.211073 Lock_time: 0.000091 Rows_sent: 1 Rows_examined: 1
SET timestamp=1389974407;
show table status like 'slow\_log';
# Time: 140117 16:00:34
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.639762 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974434;
commit;
# Time: 140117 16:02:03
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.358265 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974523;
commit;
# Time: 140117 16:02:08
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.928110 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974528;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.891722 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974528;
commit;
# Time: 140117 16:03:04
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.560917 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974584;
commit;
# Time: 140117 16:05:38
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.008207 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974738;
commit;
# Time: 140117 16:06:34
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.122935 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974794;
commit;
# Time: 140117 16:07:08
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.116770 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974828;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.005826 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974828;
commit;
# Time: 140117 16:07:36
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.088318 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974856;
commit;
# Time: 140117 16:07:38
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.098905 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974858;
commit;
# Time: 140117 16:09:36
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.496282 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974976;
commit;
# Time: 140117 16:09:37
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.705840 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389974977;
commit;
# Time: 140117 16:09:38
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.438504 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389974978;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.769717 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389974978;
commit;
# Time: 140117 16:11:05
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.260573 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389975065;
commit;
# Time: 140117 16:15:36
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.024217 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389975336;
commit;
# Time: 140117 16:17:08
# User@Host: cinder[cinder] @ [10.30.8.252]
# Query_time: 2.136891 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use cinder;
SET timestamp=1389975428;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.117512 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389975428;
commit;
# Time: 140117 16:17:10
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.385046 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389975430;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.625624 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389975430;
commit;
# Time: 140117 16:18:09
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.762622 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389975489;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.676604 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389975489;
commit;
# Time: 140117 16:19:06
# User@Host: cinder[cinder] @ [10.30.8.252]
# Query_time: 2.781971 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use cinder;
SET timestamp=1389975546;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.598606 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389975546;
commit;
# Time: 140117 16:20:06
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.365075 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389975606;
commit;
# Time: 140117 16:21:37
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.114311 Lock_time: 0.000080 Rows_sent: 0 Rows_examined: 1
SET timestamp=1389975697;
UPDATE agents SET heartbeat_timestamp='2014-01-17 16:21:34' WHERE agents.id = 'b082eb8e-3563-41ec-a8db-39fafcc57eed';
# Time: 140117 16:22:09
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.809361 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389975729;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.223767 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389975729;
commit;
# Time: 140117 16:22:10
# User@Host: cinder[cinder] @ [10.30.8.252]
# Query_time: 2.213676 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use cinder;
SET timestamp=1389975730;
commit;
# Time: 140117 16:23:08
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.664378 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389975788;
commit;
# Time: 140117 16:23:09
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.166186 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389975789;
commit;
# Time: 140117 16:23:36
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.110832 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 1
use neutron;
SET timestamp=1389975816;
UPDATE agents SET heartbeat_timestamp='2014-01-17 16:23:34' WHERE agents.id = '5d1302c8-c7c2-4e0c-ae4f-8d4db114b79f';
# Time: 140117 16:24:08
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.392423 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389975848;
commit;
# Time: 140117 16:25:08
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.393344 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389975908;
commit;
# Time: 140117 16:26:08
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.812511 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389975968;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.129234 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389975968;
commit;
# Time: 140117 16:26:10
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.062679 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389975970;
commit;
# Time: 140117 16:26:11
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.686819 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389975971;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.715588 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389975971;
commit;
# Time: 140117 16:27:08
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.386959 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976028;
commit;
# Time: 140117 16:27:09
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.553667 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976029;
commit;
# Time: 140117 16:27:10
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.258658 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976030;
commit;
# Time: 140117 16:28:09
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.338859 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976089;
commit;
# Time: 140117 16:28:10
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.679749 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976090;
commit;
# Time: 140117 16:28:11
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.726602 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976091;
commit;
# Time: 140117 16:29:09
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.832249 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976149;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.668509 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976149;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.079246 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976149;
commit;
# Time: 140117 16:30:39
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.350961 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976239;
commit;
# Time: 140117 16:31:12
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.017375 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976272;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.293535 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976272;
commit;
# Time: 140117 16:31:39
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.962918 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976299;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.287568 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976299;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.237535 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976299;
commit;
# Time: 140117 16:33:39
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.661356 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976419;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.376496 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976419;
commit;
# Time: 140117 16:33:43
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.455084 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976423;
commit;
# Time: 140117 16:34:11
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.019292 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976451;
commit;
# Time: 140117 16:34:41
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.253510 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976481;
commit;
# Time: 140117 16:34:42
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.867771 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976482;
commit;
# Time: 140117 16:34:43
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.190921 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976483;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.533888 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976483;
commit;
# Time: 140117 16:35:10
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.843356 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976510;
commit;
# Time: 140117 16:35:13
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.793597 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976513;
commit;
# Time: 140117 16:36:12
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.872539 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976572;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.146383 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976572;
commit;
# Time: 140117 16:36:40
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.564868 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976600;
commit;
# Time: 140117 16:36:42
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.199449 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976602;
commit;
# Time: 140117 16:36:43
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.705385 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976603;
commit;
# Time: 140117 16:38:09
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.095718 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976689;
commit;
# Time: 140117 16:38:42
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.235266 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976722;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.561574 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976722;
commit;
# Time: 140117 16:38:44
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.231941 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976724;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.051089 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976724;
commit;
# Time: 140117 16:39:13
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.741511 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 1
SET timestamp=1389976753;
UPDATE agents SET heartbeat_timestamp='2014-01-17 16:39:10' WHERE agents.id = '5d1302c8-c7c2-4e0c-ae4f-8d4db114b79f';
# Time: 140117 16:41:10
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.772739 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976870;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.168851 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976870;
commit;
# Time: 140117 16:41:12
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.445891 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976872;
commit;
# Time: 140117 16:41:13
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.552971 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976873;
commit;
# Time: 140117 16:41:14
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.028214 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976874;
commit;
# Time: 140117 16:42:10
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.241274 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976930;
commit;
# Time: 140117 16:42:12
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.694310 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976932;
commit;
# Time: 140117 16:42:14
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.888358 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976934;
commit;
# Time: 140117 16:43:11
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.077464 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389976991;
commit;
# Time: 140117 16:43:12
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.738045 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389976992;
commit;
# Time: 140117 16:43:14
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.166221 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389976994;
commit;
# Time: 140117 16:43:41
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.314589 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977021;
commit;
# Time: 140117 16:43:43
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.643944 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977023;
commit;
# Time: 140117 16:43:44
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.372884 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977024;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.605347 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977024;
commit;
# Time: 140117 16:44:11
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.946554 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977051;
commit;
# Time: 140117 16:44:43
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.291083 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977083;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.666125 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977083;
commit;
# Time: 140117 16:44:45
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.811199 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977085;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.021260 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977085;
commit;
# Time: 140117 16:45:45
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.806500 Lock_time: 0.000088 Rows_sent: 0 Rows_examined: 1
use neutron;
SET timestamp=1389977145;
UPDATE agents SET heartbeat_timestamp='2014-01-17 16:45:42' WHERE agents.id = '628be18a-b5c4-4440-be5a-7d669005598e';
# Time: 140117 16:46:12
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.143394 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977172;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.131690 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977172;
commit;
# Time: 140117 16:46:14
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.059720 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977174;
commit;
# Time: 140117 16:46:15
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.234199 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977175;
commit;
# Time: 140117 16:46:40
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.074418 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977200;
commit;
# Time: 140117 16:46:45
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.034482 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977205;
commit;
# Time: 140117 16:47:42
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.114443 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977262;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.563809 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977262;
commit;
# Time: 140117 16:47:45
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.437136 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977265;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.392060 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977265;
commit;
# Time: 140117 16:48:43
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.171777 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977323;
commit;
# Time: 140117 16:48:46
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 4.508048 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977326;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.833396 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977326;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.938167 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977326;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.350814 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977326;
commit;
# Time: 140117 16:49:43
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.920347 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977383;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.410479 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977383;
commit;
# Time: 140117 16:49:44
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.022639 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977384;
commit;
# Time: 140117 16:49:46
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 3.109082 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977386;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 3.023772 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977386;
commit;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.976153 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977386;
commit;
# Time: 140117 16:51:13
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.498819 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977473;
commit;
# Time: 140117 16:51:14
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 4.023491 Lock_time: 0.000090 Rows_sent: 0 Rows_examined: 1
use nova;
SET timestamp=1389977474;
UPDATE services SET updated_at='2014-01-17 16:51:10', report_count=513866 WHERE services.id = 5;
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.184616 Lock_time: 0.000186 Rows_sent: 1 Rows_examined: 1
SET timestamp=1389977474;
SELECT services.created_at AS services_created_at, services.updated_at AS services_updated_at, services.deleted_at AS services_deleted_at, services.deleted AS services_deleted, services.id AS services_id, services.host AS services_host, services.`binary` AS services_binary, services.topic AS services_topic, services.report_count AS services_report_count, services.disabled AS services_disabled, services.disabled_reason AS services_disabled_reason
FROM services
WHERE services.deleted = 0 AND services.id = 7
LIMIT 1;
# Time: 140117 16:51:45
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.556817 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1389977505;
commit;
# Time: 140117 16:52:43
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.009009 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977563;
commit;
# Time: 140117 16:53:13
# User@Host: nova[nova] @ [10.30.8.252]
# Query_time: 2.527001 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use nova;
SET timestamp=1389977593;
commit;
# User@Host: neutron[neutron] @ [10.30.8.252]
# Query_time: 2.380468 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use neutron;
SET timestamp=1389977593;
commit;
/usr/sbin/mysqld, Version: 5.5.34-0ubuntu0.12.04.1-log ((Ubuntu)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment