Re: Query Takes Longer Each Time Its Run

[anthony]

Here is the header from the slowqeury log:

# Time: 110131 1:05:26
# User@Host: root[root] @ [67.169.164.195]
# Query_time: 8.269380 Lock_time: 0.000564 Rows_sent: 22 Rows_examined: 6602

6602 rows doesn't seem like much to me.

Here is the output of dstat while the query runs. user 25 is the query running:

----total-cpu-usage---- -dsk/total- -net/total- ---paging-- ---system--
usr sys idl wai hiq siq| read writ| recv send| in out | int csw
0 0 100 0 0 0| 0 0 | 186B 354B| 0 0 |1028 557
0 0 100 0 0 0| 0 0 | 66B 354B| 0 0 |1002 468
0 0 100 0 0 0| 0 0 | 66B 354B| 0 0 |1025 555
1 0 100 0 0 0| 0 0 |5348B 618B| 0 0 |1012 476
25 0 75 0 0 0| 0 0 | 126B 354B| 0 0 |1026 622
25 0 75 0 0 0| 0 0 | 126B 354B| 0 0 |1003 508
25 0 75 0 0 0| 0 0 | 66B 476B| 0 0 |1026 607
25 0 75 0 0 0| 0 0 | 126B 476B| 0 0 |1004 513
25 0 75 0 0 0| 0 0 | 126B 354B| 0 0 |1026 587
25 0 75 0 0 0| 0 0 | 126B 354B| 0 0 |1003 509
25 0 75 0 0 0| 0 0 | 126B 354B| 0 0 |1026 593
25 0 75 0 0 0| 0 0 | 66B 354B| 0 0 |1002 506
25 0 75 0 0 0| 0 0 | 66B 354B| 0 0 |1022 594
25 0 75 0 0 0| 0 0 | 126B 354B| 0 0 |1006 512
25 0 75 0 0 0| 0 0 | 126B 354B| 0 0 |1004 533
25 0 75 0 0 0| 0 0 | 366B 354B| 0 0 |1027 582
25 0 75 0 0 0| 0 0 | 66B 354B| 0 0 |1003 515
11 0 89 0 0 0| 0 0 | 396B 6751B| 0 0 |1031 579
0 0 100 0 0 0| 0 0 | 366B 354B| 0 0 |1006 467
0 0 100 0 0 0| 0 0 | 468B 354B| 0 0 |1026 537
0 0 100 0 0 0| 0 0 | 186B 354B| 0 0 |1005 468

Should I be putting together a test case at this point to report this?