Periodic update of mercury.db and mercury.db-wal (Warning for SSD users!)

Hello,

I noticed an abnormal increase in the MBs written onto the SSD over the past few weeks or probabely monthes (I guess it was 1 TB over one month). With the help of SsdReady and the resource monitor in Windows 10 I could see that Spotify was periodically updating the files mercury.db and mercury.db-wal cause over 6 GB of writes per hour. There is another file with the name etilqs_*********** where the asterisks indicate some random letters. This file is also being periodically updated and rewritten but this time in the TEMP folder (AppData\Local\Temp).

I used the software "Process Monitor" from microsoft this time to monitor the writes regarding etliqs and the process spotify.exe caused about 280000 writes at the time. This has accompanied the rewriting of the two files mentioned earlier.

As a temporary solution I moved the WHOLE Spotify folder from the AppData\Local to a partition on the HDD Disk and created a symbolic link and had to change the environment variable of TEMP to another drive which has "fixed" the problem (now it has been an hour with 300 MB written only).

 

I hope the developers will further inspect this issue. 

 

 etilqs.png

Regards

Hey guys!

 

It seems we didn't receive a reply from your end. For this reason, we're setting this post as "Closed".
 
Don't hesitate to write us back if you need some extra help.
 
Our best,
Comments
kinbluu
Casual Listener

Hello @MaryC1, I ask you to please reopen this issue as it is obviously still not solved!

mazomuc
Newbie

Bad press regarding this issue in Germany:

http://www.golem.de/news/300-mbyte-pro-song-spotify-mit-sehr-starker-ssd-schreibbelastung-1611-12435...

Golem is the largest german-speaking tech website. Come on Spotify, pull yourself together!

dklotz
Newbie

@MaryC1 how can this be closed? this is killing your customers SSDs and is even getting major press attention

herbert78
Newbie

And once again, music pirates are the winners, honest customers are losers and treated like idiots. Spotity is such an incapable and arrogant company!

mazomuc
Newbie

Hey Spotify, the news is spreading fast! Now covered on nearly all german-speaking tech websites:

 

Just some examples:

http://www.chip.de/news/Spotify-schrottet-die-SSD-Mit-einem-Trick-koennen-Sie-das-Problem-loesen_103...

http://www.pcwelt.de/news/Schreibzugriffe-Spotify-belastet-SSD-im-Rechner-10072239.html

http://www.pcgames.de/Spotify-Thema-239361/News/App-des-Musikdienstes-belastet-SSD-Festplatten-massi...

http://derstandard.at/2000047258134/Spotify-App-kann-SSDs-mit-Hunderten-Gigabyte-belasten

 

 

I would like to translate just one sentence that can be found in every article: "Spotify ignores the problem." Really bad press for you guys!

burner
Roadie

Just read about this at golem.de...

Honestly, this behavior sucks!

zeroxxx
Gig Goer

You all need to post here: https://community.spotify.com/t5/Ongoing-Issues/Major-I-O-write-bytes-on-the-Spotify-Desktop-app-It-...

 

Spotify's representative arrogantly closed this thread, this won't do anything.

Tigerchen
Newbie

Spotify has written 10% of the TBW (Total Bytes Written) on my SSD, in just a couple of Days. Before it was just 2%. I hope Spotify will pay for the Damage they did on my SSD. Otherwise i will spray that News all over the Internet to prevent People loosing their Data and get damaged Hardware due to Spotify  Its Time for Spotify to rewrite their **bleep**ty App.