Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14611 reviews 1734 hosting providers

Questions & Answers

MySQL optimization for red5

Mar 6, 2012 by GeekySun
I'm running a 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.

2 Answers

0 votes
Mar 6, 2012 by Max454
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


4. Apply the sugesttions
0 votes
Mar 9, 2012 by Yuriy
Try to increase max_user_connections in your config to 200 or something higher, depending on how many times you  your script will be querying the database at the same time.
Also try to increase a bit the read_buffer_size.