UNIX for Beginners Questions & Answers

I don't want to truncate or reduce any tables. I want to delete analytic files that do not create any tables.

So from the backend I can go into the analytic directory where there are 100s of files (some create tables, some are old and need deleting). i don't want to touch the ones that create tables but delete the ones not connected to anything. I thought there might be a command to search for files that are used or not.

Yes, I think (did not check)... did MadeInGermany give you a command to check the last access times of files in his reply?

Or are you looking for something different or in addition?

I could be wrong, but I don't think "analytic files" (your words) "create tables" (your words).

Normally tables are created when the DB is created or modified by the admin, and "analytics files" add rows to those tables.

Is this not how your DB works?

Sorry, I don't have hands on experience with kdb+ but it looks interesting

Also, I noticed (my guess) is that your application is related to predictive analytics and perhaps algorithmic trading.

In that case, these algorithms rely heavily on historical data and (often expensive) analytics.

I recommend you do not delete any of these "analytic files" unless you are sure you have backup copies.

May I ask why you are doing this (deleting analytical files which you believe to be unused)?

Are you having a disk space issue?