Hello, I moved with my Wikipedia coordinate extraction project Wikipedia-World: http://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Georeferenzierung/Wikiped... from Mysql to PostGIS on ptolemy.
The most advantage is that it is much faster and really support all 273 languages. I have 3 tables for different zoomlevels and use a geometry index (gist). I use coordinates-database from dispenser and merge the entries with the interwikilinks to one table.
I support the parameter "title" and can so extract more than one coordinate per article. Everybody on ptolemy should have access to the database u_kolossos.
I hope ptolemy will be stable over the next few days because I want to publish the tool to the german community. I would be happy if somebody else make a announcement to the other wikipedia communities.
Greetings Kolossos
This is cool. Is there currently a per user connection limit? I would like to use this database for the WikiMiniAtlas for the smaller languages. Last time I tried this with the mysql db, I saturated Kolossos connection limit :-(
I don't know the actually connection limit but as long you use your own script to connect my u_kolossos database you shouldn't effect my connection limit.
If it runs good a query need in the moment 0.02-0.2 sec so we shouldn't get a problem that we get more requests than we can handle. One problem in the past was the necessary JOIN for the smaller languages.
Off course, we should have a system to stabilize ptolemy especially if more and more maps are coming.
Greetings Kolossos
Daniel Schwen schrieb:
This is cool. Is there currently a per user connection limit? I would like to use this database for the WikiMiniAtlas for the smaller languages. Last time I tried this with the mysql db, I saturated Kolossos connection limit :-(
Maps-l mailing list Maps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/maps-l
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Tim Alder:
Off course, we should have a system to stabilize ptolemy especially if more and more maps are coming.
What do you mean by this?
- river.
I hear that cassini was running in the last time with a loadlevel of 29 or so and was near to death...
Especially prerendering of tiles seems a critical thing, but also looking for and updating of dirty-tiles in low zoom levels seems critical. Also on the FOSSGIS-Tools-Server it seems not easy to find the perfect balance between all tools.
In my eyes it could help to have a connection limit for each map style to stabilize the system. But also my Wikipedia-coordinates and especially Query-to-map-project should have a connection-limit and a time-out so that I don't kill all other tools.
We should compare the benefit and the costs of each project on this server and set than a specific connection level. For this we need an overview over existing projects.
What are the costs we accept for one tile?
So I'm absolutly no expert for things like that but we should look at it. Some effects will be well known from normal toolserver some effect will be specific for maps-toolserver.
Greetings Kolossos
River Tarnell schrieb:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Tim Alder:
Off course, we should have a system to stabilize ptolemy especially if more and more maps are coming.
What do you mean by this?
- river.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (HP-UX)
iEUEARECAAYFAkv0UnYACgkQIXd7fCuc5vKLMgCgkVZ3adFYCmR+my8EHrYpu7OB dHMAmPm/VsovXRwJmpz3ukD/EFlH/Go= =yG2c -----END PGP SIGNATURE-----
Maps-l mailing list Maps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/maps-l
Tim Alder schrieb:
I hear that cassini was running in the last time with a loadlevel of 29 or so and was near to death...
I think cmarq rendered his static hillshading tiles on cassini during this period. Atm. ptolemys load is <1 so nothing to worry about.
Especially prerendering of tiles seems a critical thing, but also looking for and updating of dirty-tiles in low zoom levels seems critical. Also on the FOSSGIS-Tools-Server it seems not easy to find the perfect balance between all tools.
We're not expiring anything at the moment but you're right, this is a critical thing.
Peter