PDA

View Full Version : Use of mySql database?



gs_bagga
2008-05-05, 09:23
I have few basic questions about use of mySQL database

1, What is the use of mySQL database in slimserver?
2, If I do not use search and browse only by folder, do I still need this database?
3. Is there a ways to reduce the size of this database?

The reason for my question is to reduce the memory usage on my SSODS. I am using DS-106.

==================

Model Name DS-106
Current Firmware Version: 2.0.3 - 0518
Firmware Date: 2007/11/01


Disk model WDC WD5000AAKS-00TMA0

SSODS - Release 2.19

Hard-/Firmware : Disk Station 106 / 2.0.3 - 0518 (2007/11/01)
Load averages : 0.10 0.04 0.01
Uptime : 2d 09.41:30 (97% idle)
Memory / Swap : 60/61 MB used, 12+13 MB buf+shr / 73/384 MB used
*** SlimServer ***
Version : 6.3.1-8476
Database size : 38 MB
Process status : running with PID 909
Process state : S (sleeping)
Memory usage : 61328 kb total, 22368 kb (36%) RSS
Uptime : 2d 09.35:11
CPU usage : 68:38 total CPU time, 1.9% average CPU load
==================

JJZolx
2008-05-05, 09:43
I have few basic questions about use of mySQL database

1, What is the use of mySQL database in slimserver?

It holds information about the library. Both essential data for playback like type of encoding and starting byte offset of music data, as well as non-essential "metadata" such as track and album titles, artist name, genre.


2, If I do not use search and browse only by folder, do I still need this database?

Yes, it's required. SqueezeCenter always needs to read information about a playable track from the database.


3. Is there a ways to reduce the size of this database?

Not that I'm aware of.


The reason for my question is to reduce the memory usage on my SSODS. I am using DS-106.

For the most part, the database isn't kept in memory, except as needed. The only real control you have over the memory usage of SlimServer is in the plugins that you have loaded. You could try disabling as many as you can, but the savings may not be much.

erland
2008-05-05, 11:56
For the most part, the database isn't kept in memory, except as needed. The only real control you have over the memory usage of SlimServer is in the plugins that you have loaded. You could try disabling as many as you can, but the savings may not be much.

It might be possible to lower the memory usage by customize the options in the MySQL/my.tt file.

I'm guessing the options might currently optimized for speed and not primarily for low memory usage. All the parameters with "buffer" or "size" as part of the name is probably a good place to start looking.

gs_bagga
2008-05-06, 14:17
Thanks. I will try these things out. The real reason for my question is to achieve hdd hibernation. I have been reading the posts and have not yet found a clear cut way to achive it. I do not know much about linux.