Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[solved] Mysql/Amarok is filling up /var/lib/mysql
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Multimedia
View previous topic :: View next topic  
Author Message
Martux
Veteran
Veteran


Joined: 04 Feb 2005
Posts: 1917

PostPosted: Mon May 24, 2010 12:22 pm    Post subject: [solved] Mysql/Amarok is filling up /var/lib/mysql Reply with quote

Hi!
I use Mysql for amarok.
Everytime I change/add tracks in amarok, mysql starts to fill up it's datadir /var/lib/mysql with files like this:
Code:

mysqld-bin.00000

I remove them by hand from time to time with no negative impact.
What the hell are these files for?
The amarok collection has it's own subdir "amarokdb" which doesn't fill up too much.
How can I suppress this behaviour of mysql?
Btw.: I *hate* it to handle mysql just for amarok. Is amaroks embedded db still not working with 5.1.x?
_________________
"Coincidence is God's way of remaining anonymous."
Albert Einstein
"The road to success is always under construction"


Last edited by Martux on Tue May 25, 2010 9:02 pm; edited 1 time in total
Back to top
View user's profile Send private message
tomk
Bodhisattva
Bodhisattva


Joined: 23 Sep 2003
Posts: 7221
Location: Sat in front of my computer

PostPosted: Mon May 24, 2010 1:37 pm    Post subject: Reply with quote

This is the binary log for MySQL which you only really need if you're going to be doing replication but is enabled by default.

You need to comment out a line in your my.cnf:

/etc/mysql/my.cnf:
#log-bin


Then restart mysql.
_________________
Search | Read | Answer | Report | Strip
Back to top
View user's profile Send private message
Martux
Veteran
Veteran


Joined: 04 Feb 2005
Posts: 1917

PostPosted: Tue May 25, 2010 9:02 pm    Post subject: Reply with quote

tomk:
Thank you! That really fixed the issue.
This makes me wonder if there are any other "tweaks" I should setup in mysql for optimal usage with amarok?
_________________
"Coincidence is God's way of remaining anonymous."
Albert Einstein
"The road to success is always under construction"
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Multimedia All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum