Replying to myself here...
There seems to be a bug in the maxinstances function in the ROMA map.fcgi.
Setting $maxinstances higher than 9 will result in only the first digit being
considered. So if $maxinstances is 10, it will effectively be 1 - if
$maxinstances=20, then 2 - etc.
Changing line 482 from "if (numinstances() gt $maxinstances) {" to "if
(numinstances() > $maxinstances) {" seems to fix the problem.
-Jeremy
----- Original Message -----
From: Milenko
To: Justin
Cc: TilesAtHome
Sent: Tuesday, December 02, 2008 10:08 PM
Subject: Re: [Tilesathome] Two new ROMA...
Thanks for the tip - that certainly did the trick. I ran a couple requests
through and got sub-10 seconds on each request.
That's a tip that should be documented on the wiki. :)
Thanks again,
Jeremy
----- Original Message -----
From: Justin
To: Milenko
Cc: TilesAtHome
Sent: Tuesday, December 02, 2008 8:15 PM
Subject: Re: [Tilesathome] Two new ROMA...
I run the frdrmd/hades box-- mat runs the load balancer along with his two
romas. I ran into similar issues such as yours with speeds-- you need to
create two more indexes on nodes_ways;
create index idx_ways_big on way_nodes using btree (way_id);
create index idx_nodes_big on way_nodes using btree (node_id);
(those usually take anywhere from 10-120 minutes to process)
As far as specs go, my roma is a really hacked together system; Core 2 Duo
E6400, 4GB ram, SW Raid0 across 7 random hard drives I had in the basement.
Phpsysinfo;
http://frdrmd.roma.osm.phyrefile.com/phpsysinfo/
And pretty munin graphs;
http://frdrmd.roma.osm.phyrefile.com/munin/
Let me know if the problem persists after adding the indexes.
-Justin / Quiky
On Tue, Dec 2, 2008 at 7:49 PM, Milenko <[EMAIL PROTECTED]> wrote:
Hi all,
First I wanted to say thanks to Mathieu providing these two servers for
client use. I'm sure they'll be a big help once they're in general use in
the stable client.
I have been attempting to bring my own ROMA server online as yet another
ROMA option (YAROMAO??), but I'm not seeing anything close to the same
performance as either of these two servers. I was wondering if you'd be
willing to share the specs of these servers and/or tweaks and tuning you
used to speed up postgresql so that I could compare with my server.
For the record, my server is a 2x 3.0 Ghz Xeon with 8GB RAM and 4x 150GB
Velociraptor drives in RAID0 on an LSI MegaRAID 8344ELP controller.
Bonnie++ shows block reads at 426MB/s and over 700 seeks/s.
While fetching bbox 37.221680,11.594560,37.397461,11.709906 I get data in
sub-30 seconds from your two servers while mine takes over 130 seconds.
I'll be the first to admit I'm not a pgsql admin, so there hasn't been
much
tweaking done to the config on my server.
Any help would be greatly appreciated.
-Jeremy
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Arnold
Sent: Monday, November 24, 2008 9:22 AM
To: TilesAtHome
Subject: [Tilesathome] Two new ROMA...
Hi,
I'm pleased to announce that there are now three ROMA servers, the new two
are located at frdrmd.roma.osm.phyrefile.com, api1.osm.absolight.net.
There may be some rough edges, but both have been serving a few clients
for
some time now.
There also is a haproxy (which may still need tuning, but, hey, can't know
that untill more people use it.) located on the last server, the simplest
way
to use it would be to put :
API_ROMA = http://api1.osm.absolight.net:8080/api/%v/map?bbox=%b
in your tilesAtHome.conf.
If you don't want to change that old ROMA url, you could do :
APIServers = ROMA2,API,ROMA,XAPI
API_ROMA2 = http://api1.osm.absolight.net:8080/api/%v/map?bbox=%b
which would let you keep a backup in case the haproxy goes down and the
main
API and the XAPI goes down too :-)
--
Mathieu Arnold
_______________________________________________
Tilesathome mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/tilesathome
_______________________________________________
Tilesathome mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/tilesathome
------------------------------------------------------------------------------
_______________________________________________
Tilesathome mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/tilesathome
_______________________________________________
Tilesathome mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/tilesathome
