clear db records - devel_times [#141457]

I was looking through the tables in my database and devel_times is by far my largest table at 4.7MB with 150,000 records. I don't see any way within the devel interface to clear these records (the way you can clear the sites' cache)

I'd like to be able to do this before I run database backups so that my backup files aren't bloated with this somewhat useless data. Perhaps just a link in the devel block could accomplish this.

I assume it won't cause any problems if I just run an SQL command to clear the contents of this table, right ????

Comments

Comment #1

moshe weitzman commented 5 May 2007 at 02:09

right - just empty via SQL. no problem there.

Comment #2

geek-merlin

German

Freiburg, Germany

commented 31 August 2008 at 08:39

Component:	Code	» devel
Priority:	Minor	» Normal

have problems with this too.

setting to normal because this bloats up automatic backup files.

solution might be to "thow away old log entries" with a cron oneliner.

Comment #3

moshe weitzman commented 31 August 2008 at 09:29

for now, just clear the table with sql as needed. no problem there. patches are welcome for the clean on cron feature.

Comment #4

OpenChimp commented 2 September 2008 at 22:20

Recently, I've been using the Backup & Migrate module, which lets you specify which tables are included in your database backups. You can select to leave the db table out entirely or to leave out just the data. It's a great module, so if you're having issues with you backup sizes being too large, I'd encourage you to check it out.