Jump to content
Mumble forums

Lots of Sqlite Writes


nhouck
 Share

Recommended Posts

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

Link to comment
Share on other sites

  • Administrators

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...