Is there a way to automate this? the Optimize Tables, Fix all errors and Empty unimportant logs?
I already got a cron job on my site running at 1 am everyday. Thinking i could add to that to clean it up before it does the backup.
Thanks for any help
SMF has this built in:
Admin Section => Server Settings => Feature Configuration
In the third part, you can see the option for Optimize tables:
LainaaThis option optimizes the database every so many days. Set it to 1 to make a daily optimization. You can also specify a maximum number of online users, so that you won't overload your server or inconvenience too many users.
Not sure about fixing the errors and such... but I guess you could run a PHP script to automatically execute by logging in using CURL and executing the script... but who knows....
Yea but who knows when that script would run even at 1 day. Its not like i can set a time and day...
Would be a nice feature for smf to have to do through cron jobs.
Is there another way i could go? like some how use the coding that smf does to do all this forum Maintenance from a script?
Not sure... something a Dev would have to really show up and tell you....
What file I must to modify to run optimize table script every tot hours?
Its a built in feature in SMF 2 I believe.
Not much stable for me, this question is about SMF 1.1.x.
You'll require a lot of edits for that to happen in SMF 1.1.x, AFAIK, there is nothing that has done this in SMF 1.1.x. There are ways to do this though IMO.
I want to make this thing in SMF 1.1.x ... I've already 20 modified files, other edited files are not a problem for me.
Explain me please.
I don't know how to do it ATM.
If someone else with the knowledge knows it, he might post it :).
Lainaus käyttäjältä: Max22 - elokuu 30, 2008, 10:33:37 AP
What file I must to modify to run optimize table script every tot hours?
Unless your website sees millions of visits an hour, you do not need to run the optimize command that often. Optimize only reclaims unused space in tables that have had rows removed from them (mostly the session table), nothing more. A manual click every so often should be more than enough. By the time you need to do regular stuff like that you will likely be on a dedicated server where you can get direct shell access and can script that type of process.
You found my problem... it's the session table that must be optimized sometimes in a day. Manually it's not great for me and it's necessary to speed forum in normal navigation.
For now we haven't a dedicated server... but I don't know if this is the case, above all when there is only this inconvenience.
I hope in other possibilities, if there are.
I don't want to upgrade on SMF 2.0 beta for obvious reasons, and because my cms is incompatible with beta version.
How much traffic are you seeing? Who is your current host and what type of hosting are you on?
There should be no reason to run an optimize that often.
We use this host:
http://hosting.aruba.it/hosting_con_spazio.asp?Lang=EN&offerta=2
We've in this period 700 visits per day (in average) but I think that this value is increasing quickly.
I report another problem:
http://www.simplemachines.org/community/index.php?topic=252901.0
I solved with greyknight17 suggestion... now you understand why is it necessary to optimize all with automated tasks?
There is no chance to do this with my server?