Re: [mapserver-users] Mapcache instruction
I should have done some tests, but haven't had time that yet.
I feel that we have gained performance both in seeding and access.
But I haven't done any measurements.
My first goal was to have sqlite db files that were not to big and not to small.
It worked really good serving 16 zoom levels over the Nordic countries.
I guess this could be fine tuned even more.
/Lars Schylberg
September 20, 2018 3:18 PM, "Travis Kirstine" mailto:traviskirst...@gmail.com?to=%22Travis%20Kirstine%22%20)>
wrote:
Lars,
Sorry for the side questions
Is there any performance benefit (specifically seeding) in using the x/ycount
parameters?
Thanks
On Thu, 20 Sep 2018 at 08:24, mailto:lars.schylb...@blixtmail.se)> wrote:
I also ran into the problem of running out of i-nodes last year.
Here is the configuration I have with a sqlite cache:
/data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3
1
1
1573741823
I guess the pragma thing is described in the documentation.
xcount and ycount describes how much You want to store in each sqlite db file
before it creates a new db file.
mapcache is creating the db files automatically. So seeding a large area You
end up with many sqlite db files that all work together.
This has worked really good for our use case.
Lars Schylberg
September 20, 2018 1:24 PM, "Yves Jacolin" mailto:yves.jaco...@camptocamp.com?to=%22yves%20jacolin%22%20%3cyves.jaco...@camptocamp.com%3E)>
wrote:
Here a short tuto from my personal notes:
1. create a cache entry in your mapcache file
/var/www/osm_google.db
2. create a empty sqlite file
- run sqlite3
- run this commande inside sqlite3: ".save filename.db" (without ")
3. use this cache in your settings
You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies. Path
used in my example for cache block are for Unix like system, you should adapt
it for Windows : c:/
Y.
Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini
mailto:sebastiano.la...@buchanancomputing.co.uk)> a écrit :
Hi all,
We have a MapCache setup with “disk_cache” but we are running out of
Inodes when I try to seed the whole UK with projection 27700.
I was thinking to propose to my supervisor to use the “SQLite Caches”
but I don’t know how it works. Can someone guide me through the process of
setup MapCache with this type of cache? And if I need some dependency, we use
PostgreSQL in our server so I assume I need to install also MySQL.
I’ve already read the documentation but still I have doubt about the db
part, how to create the db and locate it. I never use SQLite, just PostgreSQL.
Regards;
Sebastiano. ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org (mailto:mapserver-users@lists.osgeo.org)
https://lists.osgeo.org/mailman/listinfo/mapserver-users
(https://lists.osgeo.org/mailman/listinfo/mapserver-users)
--
Training and support manager
Camptocamp
Bâtiment le Dauphin - 1er étage
18 rue du Lac Saint André
73382 Le Bourget-du Lac
Tel (France) : +33 4 58 48 20 43
Tel (Switzerland) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
email : yves.jaco...@camptocamp.com (mailto:yves.jaco...@camptocamp.com)
http://www.camptocamp.com (http://www.camptocamp.com)
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org (mailto:mapserver-users@lists.osgeo.org)
https://lists.osgeo.org/mailman/listinfo/mapserver-users
(https://lists.osgeo.org/mailman/listinfo/mapserver-users)
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapcache instruction
Lars,
Sorry for the side questions
Is there any performance benefit (specifically seeding) in using the
x/ycount parameters?
Thanks
On Thu, 20 Sep 2018 at 08:24, wrote:
> I also ran into the problem of running out of i-nodes last year.
>
> Here is the configuration I have with a sqlite cache:
>
>
> /data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3
> 1
> 1
> 1573741823
>
>
> I guess the pragma thing is described in the documentation.
> xcount and ycount describes how much You want to store in each sqlite db
> file before it creates a new db file.
> mapcache is creating the db files automatically. So seeding a large area
> You end up with many sqlite db files that all work together.
>
> This has worked really good for our use case.
>
> Lars Schylberg
>
>
> September 20, 2018 1:24 PM, "Yves Jacolin" >
> wrote:
>
> Here a short tuto from my personal notes:
> 1. create a cache entry in your mapcache file
>
>
> /var/www/osm_google.db
>
> 2. create a empty sqlite file
> - run sqlite3
> - run this commande inside sqlite3: ".save filename.db" (without ")
> 3. use this cache in your settings
> You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies.
> Path used in my example for cache block are for Unix like system, you
> should adapt it for Windows : c:/
> Y.
> Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini <
> sebastiano.la...@buchanancomputing.co.uk> a écrit :
>
> Hi all,
>
> We have a MapCache setup with “disk_cache” but we are running out of
> Inodes when I try to seed the whole UK with projection 27700.
>
> I was thinking to propose to my supervisor to use the “SQLite Caches” but
> I don’t know how it works. Can someone guide me through the process of
> setup MapCache with this type of cache? And if I need some dependency, we
> use PostgreSQL in our server so I assume I need to install also MySQL.
>
> I’ve already read the documentation but still I have doubt about the db
> part, how to create the db and locate it. I never use SQLite, just
> PostgreSQL.
>
> Regards;
>
> Sebastiano.
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> --
> Training and support manager
> Camptocamp
> Bâtiment le Dauphin - 1er étage
> 18 rue du Lac Saint André
> 73382 Le Bourget-du Lac
>
> Tel (France) : +33 4 58 48 20 43
> Tel (Switzerland) : +41 21 619 10 43
> Mob. : +33 6 18 75 42 21
>
> email : yves.jaco...@camptocamp.com
> http://www.camptocamp.com
>
>
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapcache instruction
I guess I was following the example in on this page:
https://mapserver.org/mapcache/caches.html
(https://mapserver.org/mapcache/caches.html)
It explains the naming.
Look under section: Using Multiple SQLite Database Files.
You don't need to worry about calling the database. Mapcache is doing that.
/Lars Schylberg
September 20, 2018 2:40 PM, "Sebastiano Laini"
mailto:sebastiano.la...@buchanancomputing.co.uk?to=%22Sebastiano%20Laini%22%20)>
wrote:
Thanks guys,
I will try to do it after I will recompile again Mapcache to use SQLite
as I compite it -DWITH_SQLITE=OFF
I suppose that I can also think about to split the db as we are
speaking about more than 10milion files.
How exactly do you call the database and how this code
/{grid}/{tileset}/{z}/{x}-{y} works?
Sebastiano
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org
(mailto:mapserver-users-boun...@lists.osgeo.org)] On Behalf Of
lars.schylb...@blixtmail.se (mailto:lars.schylb...@blixtmail.se)
Sent: 20 September 2018 13:13
To: mapserver-users mailto:mapserver-users@lists.osgeo.org)>
Subject: Re: [mapserver-users] Mapcache instruction
I also ran into the problem of running out of i-nodes last year.
Here is the configuration I have with a sqlite cache:
/data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3
1
1
1573741823
I guess the pragma thing is described in the documentation.
xcount and ycount describes how much You want to store in each sqlite db file
before it creates a new db file.
mapcache is creating the db files automatically. So seeding a large area You
end up with many sqlite db files that all work together.
This has worked really good for our use case.
Lars Schylberg
September 20, 2018 1:24 PM, "Yves Jacolin" mailto:yves.jaco...@camptocamp.com?to=%22yves%20jacolin%22%20%3cyves.jaco...@camptocamp.com%3e)>
wrote:
Here a short tuto from my personal notes:
1. create a cache entry in your mapcache file
/var/www/osm_google.db
2. create a empty sqlite file
- run sqlite3
- run this commande inside sqlite3: ".save filename.db" (without ")
3. use this cache in your settings
You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies.
Path used in my example for cache block are for Unix like system, you should
adapt it for Windows : c:/
Y.
Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini
mailto:sebastiano.la...@buchanancomputing.co.uk)> a écrit :
Hi all,
We have a MapCache setup with “disk_cache” but we are running out of
Inodes when I try to seed the whole UK with projection 27700.
I was thinking to propose to my supervisor to use the “SQLite Caches”
but I don’t know how it works. Can someone guide me through the process of
setup MapCache with this type of cache? And if I need some dependency, we use
PostgreSQL in our server so I assume I need to install also MySQL.
I’ve already read the documentation but still I have doubt about the db
part, how to create the db and locate it. I never use SQLite, just PostgreSQL.
Regards;
Sebastiano.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org (mailto:mapserver-users@lists.osgeo.org)
https://lists.osgeo.org/mailman/listinfo/mapserver-users
(https://lists.osgeo.org/mailman/listinfo/mapserver-users)
--
Training and support manager
Camptocamp
Bâtiment le Dauphin - 1er étage
18 rue du Lac Saint André
73382 Le Bourget-du Lac
Tel (France) : +33 4 58 48 20 43
Tel (Switzerland) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
email : yves.jaco...@camptocamp.com (mailto:yves.jaco...@camptocamp.com)
http://www.camptocamp.com (http://www.camptocamp.com)
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapcache instruction
Thanks guys,
I will try to do it after I will recompile again Mapcache to use SQLite as I
compite it -DWITH_SQLITE=OFF \
I suppose that I can also think about to split the db as we are speaking about
more than 10milion files.
How exactly do you call the database and how this code
/{grid}/{tileset}/{z}/{x}-{y} works?
Sebastiano
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On
Behalf Of lars.schylb...@blixtmail.se
Sent: 20 September 2018 13:13
To: mapserver-users
Subject: Re: [mapserver-users] Mapcache instruction
I also ran into the problem of running out of i-nodes last year.
Here is the configuration I have with a sqlite cache:
/data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3
1
1
1573741823
I guess the pragma thing is described in the documentation.
xcount and ycount describes how much You want to store in each sqlite db file
before it creates a new db file.
mapcache is creating the db files automatically. So seeding a large area You
end up with many sqlite db files that all work together.
This has worked really good for our use case.
Lars Schylberg
September 20, 2018 1:24 PM, "Yves Jacolin"
mailto:yves.jaco...@camptocamp.com?to=%22yves%20jacolin%22%20%3cyves.jaco...@camptocamp.com%3e>>
wrote:
Here a short tuto from my personal notes:
1. create a cache entry in your mapcache file
/var/www/osm_google.db
2. create a empty sqlite file
- run sqlite3
- run this commande inside sqlite3: ".save filename.db" (without ")
3. use this cache in your settings
You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies. Path
used in my example for cache block are for Unix like system, you should adapt
it for Windows : c:/
Y.
Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini
mailto:sebastiano.la...@buchanancomputing.co.uk>>
a écrit :
Hi all,
We have a MapCache setup with “disk_cache” but we are running out of Inodes
when I try to seed the whole UK with projection 27700.
I was thinking to propose to my supervisor to use the “SQLite Caches” but I
don’t know how it works. Can someone guide me through the process of setup
MapCache with this type of cache? And if I need some dependency, we use
PostgreSQL in our server so I assume I need to install also MySQL.
I’ve already read the documentation but still I have doubt about the db part,
how to create the db and locate it. I never use SQLite, just PostgreSQL.
Regards;
Sebastiano.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Training and support manager
Camptocamp
Bâtiment le Dauphin - 1er étage
18 rue du Lac Saint André
73382 Le Bourget-du Lac
Tel (France) : +33 4 58 48 20 43
Tel (Switzerland) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
email : yves.jaco...@camptocamp.com
http://www.camptocamp.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapcache instruction
Lars,
Why did you use {z}/{x}-{y} in the filename?
I was probably wrong when I tell to create the sqlite file, this is true
for mbtiles though.
Y.
Le jeu. 20 sept. 2018 à 14:24, a écrit :
> I also ran into the problem of running out of i-nodes last year.
>
> Here is the configuration I have with a sqlite cache:
>
>
> /data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3
> 1
> 1
> 1573741823
>
>
> I guess the pragma thing is described in the documentation.
> xcount and ycount describes how much You want to store in each sqlite db
> file before it creates a new db file.
> mapcache is creating the db files automatically. So seeding a large area
> You end up with many sqlite db files that all work together.
>
> This has worked really good for our use case.
>
> Lars Schylberg
>
>
> September 20, 2018 1:24 PM, "Yves Jacolin" >
> wrote:
>
> Here a short tuto from my personal notes:
> 1. create a cache entry in your mapcache file
>
>
> /var/www/osm_google.db
>
> 2. create a empty sqlite file
> - run sqlite3
> - run this commande inside sqlite3: ".save filename.db" (without ")
> 3. use this cache in your settings
> You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies.
> Path used in my example for cache block are for Unix like system, you
> should adapt it for Windows : c:/
> Y.
> Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini <
> sebastiano.la...@buchanancomputing.co.uk> a écrit :
>
> Hi all,
>
> We have a MapCache setup with “disk_cache” but we are running out of
> Inodes when I try to seed the whole UK with projection 27700.
>
> I was thinking to propose to my supervisor to use the “SQLite Caches” but
> I don’t know how it works. Can someone guide me through the process of
> setup MapCache with this type of cache? And if I need some dependency, we
> use PostgreSQL in our server so I assume I need to install also MySQL.
>
> I’ve already read the documentation but still I have doubt about the db
> part, how to create the db and locate it. I never use SQLite, just
> PostgreSQL.
>
> Regards;
>
> Sebastiano.
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> --
> Training and support manager
> Camptocamp
> Bâtiment le Dauphin - 1er étage
> 18 rue du Lac Saint André
> 73382 Le Bourget-du Lac
>
> Tel (France) : +33 4 58 48 20 43
> Tel (Switzerland) : +41 21 619 10 43
> Mob. : +33 6 18 75 42 21
>
> email : yves.jaco...@camptocamp.com
> http://www.camptocamp.com
>
>
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Training and support manager
Camptocamp
Bâtiment le Dauphin - 1er étage
18 rue du Lac Saint André
73382 Le Bourget-du Lac
Tel (France) : +33 4 58 48 20 43
Tel (Switzerland) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
email : yves.jaco...@camptocamp.com
http://www.camptocamp.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapcache instruction
I also ran into the problem of running out of i-nodes last year.
Here is the configuration I have with a sqlite cache:
/data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3
1
1
1573741823
I guess the pragma thing is described in the documentation.
xcount and ycount describes how much You want to store in each sqlite db file
before it creates a new db file.
mapcache is creating the db files automatically. So seeding a large area You
end up with many sqlite db files that all work together.
This has worked really good for our use case.
Lars Schylberg
September 20, 2018 1:24 PM, "Yves Jacolin" mailto:yves.jaco...@camptocamp.com?to=%22Yves%20Jacolin%22%20)>
wrote:
Here a short tuto from my personal notes:
1. create a cache entry in your mapcache file
/var/www/osm_google.db
2. create a empty sqlite file
- run sqlite3
- run this commande inside sqlite3: ".save filename.db" (without ")
3. use this cache in your settings
You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies. Path
used in my example for cache block are for Unix like system, you should adapt
it for Windows : c:/
Y.
Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini
mailto:sebastiano.la...@buchanancomputing.co.uk)> a écrit :
Hi all,
We have a MapCache setup with “disk_cache” but we are running out of
Inodes when I try to seed the whole UK with projection 27700.
I was thinking to propose to my supervisor to use the “SQLite Caches”
but I don’t know how it works. Can someone guide me through the process of
setup MapCache with this type of cache? And if I need some dependency, we use
PostgreSQL in our server so I assume I need to install also MySQL.
I’ve already read the documentation but still I have doubt about the db
part, how to create the db and locate it. I never use SQLite, just PostgreSQL.
Regards;
Sebastiano. ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org (mailto:mapserver-users@lists.osgeo.org)
https://lists.osgeo.org/mailman/listinfo/mapserver-users
(https://lists.osgeo.org/mailman/listinfo/mapserver-users)
--
Training and support manager
Camptocamp
Bâtiment le Dauphin - 1er étage
18 rue du Lac Saint André
73382 Le Bourget-du Lac
Tel (France) : +33 4 58 48 20 43
Tel (Switzerland) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21
email : yves.jaco...@camptocamp.com (mailto:yves.jaco...@camptocamp.com)
http://www.camptocamp.com (http://www.camptocamp.com)
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapcache instruction
disk should also be changed to mbtiles in your example. Note that "mbtiles" is not the best name (I copy pasted my example)! You can find a better name :) And yes except that you need to create the db file (as you should create a database postgresql before to use it) all other command are similar. Y. PS : please keep reply to the list :) Le jeu. 20 sept. 2018 à 13:44, Sebastiano Laini < sebastiano.la...@buchanancomputing.co.uk> a écrit : > I see, so I just need to replace this code: > > > > > > /var/www/vhosts/buchananmapping.co.uk/httpdocs/maps/cache > > > > > > > > Whith this: > > > > > > /var/www/osm_google.db > > > > > > And then used my code as usual? (changing the cache that I call in the > tileset) > > > > > > > > > > image/jpeg > > miniscale > > /var/www/vhosts/DOMAIN/maps.map > > > > > > > > URL/cgi-bin/mapserv? > > > > > > > > > > Mymaps > > disk > > Mygrid > > JPEG > > 4 4 > > 0 > > 31536000 > > > > > > > > > > this is a custom grid > > > >EPSG:27700 > >128 128 > >0 0 70 125 > >70 28 14 7 6.16 2.8 1.4 0.7 0.28 0.14 > 0.07 > > > > > > The request is going to be the same or is changing? > > > > An example of my actual request is this one: > > > > > URL/mapcache/?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image%2Fpng&TRANSPARENT=true&LAYERS=Mycache&TILED=true&WIDTH=128&HEIGHT=128&CRS=EPSG%3A27700&STYLES=&BBOX=465920%2C174800%2C501760%2C210640 > > > > Is created through OpenLayers 4, I sent the cords “BBOX” and the cache > name “LAYERS=Mycache” > > > > Sebastiano. > > > > *From:* Yves Jacolin [mailto:yves.jaco...@camptocamp.com] > *Sent:* 20 September 2018 12:24 > *To:* Sebastiano Laini > *Cc:* mapserver-users > *Subject:* Re: [mapserver-users] Mapcache instruction > > > > Here a short tuto from my personal notes: > > > > 1. create a cache entry in your mapcache file > > > > /var/www/osm_google.db > > > > 2. create a empty sqlite file > > - run sqlite3 > > - run this commande inside sqlite3: ".save filename.db" (without ") > > 3. use this cache in your settings > > > > You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies. > Path used in my example for cache block are for Unix like system, you > should adapt it for Windows : c:/ > > > > Y. > > > > Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini < > sebastiano.la...@buchanancomputing.co.uk> a écrit : > > Hi all, > > > > We have a MapCache setup with “disk_cache” but we are running out of > Inodes when I try to seed the whole UK with projection 27700. > > > > I was thinking to propose to my supervisor to use the “SQLite Caches” but > I don’t know how it works. Can someone guide me through the process of > setup MapCache with this type of cache? And if I need some dependency, we > use PostgreSQL in our server so I assume I need to install also MySQL. > > > > I’ve already read the documentation but still I have doubt about the db > part, how to create the db and locate it. I never use SQLite, just > PostgreSQL. > > > > Regards; > > > > Sebastiano. > > > > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > -- > > Training and support manager > Camptocamp > Bâtiment le Dauphin - 1er étage > 18 rue du Lac Saint André > 73382 Le Bourget-du Lac > > Tel (France) : +33 4 58 48 20 43 > Tel (Switzerland) : +41 21 619 10 43 > Mob. : +33 6 18 75 42 21 > > email : yves.jaco...@camptocamp.com > http://www.camptocamp.com > -- Training and support manager Camptocamp Bâtiment le Dauphin - 1er étage 18 rue du Lac Saint André 73382 Le Bourget-du Lac Tel (France) : +33 4 58 48 20 43 Tel (Switzerland) : +41 21 619 10 43 Mob. : +33 6 18 75 42 21 email : yves.jaco...@camptocamp.com http://www.camptocamp.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapcache instruction
Here a short tuto from my personal notes: 1. create a cache entry in your mapcache file /var/www/osm_google.db 2. create a empty sqlite file - run sqlite3 - run this commande inside sqlite3: ".save filename.db" (without ") 3. use this cache in your settings You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies. Path used in my example for cache block are for Unix like system, you should adapt it for Windows : c:/ Y. Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini < sebastiano.la...@buchanancomputing.co.uk> a écrit : > Hi all, > > > > We have a MapCache setup with “disk_cache” but we are running out of > Inodes when I try to seed the whole UK with projection 27700. > > > > I was thinking to propose to my supervisor to use the “SQLite Caches” but > I don’t know how it works. Can someone guide me through the process of > setup MapCache with this type of cache? And if I need some dependency, we > use PostgreSQL in our server so I assume I need to install also MySQL. > > > > I’ve already read the documentation but still I have doubt about the db > part, how to create the db and locate it. I never use SQLite, just > PostgreSQL. > > > > Regards; > > > > Sebastiano. > > > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapserver-users -- Training and support manager Camptocamp Bâtiment le Dauphin - 1er étage 18 rue du Lac Saint André 73382 Le Bourget-du Lac Tel (France) : +33 4 58 48 20 43 Tel (Switzerland) : +41 21 619 10 43 Mob. : +33 6 18 75 42 21 email : yves.jaco...@camptocamp.com http://www.camptocamp.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapcache instruction
Hi all, We have a MapCache setup with "disk_cache" but we are running out of Inodes when I try to seed the whole UK with projection 27700. I was thinking to propose to my supervisor to use the "SQLite Caches" but I don't know how it works. Can someone guide me through the process of setup MapCache with this type of cache? And if I need some dependency, we use PostgreSQL in our server so I assume I need to install also MySQL. I've already read the documentation but still I have doubt about the db part, how to create the db and locate it. I never use SQLite, just PostgreSQL. Regards; Sebastiano. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
