598473 - Add Android OS and Tegra slave data to Graphs SQL

Status: RESOLVED FIXED

(Release Engineering :: General, defect)

Description

[Mike Taylor [:bear]]

Android 2.2 and Tegra-001 added to data.sql

Comment 1

[Mike Taylor [:bear]]

Attachment: add Android 2.2 and Tegra slave entries to data.sql

Comment 2

[Mike Taylor [:bear]]

Attachment: add Android 2.2 and Tegra slave entries to data.sql

Comment 3

[alice nodelman [:alice] [:anode]]

Comment on attachment 477317 [details] [diff] [review]
add Android 2.2 and Tegra slave entries to data.sql

Android 2.2 will have os_id 20.

Also, for adding machines remember:
osid,isthrottling,cpuspeed,name,isactive,dateadded


In this case you are making these machines as having cpuspeed '1.0' - which seems a little weird to me.

Comment 4

[Mike Taylor [:bear]]

Attachment: add Android 2.2 and Tegra slave entries to data.sql

fixed the OS id to be 20

Alice - the Tegra's have a clock speed of 1.0

Comment 5

[Mike Taylor [:bear]]

Comment on attachment 477332 [details] [diff] [review]
add Android 2.2 and Tegra slave entries to data.sql

r+ from aki carried over per aki

Comment 6

[alice nodelman [:alice] [:anode]]

Patch applied to graphs-stage.

mysql> insert into os_list values (NULL, "Android 2.2");
Query OK, 1 row affected (0.03 sec)

mysql> insert into machines values (NULL,20,0,1.0,"tegra-001",1,unix_timestamp());
Query OK, 1 row affected (0.00 sec)

mysql> insert into machines values (NULL,20,0,1.0,"tegra-002",1,unix_timestamp());
Query OK, 1 row affected (0.01 sec)

mysql> insert into machines values (NULL,20,0,1.0,"tegra-003",1,unix_timestamp());
Query OK, 1 row affected (0.01 sec)

Comment 7

[Aki Sasaki (not active)]

Comment on attachment 477332 [details] [diff] [review]
add Android 2.2 and Tegra slave entries to data.sql

http://hg.mozilla.org/graphs/rev/c5e5db998a1b

Requested adding to graphs.m.o in bug 603394.

Comment 8

[Mike Taylor [:bear]]

marking as closed - sql changes landed in bug 603394 and we have activity in production