...
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%'