Re: Too much CPU Usage, Is it any optimize?
Posted by:
Derek Meyer
Date: September 28, 2007 02:02PM
FYI: I am also seeing this and it is not to hard to duplicate. I setup a web site that querys a table that has maybe 50 rows in it. Click refresh a dozen times and see the following
mysql> select * from proxy_connections;
+------+--------+-------+--------------+
| id | type | state | db |
+------+--------+-------+--------------+
| 0 | server | 0 | |
| 1 | proxy | 0 | |
| 2 | server | 10 | |
| 3 | proxy | 12 | Test_Database |
| 4 | proxy | 12 | Test_Database |
| 5 | proxy | 12 | Test_Database |
| 6 | proxy | 12 | Test_Database |
| 7 | proxy | 12 | Test_Database |
| 8 | proxy | 12 | Test_Database |
| 9 | proxy | 12 | Test_Database |
| 10 | proxy | 12 | Test_Database |
| 11 | proxy | 12 | Test_Database |
| 12 | proxy | 12 | Test_Database |
| 13 | proxy | 10 | Test_Database |
| 14 | proxy | 10 | Test_Database |
| 15 | proxy | 10 | Test_Database |
| 16 | proxy | 10 | Test_Database |
| 17 | proxy | 12 | Test_Database |
| 18 | proxy | 10 | Test_Database |
| 19 | proxy | 6 | |
| 20 | proxy | 2 | |
| 21 | proxy | 2 | |
+------+--------+-------+--------------+
mysql> select * from proxy_config;
+----------------------------+--------------------+
| option | value |
+----------------------------+--------------------+
| admin.address | :4041 |
| proxy.address | :4040 |
| proxy.lua_script | NULL |
| proxy.backend_addresses[0] | 192.168.1.9:3306 |
| proxy.fix_bug_25371 | 0 |
| proxy.profiling | 1 |
+----------------------------+--------------------+
6 rows in set (0.00 sec)
mysql proxy then sucks up about 40-50% CPU on a duel core machine. When I connect directly to the mysql Dbase (and not useing mysqlproxy) no issues at all
In my setup the mysqlproxy is sitting on the web server and redirecting traffic to the DB server through the proxy.
Subject
Views
Written By
Posted
9632
September 21, 2007 03:37AM
Re: Too much CPU Usage, Is it any optimize?
4684
September 28, 2007 02:02PM
3751
October 22, 2007 05:12AM
5161
October 25, 2007 03:37AM
4067
October 27, 2007 08:54AM
4000
October 03, 2007 07:39AM
3666
October 13, 2007 09:23PM
3385
October 22, 2007 05:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.