...

     ssl.ca-file                 = "/etc/lighttpd/certs/chain.pem"

 }

Metashare logimise probleemid

Metasharel on probleemid logide pärimisega. Peamine probleem on selles, et päringud teisendavad kuupäeva tekstiks ja seetõttu ei rakendata indekseid.

Probleemsed päringud

SELECT COUNT(*) FROM "stats_querystats" WHERE ("stats_querystats"."lasttime"::text LIKE '2013-03-01%'  AND "stats_querystats"."exectime" < 4163

SELECT AVG("stats_querystats"."exectime") AS "exectime__avg", MIN("stats_querystats"."exectime") AS "exectime__min", MAX("stats_querystats"."exectime") AS "exectime__max" FROM "stats_querystats" WHERE "stats_querystats"."lasttime"::text LIKE '2013-02-11%'