Peter Zaitsev has an excellent blog about mysql performace http://www.mysqlperformanceblog.com/. This guy is good!!!! I can tell you from my own experience that you can do lot of tuning with the mysql configuration. Must of the stuff is in the blog. Look in the slow query log for queries that take long time. Also use show full processlist to see slow queries.
fedora core 2 that is old. Is it with the default kernel? On 10/22/06, webmaster <[EMAIL PROTECTED]> wrote:
Hi Everyone, Che Blogs has been cracking up these past couple of weeks under the load. What I am wondering is if anyone has any sense of the maximum load that I should be able to achieve with Roller running on a hosted system under Linux? My setup is: Fedora Core 2 JAVA Hotspot Server 1.5.0_09-b01 Apache 2.0.51 MySQL 4.1.21 mod_jk Roller 2.1 incubating The Server has 3.0G of Ram installed and 800 processes/threads are available to it. It is a "virtual dedicated server" in the language of my hosting provider. After much hair pulling I set the my configurations to attempt to allow 250 client connections for MySQL, Apache and Roller. The jvm is booted with the following directive: -server -Xms256m -Xmx570m This setup seemed to be working ok, but it has problems after a bit of time. Today it has crashed twice because of hitting the 1024 limit on open files. Right now it is running but I cannot access Che Blogs but I can access two other little planetplanet sites that are on the same server. One other problem is that I cannot start the jvm with any more than Xmx570m even thought I have 3G's of ram. Once the JVM for Roller is running I cannot start another JVM with anything above a trivial amount on memory allocated to it. I am sorry that is this so long and I realize that this is a really opened question, but I have been reading, googling, testing and tweaking for over a week now and I am at my wits end as to what more I can do. By the way, Che Blogs has probably less than 500 blogs on it total. I am trying to confirm that number but the MySQL response is unbelievably slow. I think that is a clue ;-) Lately, it is being hit by all the search engines and several RSS basis services very heavily. Any tuning suggestions for MySQL? So, I will post this and please let me know if I am missing something simple so that I can get on with the other areas of my life! Thanks for your kind consideration of this plea. Brian
