DiaVoLo Posted November 23, 2008 Share Posted November 23, 2008 Hi, I need some help optimalize my forum I think, its running slow when creating new topics and posts. I have a pretty fast server: CPU: Quad Core 2.13 ghz RAM: 2048mb When I look at system usage, its not so high either. I tried to optimize my posts table, who is now 1gb large. I have 500-1000 post each day. Anyone have other tips to optimize for better performance? Link to comment Share on other sites More sharing options...
loccom Posted November 23, 2008 Share Posted November 23, 2008 you need to optimize your mysql using the my.cnf file. Get this done right and it will be a lot faster assign more memory to mysql really helps Link to comment Share on other sites More sharing options...
AndyF Posted November 23, 2008 Share Posted November 23, 2008 Moving to "Server Management, Resources, Optimization" :) Link to comment Share on other sites More sharing options...
DiaVoLo Posted March 2, 2009 Author Share Posted March 2, 2009 Where do I find my.cnf file? Also, first post was wrong this is the stats of my server: Dual core 1,86 and 1024 mb ram. My database is 1gb ++ Link to comment Share on other sites More sharing options...
rct2·com Posted March 2, 2009 Share Posted March 2, 2009 If you're running Linux, I suggest that you install mysqltuner. http://wiki.mysqltuner.com/MySQLTuner A sure sign that MySQL needs tuning is when your system CPU usage is low, but disk I/O is high. Link to comment Share on other sites More sharing options...
DiaVoLo Posted March 2, 2009 Author Share Posted March 2, 2009 I have a managed server so I cannot install my own programs. Would it help alot if I got 6000 gb memory ? Link to comment Share on other sites More sharing options...
rct2·com Posted March 2, 2009 Share Posted March 2, 2009 If it's managed, does that mean other people are using it, so you may not be the cause of the problem? And if it's managed, the managers need to be managing this problem, not you! Link to comment Share on other sites More sharing options...
DiaVoLo Posted March 2, 2009 Author Share Posted March 2, 2009 No I am the only one using this server. Link to comment Share on other sites More sharing options...
wepfijweoifj Posted May 6, 2009 Share Posted May 6, 2009 Managed means you can ask them to do anything -- including install stuff -- from their support for free. Unmanaged is just rebooting and technical stuff like that. Link to comment Share on other sites More sharing options...
Bono Posted May 6, 2009 Share Posted May 6, 2009 2GB of ram should be enough, but if is not too expensive you can add 4GB. You could provide as with your url so we can see if is slow for us too. Link to comment Share on other sites More sharing options...
Alex K. Posted May 7, 2009 Share Posted May 7, 2009 If your forum is the link in your signature, it seems significantly faster than most IP.Board forums I visit.. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.