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, <[email protected]> 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: > > <cache name="Nordic_sqlite" type="sqlite3"> > <dbfile>/data/mapcache/{grid}/{tileset}/{z}/{x}-{y}.sqlite3</dbfile> > <xcount>10000</xcount> > <ycount>10000</ycount> > <pragma name="max_page_count">1573741823</pragma> > </cache> > > 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" <[email protected] > <[email protected]?to=%22yves%20jacolin%22%20%[email protected]%3E>> > wrote: > > Here a short tuto from my personal notes: > 1. create a cache entry in your mapcache file > > <cache name="mbtiles" type="sqlite3"> > <dbfile>/var/www/osm_google.db</dbfile> </cache> > > 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 < > [email protected]> 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 > [email protected] > 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 : [email protected] > http://www.camptocamp.com > > > > _______________________________________________ > mapserver-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
