Get Paid to Participate - up to $1 per post!     Twitter     Facebook     Google+
Hosting Discussion
 

Hosting Discussion > Web Hosting Forums > Hardware and Server Configuration > MySQL optimization for Chat Server(red5)
forgot password?



Reply


Old
  Post #1 (permalink)   10-22-2009, 07:48 AM
HD Newbie
 
Join Date: Oct 2009
Location: Bangladesh
Posts: 1
Send a message via MSN to ihostman Send a message via Yahoo to ihostman

Status: ihostman is offline
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
============================================
__________________
TetraHost Bangladesh
Shared Hosting | Reseller Hosting | Semi Dedicated Box
Biased for true hosting experience - www.tetrahostbd.com
 
 
 


Old
  Post #2 (permalink)   10-27-2009, 09:20 PM
HD Newbie
 
Join Date: Nov 2008
Posts: 25

Status: lenovohost is offline
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
 
 
 
Reply

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: