You are not logged in.

#1 2009-09-14 13:36:37

yu_raider
Member
Registered: 2009-09-14
Posts: 7

Amarok and MySQL backend

Hi, I installed amaroK 2 and it's currently using sqlite3 which seems to be very slow. I wish to change its backend to MySQL but I don't have that option in the menu, so I'm guessing it was compiled without MySQL support. Should I just compile it myself?

Offline

#2 2009-09-14 17:29:19

calef13
Member
Registered: 2007-06-10
Posts: 142

Re: Amarok and MySQL backend

Well, I use sqlite without problems and I have about ~5000 songs, but if you still want mySQL, you should probably consult the relevant wiki entry here:

http://wiki.archlinux.org/index.php/Amarok#MySQL

According to my 5 secs of research, mysql should be an option, so maybe it hasn't bene compiled with support, but I can't imagine why. Have you got mySQL installed?

Offline

#3 2009-09-14 18:02:55

yu_raider
Member
Registered: 2009-09-14
Posts: 7

Re: Amarok and MySQL backend

Yes, it needs to be explicitly compiled with MySQL support and that's what I'll do. Sqlite isn't dreadful but I'm a bit of a perfectionist so I'll try to recompile it anyway.

Thanks for the help!

Offline

#4 2009-09-14 19:30:09

lucke
Member
From: Poland
Registered: 2004-11-30
Posts: 4,018

Re: Amarok and MySQL backend

Amarok2 uses mysqle (mysql embedded), not sqlite, by default. 2.2 introduces support for an external mysql database.

Offline

#5 2009-09-14 19:31:59

ugkbunb
Member
Registered: 2009-02-26
Posts: 227

Re: Amarok and MySQL backend

calef13 wrote:

Well, I use sqlite without problems and I have about ~5000 songs

5000 songs isn't much... I have ~700gigs of music and without using the mysql backend for Amarok1.4 any type of operation that accesses the database is incredibly slow.

Offline

#6 2009-09-14 19:59:22

calef13
Member
Registered: 2007-06-10
Posts: 142

Re: Amarok and MySQL backend

Ah I didn't realise you were using amarok 1.4, assumptions got me again! smile

@ugkbunb: wow, that's a lot of torrenting, I tip my hat to you sir wink But seriously I can imagine that even with mySQL it must be sluggish at times?

Offline

#7 2009-09-15 01:03:27

ugkbunb
Member
Registered: 2009-02-26
Posts: 227

Re: Amarok and MySQL backend

^^
I am not sure what the OP is using. He could very well be using Amarok 2.x

Really though with mysql --- searhing all 700 gigs for one song there is barely even a pause... I was quite amazed myself. I was used to in windows organzing my music myself and adding/controlling my player through the context menu. I still do that on Arch with Amarok but I am getting more and more used to the search collection feature of Amarok. Quite nice really.

Offline

Board footer

Powered by FluxBB