[OSM-dev] Performance problems?
claudomiro.n.junior at jpmchase.com
claudomiro.n.junior at jpmchase.com
Thu Feb 15 18:08:58 GMT 2007
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?
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070215/4e29939c/attachment.html>
More information about the dev
mailing list