[OSM-dev] Performance problems?

claudomiro.n.junior at jpmchase.com claudomiro.n.junior at jpmchase.com
Fri Feb 16 20:17:06 GMT 2007


SteveC <steve at asklater.com> wrote
> 
> No, no such process exists server-side.
> 

Well, intermittent load on the server was my first guess, but it can be 
network-related. Fact is, I can reproduce the problem from two access 
points (home and work) and when using the same httpclient version and 
setup I could not observe the problem accessing other addresses. 

I will keep you guys posted on any findings over this "elusive" issue.

cheers





SteveC <steve at asklater.com> 
15/02/2007 17:24

To
claudomiro.n.junior at jpmchase.com
cc
dev at openstreetmap.org
Subject
Re: [OSM-dev] Performance problems?








claudomiro.n.junior at jpmchase.com wrote:
> 
> Hi,
> 
> I'm using the Yahoo Applet for editing and most of requests to the API 
> server are fullfiled quickly (in less than 1 second). But aproximately 
> every 5 minutes the response time raises dramatically to 20, 50 and even 

> 100+ secs as seen in the log bellow.
> 
> It seems that a schedulled proccess is locking the database or consuming 

> all available resources. Could someone check on this?

No, no such process exists server-side.

> 
> thanks
> 
> 
> 
================================================================================ 

