Jump to content
Sign in to follow this  
jeffuk

tbllog_register Is huge

Recommended Posts

I installed WHMCS early 2017, and the tbllog_register table is an absolute beast.  I made the discovery when I was moving WHMCS to a new server.

Has there not been any developments on https://requests.whmcs.com/topic/ability-to-prune-system-activity-log

I had a look at the post below but surely this is something WHMCS has been looking at as there is no way of cleaning these records unless you do it manually, more so now that these cron jobs are executed every five minutes.

 😴

Share this post


Link to post
Share on other sites
19 hours ago, jeffuk said:

6 years, 23 votes and they've blocked it to new comments... no developments that i'm aware of.

19 hours ago, jeffuk said:

surely this is something WHMCS has been looking at as there is no way of cleaning these records unless you do it manually, more so now that these cron jobs are executed every five minutes. 

we won't know what they're thinking unless they tell us, and even if this was to occur, it's unlikely it would do so until a release or beta was imminent (e.g they 100% knew it was coming soon)... logically, you would think that they were looking at it, but they have been known to think in illogical ways and miss obvious issues. 🙄

Share this post


Link to post
Share on other sites
7 minutes ago, brian! said:

6 years, 23 votes and they've blocked it to new comments... no developments that i'm aware of.

we won't know what they're thinking unless they tell us, and even if this was to occur, it's unlikely it would do so until a release or beta was imminent (e.g they 100% knew it was coming soon)... logically, you would think that they were looking at it, but they have been known to think in illogical ways and miss obvious issues. 🙄

6 years ago 😂😂😂 missed that bit.

Hopefully, one day then 🙄

Share this post


Link to post
Share on other sites
On 3/28/2019 at 5:00 PM, jeffuk said:

6 years ago 😂😂😂 missed that bit.

Yes, just 23 votes, because nowadays 90% "hosting companies" are just junkies who don't care about databasese, and who don't know what is php, css or mysql...

Share this post


Link to post
Share on other sites

Hello @Stuart Newton

 

These table records data relate to cron. Basically, it is where the results of a cron task are stored. The daily cron email report aggregates its content from these rows.

At present it is not possible to prune this log from within WHMCS, however in WHMCS 8.1 and above we have optimized the indexing for cron log data.

https://docs.whmcs.com/Changelog:WHMCS_V8.1

CORE-14970 - Optimize indexing for cron log data

In the meantime, if you did want to do this, you could so with a SQL query.

For example the SQL query below will remove any entries in that table that predate 2020:

DELETE FROM `tbllog_register` WHERE created_at < "2020-01-01";

As always please backup your WHMCS DB before perfoming such operations.

I hope this information helps.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated