MySQL optimization for Chat Server(red5)

[ihostman]

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

 

[lenovohost]

Tuning the performance of MySQL can be a really hard job to do.
There are many thinks to consider and no two servers are identical so there is no universal solution.
Tuning Primer is a script that will help you tune your mysql installation by providing very healthy recommendations based on past mysql records.
For the script to be efficient you must run the mysql server for at least 48 hours.

Installation is extremely simple:

1. Download the script

wget http://day32.com/MySQL/tuning-primer.sh

2. Change the permissions for the file

chmod 755 tuning-primer.sh

3. Run it

./tuning-primer.sh

4. Apply the sugesttions