optimize database

[Egg]

If I dont optimize database at least twice a day, my board becomes so slow it is crawling

and when it has finished (normally takes an age to get it to finish, sometimes times out) it comes up with

"Your database contains 25 table(s)
Attempting to optimize your database...
optimize: yabbse_log_clicks .... 0.391 kb optimized.
optimize: yabbse_log_online .... 0.015 kb optimized.

2 table(s) optimized.
"

and thats it!!

but after that the board is as fast as a clean install..

what gives??? any ideas??

[[Unknown]]

Use my patented ClickLog remover mod, found here:

Code Select Expand

<edit file>
index.php
</edit file>

<search for>
/* ### Log this click ### */
ClickLog();
</search for>

<replace>
/* ### Do not log this click ### */
//ClickLog();
</replace>

Wow that was hard .

-[Unknown]

Most likely this will solve all of your problems.

-[Unknown]

[Egg]

and that will remove my forum access logs??

or remove something else??

I ahave the loggign set to 1440 minutes at the moment, should I revert back to 60 minutes?

[[Unknown]]

That little mod there will stop your board from doing much with log_clicks.

That table is one of the most annoying, as it has problems and causes slowdowns ALL THE TIME!

Which, , is exactly why it's been removed in my secret project.  (actually, it's one of the 'features' I expect to be a little less than popular... people hate losing functionality.)

-[Unknown]

[Egg]

if you need a tester for that there project let me know

so what will I loose by doing the above mod??

the log clicks?, ok, they can go

the refferring pages? ok, I get that from my server

the board stats?? hmmmmmm

[[Unknown]]

the board stats?? hmmmmmm

No, you won't lose that one.

-[Unknown]

[mediman]

unknown is right!

the click_log table has often "memory overhang" or is even "locked"

this was the reason for manju and me to integrade the optimizer...

unknown´s fix will help you a lot!

mediman

[Dr_Michael]

That little mod there will stop your board from doing much with log_clicks.

That table is one of the most annoying, as it has problems and causes slowdowns ALL THE TIME!

Which, , is exactly why it's been removed in my secret project.  (actually, it's one of the 'features' I expect to be a little less than popular... people hate losing functionality.)

-[Unknown]

Uknown, thank you for your "mod".  
I just did it. Should I also empty the table click_logs? Or it doesnt matter?

[[Unknown]]

Probably doesn't matter, but you minus well...

-[Unknown]

[Dr_Michael]

It doesnt show the Referring Pages anymore?  

[Egg]

didnt work I'm afraid.

did it this morning, members still getting 7sec+ page load times  

[David]

URL to your forum?

[Dr_Michael]

Referring Pages are very important for me so I prefer a little slower than losing those referrals details.  
I just enabled click logs again.

[Egg]

http://www.200mph.org.uk

[Spaceman-Spiff]

It doesnt show the Referring Pages anymore?  

That's the function of ClickLog, if u disable it, the "View forum access log" will be useless
other alternatives is to use something like this: http://www.nedstat.com/EN