Question Database points log

[Bullmama DeLano]

My points log table in my_sql is HUGE!!!

My server admin believe this is causing a lockup on MySQL when too many users are trying to access the forum at once.

How can I fix this issue? Any help will be appreciated.

 

[Fillip H.]

It will only cause issues with the "Activity Feed" page, and there's an option to disable it in vBulletin Options under "DragonByte Tech: vBActivity - Activity Stats Settings".

You can also run

DELETE FROM dbtech_vbactivity_pointslog WHERE dateline < (UNIX_TIMESTAMP() - 2592000)

to get rid of entries older than 30 days.
Remember to add your table prefix if you use one.

 

[Bullmama DeLano]

Great thank you! I turned that off so hopefully it helps!

 

[Bullmama DeLano]

Excellent, this has helped tons!!! Thanks for the great tip and info!!