Pixelated a phpBB Template by SkaidonDesigns
 
Cheapest Web Software Support Area Forum Index www.cheapestwebsoftware.com
Play with the Best, be the Best!
Special Offers
FAQ
Search
Memberlist
Usergroups
Profile
Log in to check your private messages
Log in

The Mightiest Webmaster Solutions Ever
Blogs Automater
Blogs Automater
Rocket Pinger
Rocket Pinger
Kaktusan Cash
Kaktusan Cash
Links Organizer
Links Organizer

Haven't registered yet? Do it here now!
How can I save MySQL memory

 
Post new topic   Reply to topic    Cheapest Web Software Support Area Forum Index -> Links Organizer
View previous topic :: View next topic  
Author Message
wizz



Joined: 27 Aug 2006
Posts: 57

PostPosted: Tue Mar 18, 2008 9:24 pm    Post subject: How can I save MySQL memory Reply with quote
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
View user's profile Send private message

Author Message
Atanasis
Owner


Joined: 22 May 2004
Posts: 4284
Location: The Net

PostPosted: Tue Mar 18, 2008 9:40 pm    Post subject: Reply with quote
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
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger ICQ Number

Author Message
wizz



Joined: 27 Aug 2006
Posts: 57

PostPosted: Tue Mar 18, 2008 9:45 pm    Post subject: Reply with quote
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
View user's profile Send private message

Display posts from previous:   
Post new topic   Reply to topic    Cheapest Web Software Support Area Forum Index -> Links Organizer All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
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