www.cheapestwebsoftware.com Play with the Best, be the Best! The Mightiest Webmaster Solutions Ever Blogs Automater Special Offers Cheapest Web Software Plug Rush Haven't registered yet? Do it here now! How can I save MySQL memory          Cheapest Web Software Support Area Forum Index -> Links Organizer View previous topic :: View next topic   Author Message wizz Joined: 27 Aug 2006 Posts: 57 Posted: Tue Mar 18, 2008 9:24 pm    Post subject: How can I save MySQL memory What with Link Organizer, Rocket Pinger and Blog Organizer working on over 200 blogs, my MySQL memory is slowing down my system (so I'm told). Can I change the cron settings for LO from every hour to once every 24 hours? Back to top Author Message Atanasis Owner Joined: 22 May 2004 Posts: 4284 Location: The Net Posted: Tue Mar 18, 2008 9:40 pm    Post subject: Well, the cronjobs aren't the big problems. They run and check if they need to to anything with simple mysql query and if there isn't anything to do, they just die immediately. If you set the cronjob for LO to 24 hours, your templates won't regenerate each hour if you use that option Do you have caching enabled in mysql? There are also lots of other things to finetune your server. Download and use this mysql tuner script, it is really helpful: http://www.day32.com/MySQL/ _________________ Thanks, Kaktusan Back to top Author Message wizz Joined: 27 Aug 2006 Posts: 57 Posted: Tue Mar 18, 2008 9:45 pm    Post subject: Atanasis wrote: Well, the cronjobs aren't the big problems. They run and check if they need to to anything with simple mysql query and if there isn't anything to do, they just die immediately. If you set the cronjob for LO to 24 hours, your templates won't regenerate each hour if you use that option Do you have caching enabled in mysql? There are also lots of other things to finetune your server. Download and use this mysql tuner script, it is really helpful: http://www.day32.com/MySQL/ Okay, I will give it a try. Thanks for the quick reply. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         Cheapest Web Software Support Area Forum Index -> Links Organizer All times are GMT + 2 Hours Page 1 of 1   Jump to: Select a forum Knowledge Base (Read Only)----------------F.A.QBlogs OrganizerBlogs AutomaterLinks OrganizerRocket PingerFeeds Observer Technical Support (Read / Post)----------------Blogs OrganizerBlogs AutomaterLinks OrganizerRocket PingerFeeds Observer  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2002 phpBB Group