Lots of Sqlite Writes

It crashed, it is bugged, ...

Lots of Sqlite Writes

Postby nhouck » Thu Apr 01, 2010 8:46 pm

I have a bunch of murmur servers running on Windows and each of them is doing an insane amount of writes to the sqlite database and journal files. All together it adds up to something like 30MB/s of data being written to the sqlite files. This is bogging down the server.

I'm curious what murmur could possibly be writing so much to the database, and more importantly how can I disable all these writes?

I have tried these settings to no avail:

logdays=0
logdays=1
logdays=

Thanks.

Noel
nhouck
 
Posts: 3
Joined: Thu Oct 22, 2009 5:45 am

Re: Lots of Sqlite Writes

Postby ipnoz » Wed Apr 07, 2010 1:49 pm

Murmur store users avatars and comments in the db, so I'm pretty sur it's come from it.
ipnoz
 
Posts: 2
Joined: Tue Feb 09, 2010 10:16 pm

Re: Lots of Sqlite Writes

Postby hacst » Thu Apr 08, 2010 11:17 am

If these are independent processes instead of virtual server instances the database will have no write consolidation at all. Still 30MB/s sounds pretty extreme. How many servers with what kind of traffic are we talking about?
hacst
Team member
Team member
 
Posts: 339
Joined: Wed Sep 23, 2009 4:28 pm

Re: Lots of Sqlite Writes

Postby nhouck » Mon Apr 12, 2010 1:36 am

There is about 150 servers with about 20-30 of them with activity which is comprising the bulk of the writes. I have noticed that rebooting the server seems to bring down the amount of writes so it seems to build up over time which would maybe point to some error logging or something, however the text log is not showing anything near that amount of disk activity.
nhouck
 
Posts: 3
Joined: Thu Oct 22, 2009 5:45 am


Return to Technical

Who is online

Users browsing this forum: No registered users and 4 guests

cron