Why is my snapshots.db growing out of control after installing Mavericks OS?

Back up all data.

If you have more than one user account, you must be logged in as an administrator to carry out these instructions.

Please triple-click anywhere in the line below on this page to select it:

sudo sqlite3 /v*/*/*/sn*.db "vacuum;"

Copy the selected text to the Clipboard by pressing the key combination command-C.

Launch the Terminal application in any of the following ways:

☞ Enter the first few letters of its name into a Spotlight search. Select it in the results (it should be at the top.)

☞ In the Finder, select Go ▹ Utilities from the menu bar, or press the key combination shift-command-U. The application is in the folder that opens.

☞ Open LaunchPad. Click Utilities, then Terminal in the icon grid.

Paste into the Terminal window by pressing the key combination command-V. I've tested these instructions only with the Safari web browser. If you use another browser, you may have to press the return key after pasting. You'll be prompted for your login password. Nothing will be displayed when you type it. If you don’t have a login password, you’ll need to set one before you can run the command. You may get a one-time warning to be careful. Confirm. You don't need to post the warning.

If you see a message that your username "is not in the sudoers file," then you're not logged in as an administrator. Log in as one and start over.

The command may take a noticeable amount of time to run. Wait for a new line ending in a dollar sign (“$”) to appear below what you entered. You can then quit Terminal.

So, what is the snapshots.db file and what was the cause of Ldiller's problem?

Linc Davis, I get an error:

Error: database disk image is malformed

Any idea on how to proceed?

Thanks!

snapshots.db is a database that contains power usage stats. I think Link was issuing a command for it to be rebuilt. I'm not a SQL expert but I believe that is what the vacuum modifier does.

I have deleted the snapshots.db file, rebooted, and it was recreated. I find the whole power stats thing useless on my desktops and only marginally useful on my laptop.

same problem here! 'Error: database disk image is malformed'

(snapshot.db tumor now 18GB and counting)

I tried to do this but it ran for a while and then gave an error message:

Error: database or disk is full

My snapshots.db is 16.5 GB and apparently growing, and I have only a few GB left on my SSD startup disk... help? Is there another way to delete the file?

OSX 10.9.5 on a mid-2010 MBP.

Aha! I found something that may have fixed it. I used Disk Inventory X to view that drive and was able to select the database.db file and move it to the trash. I emptied the trash, and set up the auto-vacuum script from earlier in the thread.