guys, we are running chat server(red5). servers specs are: Intel Xeon QuadCore SingleProc Sata, 2GB ram with latest cPanel, apache and mysql...server is running fine with the mysql config, still i want to show my mysql config file to you guys so that you can suggest me something more for better performance for those chatrooms. Here is my my.cnf: ============================================ [mysqld] set-variable = max_connections=300 safe-show-database max_user_connection=100 query_cache_size=256M query_cache_limit=32M query_cache_type = 1 max_allowed_packet=16M table_cache=1024 thread_cache_size = 256 key_buffer_size=64M wait_timeout=75 connect_timeout=50 interactive_timeout=100 #slave_net_timeout=35 tmp_table_size=128M read_buffer_size=2M sort_buffer_size=2M read_rnd_buffer_size=2M myisam_sort_buffer_size=128M record_buffer=1M thread_concurrency=4 local-infile=0 ============================================
I would suggest you to increase the max_connections to 1000.Even if they are not used it takes no performance but if many visitors are in your chat and write you need a lot of connections established. ( Depends on how much users you get but it does not hurt to set it to a high value ) Furthermore i would increase max_user_connections to 500. Increase your table cache to 128mb.