MySQL optimization for red5

182 views
asked Mar 6, 2012 in General by GeekySun (120 points)
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 like 0 dislike
answered Mar 6, 2012 by Max454 (140 points)
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
0 like 0 dislike
answered Mar 9, 2012 by Yuriy (1,340 points)
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.
...