Go Back   Computer Forums > General Computing > Server Administration
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 10-22-2009, 10:11 AM   #1
Beta Member
 
Join Date: Oct 2009
Posts: 2
Send a message via MSN to ihostman Send a message via Yahoo to ihostman
Default 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
============================================
ihostman is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 04:45 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0