> 
> 15:20:32,006 org.openstreetmap.client.Adapter - OSM data downloaded in 
>  5,028ms
> 15:20:53,930 org.openstreetmap.client.Adapter - Command request done in 
>     792ms
> 15:20:54,931 org.openstreetmap.client.Adapter - Command request done in 
>     801ms
> 15:20:57,495 org.openstreetmap.client.Adapter - Command request done in 
>     791ms
> 15:20:59,388 org.openstreetmap.client.Adapter - Command request done in 
>   1,032ms
> 15:21:00,389 org.openstreetmap.client.Adapter - Command request done in 
>     791ms
> 15:21:01,441 org.openstreetmap.client.Adapter - Command request done in 
>     821ms
> 15:21:03,364 org.openstreetmap.client.Adapter - Command request done in 
>   1,352ms
> 15:21:04,686 org.openstreetmap.client.Adapter - Command request done in 
>   1,312ms
> 15:21:12,568 org.openstreetmap.client.Adapter - Command request done in 
>   1,943ms
> 15:21:13,339 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:21:14,211 org.openstreetmap.client.Adapter - Command request done in 
>     862ms
> 15:21:15,032 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:21:16,885 org.openstreetmap.client.Adapter - Command request done in 
>     832ms
> 15:21:18,096 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:21:19,138 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:21:21,642 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:23:22,967 org.openstreetmap.client.Adapter - OSM data downloaded in 
>  105,030ms
> 15:26:15,090 org.openstreetmap.client.Adapter - Command request done in 
>  45,750ms
> 15:27:11,901 org.openstreetmap.client.Adapter - Command request done in 
>  56,811ms
> 15:27:13,592 org.openstreetmap.client.Adapter - Command request done in 
>   1,691ms
> 15:27:42,546 org.openstreetmap.client.Adapter - Command request done in 
>     900ms
> 15:27:48,587 org.openstreetmap.client.Adapter - Command request done in 
>     851ms
> 15:27:52,517 org.openstreetmap.client.Adapter - Command request done in 
>     830ms
> 15:27:54,547 org.openstreetmap.client.Adapter - Command request done in 
>     820ms
> 15:28:53,526 org.openstreetmap.client.Adapter - Command request done in 
>  53,988ms
> 15:28:56,026 org.openstreetmap.client.Adapter - Command request done in 
>   1,700ms
> 15:29:08,928 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    840ms
> 15:29:29,691 org.openstreetmap.client.Adapter - Command request done in 
>     780ms
> 15:29:38,452 org.openstreetmap.client.Adapter - Command request done in 
>     780ms
> 15:29:58,705 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    940ms
> 15:30:16,517 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    880ms
> 15:30:26,329 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    870ms
> 15:30:52,792 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    820ms
> 15:31:35,452 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    841ms
> 15:31:46,926 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    801ms
> 15:41:29,531 org.openstreetmap.client.Adapter - Command request done in 
> 115,744ms
> 15:41:30,362 org.openstreetmap.client.Adapter - Command request done in 
>     831ms
> 15:41:36,699 org.openstreetmap.client.Adapter - Command request done in 
>   6,337ms
> 15:41:37,640 org.openstreetmap.client.Adapter - Command request done in 
>     941ms
> 15:41:38,491 org.openstreetmap.client.Adapter - Command request done in 
>     841ms
> 15:41:39,262 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:43:05,572 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    821ms
> 15:43:22,101 org.openstreetmap.client.Adapter - Command request done in 
>     861ms
> 15:43:22,882 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:43:23,713 org.openstreetmap.client.Adapter - Command request done in 
>     811ms
> 15:43:24,524 org.openstreetmap.client.Adapter - Command request done in 
>     791ms
> 15:43:25,375 org.openstreetmap.client.Adapter - Command request done in 
>     801ms
> 15:43:31,162 org.openstreetmap.client.Adapter - Command request done in 
>     761ms
> 15:43:31,953 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:43:32,743 org.openstreetmap.client.Adapter - Command request done in 
>     790ms
> 15:43:53,513 org.openstreetmap.client.Adapter - Command request done in 
>   8,848ms
> 15:43:54,285 org.openstreetmap.client.Adapter - Command request done in 
>     762ms
> 15:43:55,086 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:43:55,858 org.openstreetmap.client.Adapter - Command request done in 
>     772ms
> 15:44:04,085 org.openstreetmap.client.Adapter - Command request done in 
>   6,654ms
> 15:44:15,077 org.openstreetmap.client.Adapter - Command request done in 
>   9,930ms
> 15:44:15,969 org.openstreetmap.client.Adapter - Command request done in 
>     892ms
> 15:44:26,010 org.openstreetmap.client.Adapter - Command request done in 
>  10,021ms
> 15:46:02,236 org.openstreetmap.client.Adapter - OSM data downloaded in 
> 28,438ms
> 15:47:15,827 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    772ms
> 15:47:31,659 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    811ms
> 15:47:44,426 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    822ms
> 15:47:52,021 org.openstreetmap.client.Adapter - Command request done in 
>     812ms
> 15:47:55,368 org.openstreetmap.client.Adapter - Command request done in 
>     782ms
> 15:47:58,594 org.openstreetmap.client.Adapter - Command request done in 
>     831ms
> 15:48:13,254 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:48:26,241 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    982ms
> 15:48:51,651 org.openstreetmap.client.Adapter - Command request done in 
>     841ms
> 15:48:59,110 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:49:07,811 org.openstreetmap.client.Adapter - Command request done in 
>     801ms
> 15:49:13,428 org.openstreetmap.client.Adapter - Command request done in 
>     761ms
> 15:49:23,531 org.openstreetmap.client.Adapter - Command request done in 
>     811ms
> 15:49:28,367 org.openstreetmap.client.Adapter - Command request done in 
>     981ms
> 15:49:29,839 org.openstreetmap.client.Adapter - Command request done in 
>     811ms
> 15:49:34,274 org.openstreetmap.client.Adapter - Command request done in 
>     801ms
> 15:50:29,724 org.openstreetmap.client.Adapter - Command request done in 
>  54,709ms
> 15:50:39,787 org.openstreetmap.client.Adapter - Command request done in 
>  10,063ms
> 15:53:08,384 org.openstreetmap.client.Adapter - OSM data downloaded in 
> 25,102ms
> 15:53:41,666 org.openstreetmap.client.Adapter - OSM data downloaded in 
>  2,754ms
> 15:54:02,472 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    871ms
> 15:54:12,925 org.openstreetmap.client.Adapter - Command request done in 
>   3,134ms
> 15:54:13,696 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:54:14,487 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:54:23,679 org.openstreetmap.client.Adapter - Command request done in 
>   6,038ms
> 15:54:24,790 org.openstreetmap.client.Adapter - Command request done in 
>   1,111ms
> 15:54:25,821 org.openstreetmap.client.Adapter - Command request done in 
>   1,031ms
> 15:54:44,955 org.openstreetmap.client.Adapter - OSM data downloaded in 
>  1,632ms
> 15:54:56,500 org.openstreetmap.client.Adapter - Command request done in 
>   5,217ms
> 15:54:57,281 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:55:04,860 org.openstreetmap.client.Adapter - Command request done in 
>     791ms
> 15:55:07,944 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:55:09,566 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:55:11,419 org.openstreetmap.client.Adapter - Command request done in 
>     811ms
> 15:55:13,982 org.openstreetmap.client.Adapter - Command request done in 
>     791ms
> 15:55:14,763 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:55:15,564 org.openstreetmap.client.Adapter - Command request done in 
>     801ms
> 15:55:20,390 org.openstreetmap.client.Adapter - Command request done in 
>     871ms
> 15:55:21,712 org.openstreetmap.client.Adapter - Command request done in 
>     841ms
> 15:55:22,813 org.openstreetmap.client.Adapter - Command request done in 
>     871ms
> 15:55:24,285 org.openstreetmap.client.Adapter - Command request done in 
>     911ms
> 15:55:27,209 org.openstreetmap.client.Adapter - Command request done in 
>   1,612ms
> 15:55:28,720 org.openstreetmap.client.Adapter - Command request done in 
>     780ms
> 15:55:31,594 org.openstreetmap.client.Adapter - Command request done in 
>     761ms
> 15:55:44,270 org.openstreetmap.client.Adapter - OSM data downloaded in 
>    791ms
> 15:56:03,815 org.openstreetmap.client.Adapter - Command request done in 
>     811ms
> 15:56:05,066 org.openstreetmap.client.Adapter - Command request done in 
>     981ms
> 15:56:06,148 org.openstreetmap.client.Adapter - Command request done in 
>     831ms
> 15:56:07,159 org.openstreetmap.client.Adapter - Command request done in 
>     801ms
> 15:56:07,930 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:56:08,721 org.openstreetmap.client.Adapter - Command request done in 
>     791ms
> 15:56:16,961 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:56:18,203 org.openstreetmap.client.Adapter - Command request done in 
>     761ms
> 15:56:19,595 org.openstreetmap.client.Adapter - Command request done in 
>     781ms
> 15:56:24,441 org.openstreetmap.client.Adapter - Command request done in 
>   1,042ms
> 15:56:25,242 org.openstreetmap.client.Adapter - Command request done in 
>     761ms
> 15:56:26,033 org.openstreetmap.client.Adapter - Command request done in 
>     771ms
> 15:57:31,155 org.openstreetmap.client.Adapter - Command request done in 
>  61,388ms
> 15:58:27,515 org.openstreetmap.client.Adapter - Command request done in 
>  56,360ms
> 15:58:33,733 org.openstreetmap.client.Adapter - Command request done in 
>   6,208ms
> 15:58:34,544 org.openstreetmap.client.Adapter - Command request done in 
>     791ms
> 15:58:36,106 org.openstreetmap.client.Adapter - Command request done in 
>   1,542ms
> 15:58:36,927 org.openstreetmap.client.Adapter - Command request done in 
>     801ms
> 
> ------------------------------------------------------------------------
> 
> 
> 
> This transmission may contain information that is privileged,
> confidential, legally privileged, and/or exempt from disclosure
> under applicable law. If you are not the intended recipient, you
> are hereby notified that any disclosure, copying, distribution, or
> use of the information contained herein (including any reliance
> thereon) is STRICTLY PROHIBITED. Although this transmission and
> any attachments are believed to be free of any virus or other
> defect that might affect any computer system into which it is
> received and opened, it is the responsibility of the recipient to
> ensure that it is virus free and no responsibility is accepted by
> JPMorgan Chase & Co., its subsidiaries and affiliates, as
> applicable, for any loss or damage arising in any way from its use.
> If you received this transmission in error, please immediately
> contact the sender and destroy the material in its entirety,
> whether in electronic or hard copy format. Thank you.
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev

-- 
have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070216/13585499/attachment.html>


More information about the dev mailing list