Hi Brian, I had a few probs a while back with Roller using-up all the MySQL connections; changing the MySQL configuration solved this for me. I'm not running as many blogs as you, but I've copied my conf below.
Cheers, Richard [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-innodb max_connections = 500 key_buffer = 16M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1024 thread_cache_size = 64 wait_timeout = 1800 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqldump] quick max_allowed_packet = 16M On 22/10/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
