Posts: 18
Joined: Jan 2011
Reputation:
0
Voldor
Junior Member
Posts: 18
2013-10-11, 15:07
(This post was last modified: 2013-10-11, 15:25 by Voldor.)
Are the SQL command to change the engine to InnoDB long to execute ?
Posts: 178
Joined: Jul 2011
Reputation:
1
Any howto for noobs?
Synology DS411j. What I must install-touch?
Posts: 43
Joined: Apr 2012
Reputation:
0
mbu10
Junior Member
Posts: 43
thanks for that seth works a treat, dealing with 10K plus items and has sped up no end now and i am running the 1812+ so i expected better, now i have it
Posts: 514
Joined: Feb 2012
Reputation:
23
Thanks or the fix. It solved my 2 minute freeze as well. I made similar changes for the music library and it seems to be more responsive now. Before I had a delay fo 15 seconds when opening an artist folder, now it is 3-5 seconds.
I think all righthtinking people in this country are sick and tired of being told that ordinary, decent people are fed up in this country with being sick and tired.
Posts: 514
Joined: Feb 2012
Reputation:
23
My music db is ~95 MB (45000 tracks / 1900 albums)
I think all righthtinking people in this country are sick and tired of being told that ordinary, decent people are fed up in this country with being sick and tired.
Posts: 327
Joined: Feb 2011
Reputation:
3
Is this specifically a Synology fix, or would this work on the MySQL install on my QNAP NAS?
QNAP TS670 NAS - 4x4TB Raided with NFS Support & Central MySQL DB
Pi 3 [Xbian] - Samsung 46" ES7000 Smart TV & HT-E5550 3D BD Sound System
Pi 3 [Xbian] + Hyperion Ambilight- Samsung 48" Curved UE48JS9000 4k
PowerEthernet T1502 Powerline adapters
Posts: 514
Joined: Feb 2012
Reputation:
23
2013-11-14, 22:43
(This post was last modified: 2013-11-14, 22:50 by PH-SYM.)
Are you really sure about 5000x? in my calculation you must then have over 225 Million (225,000,000) music tracks. Considering my measly 45,000 take up 500GB, your music library must be over 2000 Terabyte! How do you store all that?
I think all righthtinking people in this country are sick and tired of being told that ordinary, decent people are fed up in this country with being sick and tired.
Posts: 277
Joined: May 2011
Reputation:
4
2013-11-14, 22:59
(This post was last modified: 2013-11-14, 22:59 by seth.feinberg.)
haha no, i must have misread your post....or something, cause I'm looking at it right now, I just saw the 95MB. I have similarly about 500gb, maybe I'll give it another try then...
Posts: 514
Joined: Feb 2012
Reputation:
23
2013-11-15, 12:56
(This post was last modified: 2013-11-15, 12:58 by PH-SYM.)
I thought you asked for the size of my music database, that database file is 95MB. The actual music is about 500GB (45000 songs)
With the changes I made, XBMC is certainly able to cope with that so I recommend making those engine changes. Only change the tables with the MyISAM engine. Don't know what happens if you change the "view" tables but I left them alone.
I noticed a definite improvement in opening artists and albums from the library but also things like adding an album to a current playlist is much faster now. Before that took 10 seconds, now its almost instant (1-2 seconds).
I am still looking for the best my.cnf settings regarding InnoDB but sofar it seems working properly and its definitely an improvement over MyISAM.
I think all righthtinking people in this country are sick and tired of being told that ordinary, decent people are fed up in this country with being sick and tired.