Question how to delete tranation log?

[roberthanks77]

does anybody know how to delete some transation log?

it's so longgg , only several days it could be hundreds.

 

[Darkwaltz4]

Transaction log cannot be pruned without reversing those transactions first, otherwise the system cannot function as a closed system (ie, discrepancies can arise with which you wont be able to trace the reason)

 

[roberthanks77]

if i have 200 thousand visitors per day, will it take a lot of space?

 

[Cosmic]

if i have 200 thousand visitors per day, will it take a lot of space?

If your server is able to handle the posts made by those people it will be able to handle the transactions just fine =)

Cosmic

 

[Darkwaltz4]

The table is optimized for speed and size, coupled with mysql's scaling capabilities, allow it to comfortably fit into millions of rows without issue