Re: Too much CPU Usage, Is it any optimize?

[Derek Meyer]

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.