Fast Lane! Posted April 2, 2010 Share Posted April 2, 2010 I wont dribble on. I get lots of major spikes from the topic marker tables. They are small but I discovered highly fragmented in a short amount of time. I added a cronjob to optimize them every half hour. Since then -- goodness. OPTIMIZE TABLE `ibf_core_item_markers`; OPTIMIZE TABLE `ibf_core_item_markers_storage`; Make a cronjob to run this every 30 minutes. It is very fast and has prevented spikes so far on my server. Food for thought! I was getting 50 or more loads for brief times and not any so far. maybe just luck but I am hoping the final fix! Link to comment Share on other sites More sharing options...
Fast Lane! Posted April 2, 2010 Author Share Posted April 2, 2010 @all As a follow up. Charles has confirmed that this is something that is "known" about. I suggest those having issues try this above. It has worked wonders for me, where nothing else did. Charles indicated this will be a feature in 3.1 (optimize automatically). Until then I suggest the above to help reduce spikes in load that at least for me, were very bad! Link to comment Share on other sites More sharing options...
Pupette Posted April 4, 2010 Share Posted April 4, 2010 Thanks Fast Lane, how do I set up this up in cPanel? Any help appreciated. Link to comment Share on other sites More sharing options...
Fast Lane! Posted April 5, 2010 Author Share Posted April 5, 2010 create a file called "db_optimize" with the following contents: OPTIMIZE TABLE `ibf_core_item_markers_storage`; OPTIMIZE TABLE `ibf_core_item_markers`; then set a crontab as follows: 30 * * * * mysql -u"data base username" -p"data base password" "data base name" < db_optimize enter the above items in " "'s without the quotes so for example if your username to your database is Tom then do ... "30 * * * * mysql -uTom ...", :). the "< db_optimize" part of the cron points to the file. If the file is not in your users root directory you will need to point to it, ex: "/home/user/db_optimize". Link to comment Share on other sites More sharing options...
Pupette Posted April 6, 2010 Share Posted April 6, 2010 Thanks for your reply. I'll give that a try. Link to comment Share on other sites More sharing options...
Bono Posted April 6, 2010 Share Posted April 6, 2010 Nice find, after those tables are optimized forum fly's, it's like 10x faster than normal. Time to load index page goes down from 0.9 to 0.6s. Link to comment Share on other sites More sharing options...
Fast Lane! Posted April 9, 2010 Author Share Posted April 9, 2010 Awesome news! Mine has been TONS faster since I have this cron running. I hope IPB can circulate this news. I will cross post to get some eyes on it. Hopefully many people will not have to go through the same trouble / slow downs. Link to comment Share on other sites More sharing options...
sound Posted April 9, 2010 Share Posted April 9, 2010 could this be done via a board task similar to the clean up mysql process one ? Link to comment Share on other sites More sharing options...
Fast Lane! Posted April 9, 2010 Author Share Posted April 9, 2010 Sure. I prefer the regularity of the crontab but either way would work :). Link to comment Share on other sites More sharing options...
ikillbill Posted April 9, 2010 Share Posted April 9, 2010 we completely disable markers, load still spike Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.