justyns / phpsyswatch Goto Github PK

Right now, everything is logged indefinitely. DB size so far isn't too big of a problem(~250mb for a few months worth of logs on a moderately trafficked server)

There should be an option to auto-delete records older than X amount of days. Vacuum should also be called on the sqlite database to free up space.

right now, if you delete dbfile while watch.php is still running, it will error out and die - but it also leaves a 0byte db file in its place causing it not to create the db automatically.

as part of the main while loop, it needs to check if the file exists and die if not so that it can be created the next time cron runs watch.php.

Some firefox browsers aren't showing a scrollbar on the window that pops up from the graphs

Need to add a new table to monitor swap usage, almost identical to the current memory table:

CREATE TABLE swap (
    id INTEGER PRIMARY_KEY AUTO_INCREMENT,
    time INTEGER,
    total INTEGER,
    used INTEGER,
    free INTEGER
    );

And then start logging swap usage in the main loop, preferably by checking /proc and not using shell_exec

watch.php shouldn't be run from apache. We should check if it is and die if so.
http://php.net/manual/en/function.php-sapi-name.php

Auto-detect admin mysql password if it's a plesk server, or just try root with no password