Question Table optimizing

[DxtGaming]

When I try to update/repair some tables it does not work
View bbyDHh.png on ScreenSnapr

Their overhead is all 343.00 MB
How can I fix this?

 

[Darkwaltz4]

those tables are innodb because they are write-heavy. innodb does not support the optimize command.

this is not a bug nor something i can "fix". if it bothers you and you dont get a lot of concurrent arcade traffic, you can switch it to myisam.

 

[DxtGaming]

what about credits_transactions one? it has 3648153 logs

 

[Darkwaltz4]

The exact explanation given applies to that table as well, for the very same reasons.

 

[DxtGaming]

Are you 100% sure because it Credits addon slow the site kinda a lot (we notice it instantly when we enable it)

or do you have any suggestion which features we should disable

 

[Darkwaltz4]

Did you apply the indexes for the credits_transaction table? Lack of those is what causes the slowness.

 

[DxtGaming]

Not sure? How to see it? or how do we do it? and does it have any impact?

Check how its big..
http://screensnapr.com/e/8353Fi.jpg

 

[Darkwaltz4]

It looks like you have a lot of zero'd out events when you should REALLY have deleted/disabled the ones you arent using - especially those legions of poor view events.
Otherwise it will strain your system from wasting time trying to process and store events that ultimately go nowhere. I can try cleaning up some of the mess, but would need to PM me ftp and an admin login.