Long waiting times for posting
Collapse
X
-
-
Routine database maintenance for most site owners would be to create database backups and store at least two copies of them. One copy should be in a backup folder that is at the same level as your public_html folder. The other copy should be stored on your local machine or cloud storage such as OneDrive. Other maintenance would be handled by the server administrator with the hosting company.Leave a comment:
-
Routine database maintenance for most site owners would be to create database backups and store at least two copies of them. One copy should be in a backup folder that is at the same level as your public_html folder. The other copy should be stored on your local machine or cloud storage such as OneDrive. Other maintenance would be handled by the server administrator with the hosting company.Leave a comment:
-
No. There isn't really any that you need to do. Databases should tick along just fine without any manual intervention.
Things like the optimize and repair tools in the admincp are there not as routine maintenance tools but for use in the event of a problem.
I do realise that they sit under "Maintenance" in the admincp which is probably where some of the confusion arises.
I can see now, my forum feels so light and quick. Massive difference.
Leave a comment:
-
No. There isn't really any that you need to do. Databases should tick along just fine without any manual intervention.
Things like the optimize and repair tools in the admincp are there not as routine maintenance tools but for use in the event of a problem.
I do realise that they sit under "Maintenance" in the admincp which is probably where some of the confusion arises.Leave a comment:
-
-
-
Leave a comment:
-
Thank you for information Wayne.
I was using commends from drop menu in adminmyphp (at the bottom of 'Structure'). Check all -> With selected: Optimize Table. I am not sure if I used repair there. I have couple engines on server but: "InnoDB is the default storage engine on this MySQL server"
It did not crash yet so hopefully everything is fine. When I use check selected table everything is 'OK'.
I know there is optimize/repair table in admin panel and this I have used many times...Leave a comment:
-
Optimization and Repair will not do much to improve performance of your site.
In MySQL, Optimization means delete content that is already marked for deletion. If you haven't mass deleted topics or attachments recently, there isn't any real reason to run this. Doing so won't gain anything.
Repair should only be run if a table it marked as "Crashed and should be repaired". If you're using INNODB, this actually doesn't do much of anything. With MyISAM, your site will probably be down if tables need repairing. Running a repair on tables that don't need it can cause those tables to crash, ironically.
I was using commends from drop menu in adminmyphp (at the bottom of 'Structure'). Check all -> With selected: Optimize Table. I am not sure if I used repair there. I have couple engines on server but: "InnoDB is the default storage engine on this MySQL server"
It did not crash yet so hopefully everything is fine. When I use check selected table everything is 'OK'.
I know there is optimize/repair table in admin panel and this I have used many times...
Leave a comment:
-
Ok, now I know that I will help us a lot. People were pushing me to move to other forum engine, frustration was growing, as everything was slow. -
Optimization and Repair will not do much to improve performance of your site.
In MySQL, Optimization means delete content that is already marked for deletion. If you haven't mass deleted topics or attachments recently, there isn't any real reason to run this. Doing so won't gain anything.
Repair should only be run if a table it marked as "Crashed and should be repaired". If you're using INNODB, this actually doesn't do much of anything. With MyISAM, your site will probably be down if tables need repairing. Running a repair on tables that don't need it can cause those tables to crash, ironically.Leave a comment:
-
Will do, thanks.
Well, it is very fast now.
It was very frustrating for lots of people on my forum...After 18 months DB was 3.1GB, and now went down to 771MB after your suggested comments. Shocking.
I decided to skip 5.3.3, good to hear 5.3.4 will have this implemented.
Leave a comment:
-
Enjoy,
William
Leave a comment:
Related Topics
Collapse
-
by dbrookeHello,
Frankly, there are some problems and/or oddities with basic moderation in vBulletin.
I'm a noob to vBulletin, so please enlighten me if I'm not using things correctly.
...-
Channel: Support Issues & Questions
Mon 22 Aug '16, 7:54am -
-
by sudbury8How do you delete and page of the site?
Terry-
Channel: Support Issues & Questions
Sun 19 Jan '14, 1:28pm -
-
by op2Hi
In French, I receive "Vous ne pouvez pas supprimer les noeuds d'infraction." , don't know the en-GB term, probably "You can not delete the offense nodes."
...-
Channel: Support Issues & Questions
Tue 21 Aug '18, 2:22pm -
Leave a comment: