Go Back   Singapore Web Hosting Talk > LEARNING CENTER > Server Administration

Server Administration General dedicated servers administration topics.

Reply
 
Thread Tools
Old 22-10-2009, 21:58   #1
ihostman
SGWHT Newbie
 
Join Date: 13-10-2009
Location: Bangladesh
Posts: 1
ihostman is on a distinguished road
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
============================================
__________________
TetraHost Bangladesh
Shared Hosting | Reseller Hosting | Semi Dedicated Box
Biased for true hosting experience - www.tetrahostbd.com
ihostman is offline   Reply With Quote

Old 15-05-2010, 20:34   #2
vheeds
SGWHT Newbie
 
Join Date: 28-01-2010
Posts: 19
vheeds is on a distinguished road
Hello ihostman,

Do you still have the performance problem with mysql? If so, ping me via

Aim : vheeds@aim.com
Skype : vheeds
Yahoo : vheeds18
MSN : vheeds

i will help you out to get the maximum performance.
__________________
Stephan V
VHeeds.com
►A Quality WebHosting and Datacenter support.
►Email: sales@vheeds.com
►Read the latest technology news @ http://blog.vheeds.com
►Exclusive Introductory Offer! Server Hardening - $ 20 only | Dedicated Server Support - $500 only | Contact us today and avail these offers.
vheeds is offline   Reply With Quote
Reply

Thread Tools

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

Forum Jump




All times are GMT +8. The time now is 23:39.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright (C) 2002-2015 Brought to you by Singapore Web Hosting Talk (SGWHT). All Rights Reserved.