Gidgidonihah
06-26-2007, 04:54 PM
once or twice every couple of days I get CPU exceeded errors. looking at the logs, it seems to be HLstatsX queries that take a long time.
--------------------------------------------------------------------------------
CPU Exceeded Log For Mon Jun 25 12:03:25 2007
Mon Jun 25 11:59:19 2007: used 0.11 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /product_reviews.php?products_id=173 HTTP/1.0
Mon Jun 25 11:59:35 2007: used 0.07 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&aliases_sort=name&aliases_sortorder=desc&weap_sort=smshots&weap_sortorder=desc HTTP/1.1
Mon Jun 25 12:00:23 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=293 HTTP/1.0
Mon Jun 25 12:02:12 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&aliases_sort=suicides&aliases_sortorder=desc&maps_sort=deaths&maps_sortorder=desc HTTP/1.1
Mon Jun 25 12:02:35 2007: used 14.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 12:03:12 2007: used 26.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 12:03:22 2007: used 0.10 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=2941&weap_sort=modifier&weap_sortorder=desc&obj_sort=obj_bonus&obj_sortorder=desc&playerkills_sort=name&playerkills_sortorder=desc HTTP/1.0
--------------------------------------------------------------------------------
CPU Exceeded Log For Mon Jun 25 16:22:57 2007
Mon Jun 25 16:18:04 2007: used 0.12 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /index.php?cPath=28 HTTP/1.0
Mon Jun 25 16:18:34 2007: used 0.08 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=291&weap_sort=smhits&weap_sortorder=desc HTTP/1.0
Mon Jun 25 16:19:35 2007: used 0.07 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=172&weap_sort=smkdr&weap_sortorder=desc HTTP/1.0
Mon Jun 25 16:20:33 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=263 HTTP/1.0
Mon Jun 25 16:22:51 2007: used 24.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 16:22:27 2007: used 0.05 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&aliases_sort=deaths&aliases_sortorder=desc&weap_sort=modifier&weap_sortorder=desc HTTP/1.1
Mon Jun 25 16:22:25 2007: used 16.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 16:22:53 2007: used 0.03 seconds of cpu time for HTTP Request: gid.rata.com : GET /portfolio/byurentals/ HTTP/1.1
Mon Jun 25 16:19:07 2007: used 0.08 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&weap_sort=smweapon&weap_sortorder=desc&maps_sort=map&maps_sortorder=desc HTTP/1.1
--------------------------------------------------------------------------------
CPU Exceeded Log For Mon Jun 25 18:01:25 2007
Mon Jun 25 17:56:56 2007: used 0.11 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /index.php?cPath=35_41 HTTP/1.0
Mon Jun 25 17:57:59 2007: used 0.44 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&weap_sort=smweapon&weap_sortorder=desc&aliases_sort=acc&aliases_sortorder=desc HTTP/1.1
Mon Jun 25 17:58:17 2007: used 2.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:58:34 2007: used 2.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:59:28 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=291&weap_sort=modifier&weap_sortorder=desc HTTP/1.0
Mon Jun 25 18:00:00 2007: used 8.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 18:00:42 2007: used 0.05 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=admin&task=tools_editdetails_player&id=172 HTTP/1.0
Mon Jun 25 18:00:41 2007: used 22.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 18:01:18 2007: used 21.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 18:01:20 2007: used 0.05 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&weap_sort=smaccuracy&weap_sortorder=desc&aliases_sort=connection_time&aliases_sortorder=desc HTTP/1.1
Mon Jun 25 17:58:32 2007: used 2.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:58:30 2007: used 3.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:59:24 2007: used 0.09 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /product_reviews.php?products_id=38 HTTP/1.0
Does anyone have any experience with this or would I have better luck at the HLstatsX site, which in past experience, is no help at all.
Also, how might I find out exactly which query is taking the long time?
--------------------------------------------------------------------------------
CPU Exceeded Log For Mon Jun 25 12:03:25 2007
Mon Jun 25 11:59:19 2007: used 0.11 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /product_reviews.php?products_id=173 HTTP/1.0
Mon Jun 25 11:59:35 2007: used 0.07 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&aliases_sort=name&aliases_sortorder=desc&weap_sort=smshots&weap_sortorder=desc HTTP/1.1
Mon Jun 25 12:00:23 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=293 HTTP/1.0
Mon Jun 25 12:02:12 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&aliases_sort=suicides&aliases_sortorder=desc&maps_sort=deaths&maps_sortorder=desc HTTP/1.1
Mon Jun 25 12:02:35 2007: used 14.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 12:03:12 2007: used 26.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 12:03:22 2007: used 0.10 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=2941&weap_sort=modifier&weap_sortorder=desc&obj_sort=obj_bonus&obj_sortorder=desc&playerkills_sort=name&playerkills_sortorder=desc HTTP/1.0
--------------------------------------------------------------------------------
CPU Exceeded Log For Mon Jun 25 16:22:57 2007
Mon Jun 25 16:18:04 2007: used 0.12 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /index.php?cPath=28 HTTP/1.0
Mon Jun 25 16:18:34 2007: used 0.08 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=291&weap_sort=smhits&weap_sortorder=desc HTTP/1.0
Mon Jun 25 16:19:35 2007: used 0.07 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=172&weap_sort=smkdr&weap_sortorder=desc HTTP/1.0
Mon Jun 25 16:20:33 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=263 HTTP/1.0
Mon Jun 25 16:22:51 2007: used 24.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 16:22:27 2007: used 0.05 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&aliases_sort=deaths&aliases_sortorder=desc&weap_sort=modifier&weap_sortorder=desc HTTP/1.1
Mon Jun 25 16:22:25 2007: used 16.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 16:22:53 2007: used 0.03 seconds of cpu time for HTTP Request: gid.rata.com : GET /portfolio/byurentals/ HTTP/1.1
Mon Jun 25 16:19:07 2007: used 0.08 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&weap_sort=smweapon&weap_sortorder=desc&maps_sort=map&maps_sortorder=desc HTTP/1.1
--------------------------------------------------------------------------------
CPU Exceeded Log For Mon Jun 25 18:01:25 2007
Mon Jun 25 17:56:56 2007: used 0.11 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /index.php?cPath=35_41 HTTP/1.0
Mon Jun 25 17:57:59 2007: used 0.44 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&weap_sort=smweapon&weap_sortorder=desc&aliases_sort=acc&aliases_sortorder=desc HTTP/1.1
Mon Jun 25 17:58:17 2007: used 2.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:58:34 2007: used 2.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:59:28 2007: used 0.09 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=291&weap_sort=modifier&weap_sortorder=desc HTTP/1.0
Mon Jun 25 18:00:00 2007: used 8.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 18:00:42 2007: used 0.05 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=admin&task=tools_editdetails_player&id=172 HTTP/1.0
Mon Jun 25 18:00:41 2007: used 22.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 18:01:18 2007: used 21.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 18:01:20 2007: used 0.05 seconds of cpu time for HTTP Request: gid.rata.com : GET /opg/hlstats.php?mode=playerinfo&player=800&weap_sort=smaccuracy&weap_sortorder=desc&aliases_sort=connection_time&aliases_sortorder=desc HTTP/1.1
Mon Jun 25 17:58:32 2007: used 2.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:58:30 2007: used 3.00 seconds of cpu time for [[mysql query]]
Mon Jun 25 17:59:24 2007: used 0.09 seconds of cpu time for HTTP Request: www.buyldsproducts.com : GET /product_reviews.php?products_id=38 HTTP/1.0
Does anyone have any experience with this or would I have better luck at the HLstatsX site, which in past experience, is no help at all.
Also, how might I find out exactly which query is taking the long time?