MySQL optimization for Chat Server(red5)

ihostman's picture

They have: 1 posts

Joined: Oct 2009

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
============================================

[FONT="Trebuchet MS"][SIZE="2"][B]TetraHost Bangladesh[/B][/SIZE]
Shared Hosting | Reseller Hosting | Semi Dedicated Box
Biased for true hosting experience - [url]www.tetrahostbd.com[/url][/FONT]