MySQL optimization for Chat Server(red5)
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]