Details
-
Type:
Improvement
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Not A Bug
-
Affects Version/s: 1.0.7
-
Fix Version/s: 1.0.7
-
Component/s: None
-
Labels:None
-
Platform:Linux x86/gcc
-
FreeSWITCH GIT Revision:unknown
-
Reproduced with GIT HEAD?:no
Description
I do performance test with freeswitch. The ip address of freeswitch is 203.174.107.34,The remote mysql server ip is 10.156.70.47.
I configure freeswitch using session timer about 320 second. when test for some time , The freeswitch will operation database on remote server,and send this,the packages numbers is 18268 in test.cap and flowing:
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='a99f1b81-f9a3-4c90-b8f2-2d43ef8c17f2';
update tasks set task_desc='heartbeat',task_group='core', task_sql_manager=0 where task_id=1 and hostname='FW1';
update tasks set task_desc='check_ip',task_group='core', task_sql_manager=0 where task_id=2 and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='0cc5ea89-08f1-4a18-8ef4-3c3888cdfbab';
update calls set callee_cid_name='3269',callee_cid_num='3269' where caller_uuid='41964c25-9b8c-429b-a20a-349f43cc19e1';
update calls set callee_cid_name='3876',callee_cid_num='3876' where caller_uuid='bc430451-c4d4-4247-9b7f-01d81eaddb85';
update calls set callee_cid_name='3796',callee_cid_num='3796' where caller_uuid='04625880-4fb1-491a-b8db-b3c621e52fb3';
update calls set callee_cid_name='3795',callee_cid_num='3795' where caller_uuid='24915c98-0c17-4ba9-9f15-6c658a66c5c5';
delete from calls where (caller_uuid='4c0342a3-b999-43d1-8804-342612a1e545' or callee_uuid='4c0342a3-b999-43d1-8804-342612a1e545') and hostname='FW1';
delete from calls where (caller_uuid='61a52127-94e9-425c-b494-3451a41f72e1' or callee_uuid='61a52127-94e9-425c-b494-3451a41f72e1') and hostname='FW1';
delete from calls where (caller_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf' or callee_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf') and hostname='FW1';
delete from calls where (caller_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46' or callee_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46') and hostname='FW1';
delete from calls where (caller_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2' or callee_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2') and hostname='FW1';
delete from calls where (caller_uuid='4c0342a3-b999-43d1-8804-342612a1e545' or callee_uuid='4c0342a3-b999-43d1-8804-342612a1e545') and hostname='FW1';
delete from calls where (caller_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c' or callee_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='2c9cf60a-1b42-40b0-9416-baa6adfa1540';
delete from calls where (caller_uuid='61a52127-94e9-425c-b494-3451a41f72e1' or callee_uuid='61a52127-94e9-425c-b494-3451a41f72e1') and hostname='FW1';
delete from calls where (caller_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf' or callee_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf') and hostname='FW1';
delete from calls where (caller_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46' or callee_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46') and hostname='FW1';
delete from calls where (caller_uuid='90ef8494-90e6-4ae1-a783-ba53f597fbfc' or callee_uuid='90ef8494-90e6-4ae1-a783-ba53f597fbfc') and hostname='FW1';
delete from calls where (caller_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2' or callee_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='8a48ead4-f9de-45ff-be15-93255312cd78';
delete from calls where (caller_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c' or callee_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c') and hostname='FW1';
delete from calls where (caller_uuid='410a7a06-d8c8-45fd-935c-0d025fcd66bb' or callee_uuid='410a7a06-d8c8-45fd-935c-0d025fcd66bb') and hostname='FW1';
delete from calls where (caller_uuid='c8428a6f-63ca-47d9-b2fd-a7df62c3d9e2' or callee_uuid='c8428a6f-63ca-47d9-b2fd-a7df62c3d9e2') and hostname='FW1';
delete from calls where (caller_uuid='566f208b-3ef8-4815-ab5d-08f5fe597319' or callee_uuid='566f208b-3ef8-4815-ab5d-08f5fe597319') and hostname='FW1';
delete from calls where (caller_uuid='d267118c-2cce-40fe-8276-f4592e5c4e0c' or callee_uuid='d267118c-2cce-40fe-8276-f4592e5c4e0c') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='e52b987b-c245-4a03-bcf0-3a6a55bfc2d4';
delete from calls where (caller_uuid='76053bbc-0ca2-439a-a053-707106680fb0' or callee_uuid='76053bbc-0ca2-439a-a053-707106680fb0') and hostname='FW1';
update calls set callee_cid_name='3672',callee_cid_num='3672' where caller_uuid='823a0afe-7a11-4f89-85be-ecbf58d01e4f';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='9589aea1-0a1e-4e19-8ea1-fae6f27988b6';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='ac454c43-1fc9-40c1-b748-3ea877154102';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='d1a83468-95fd-4207-8a64-cfd505616b0e';
update calls set callee_cid_name='3274',callee_cid_num='3274' where caller_uuid='87de04b2-111b-458a-809e-0337188e5a3e';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='eef02923-f484-4f6b-bb44-c84b2258ab91';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='811a0433-ea9d-450f-8363-d3f6e18bb570';
delete from calls where (caller_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663' or callee_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663') and hostname='FW1';
delete from calls where (caller_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe' or callee_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe') and hostname='FW1';
delete from calls where (caller_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77' or callee_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77') and hostname='FW1';
delete from calls where (caller_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472' or callee_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472') and hostname='FW1';
delete from calls where (caller_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e' or callee_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e') and hostname='FW1';
delete from calls where (caller_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202' or callee_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202') and hostname='FW1';
delete from calls where (caller_uuid='76125030-5977-4967-9b0b-ea97d340bca1' or callee_uuid='76125030-5977-4967-9b0b-ea97d340bca1') and hostname='FW1';
delete from calls where (caller_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663' or callee_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663') and hostname='FW1';
update calls set callee_cid_name='3468',callee_cid_num='3468' where caller_uuid='8325de30-f677-4eda-9087-405ecefb6c26';
delete from calls where (caller_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77' or callee_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77') and hostname='FW1';
delete from calls where (caller_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e' or callee_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e') and hostname='FW1';
delete from calls where (caller_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472' or callee_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472') and hostname='FW1';
delete from calls where (caller_uuid='b6781045-799e-4ce9-936a-80bb1d198623' or callee_uuid='b6781045-799e-4ce9-936a-80bb1d198623') and hostname='FW1';
update calls set callee_cid_name='3280',callee_cid_num='3280' where caller_uuid='3f115264-ac88-49f3-85eb-ea42edd2ecd0';
delete from calls where (caller_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202' or callee_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202') and hostname='FW1';
delete from calls where (caller_uuid='76125030-5977-4967-9b0b-ea97d340bca1' or callee_uuid='76125030-5977-4967-9b0b-ea97d340bca1') and hostname='FW1';
delete from calls where (caller_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe' or callee_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe') and hostname='FW1';
delete from calls where (caller_uuid='1317acf7-8c38-4d3c-9916-4b4af44d7494' or callee_uuid='1317acf7-8c38-4d3c-9916-4b4af44d7494') and hostname='FW1';
delete from calls where (caller_uuid='86cbb200-8a0b-4e22-92c6-ff5b82e7c5a8' or callee_uuid='86cbb200-8a0b-4e22-92c6-ff5b82e7c5a8') and hostname='FW1';
delete from calls where (caller_uuid='fcf8ea28-d1f1-4728-8579-63e8bd569580' or callee_uuid='fcf8ea28-d1f1-4728-8579-63e8bd569580') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='313fda31-0b2b-44f6-bf67-425adf582800';
delete from calls where (caller_uuid='8aaae1d6-2515-44c1-88ab-6ff22d0889bc' or callee_uuid='8aaae1d6-2515-44c1-88ab-6ff22d0889bc') and hostname='FW1';
delete from calls where (caller_uuid='df795060-367d-4976-8b36-798120232ef9' or callee_uuid='df795060-367d-4976-8b36-798120232ef9') and hostname='FW1';
delete from calls where (caller_uuid='eef18489-1941-4c77-8c17-b8c787b98094' or callee_uuid='eef18489-1941-4c77-8c17-b8c787b98094') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='45e4ce89-a7b4-4cd1-90b0-f8407dd39897';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='6a4ff2ef-5e3e-470a-9cd5-3335620d073d';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='8208b260-dbfb-4f91-bed7-07be25e00d4b';
delete from calls where (caller_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3' or callee_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3') and hostname='FW1';
delete from calls where (caller_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2' or callee_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2') and hostname='FW1';
delete from calls where (caller_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29' or callee_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29') and hostname='FW1';
delete from calls where (caller_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa' or callee_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa') and hostname='FW1';
delete from calls where (caller_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3' or callee_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3') and hostname='FW1';
delete from calls where (caller_uuid='01e9a67e-572a-442f-b470-3760eb358b38' or callee_uuid='01e9a67e-572a-442f-b470-3760eb358b38') and hostname='FW1';
delete from calls where (caller_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2' or callee_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2') and hostname='FW1';
delete from calls where (caller_uuid='9a520aac-73f8-431a-a28b-6d66082f88db' or callee_uuid='9a520aac-73f8-431a-a28b-6d66082f88db') and hostname='FW1';
delete from calls where (caller_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29' or callee_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29') and hostname='FW1';
delete from calls where (caller_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74' or callee_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74') and hostname='FW1';
delete from calls where (caller_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1' or callee_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='b689e5c8-8f28-455c-a237-d81de6dea532';
delete from calls where (caller_uuid='9a520aac-73f8-431a-a28b-6d66082f88db' or callee_uuid='9a520aac-73f8-431a-a28b-6d66082f88db') and hostname='FW1';
update calls set callee_cid_name='3793',callee_cid_num='3793' where caller_uuid='a387c2e9-7bd6-4a79-ab55-3373020d08fd';
delete from calls where (caller_uuid='01e9a67e-572a-442f-b470-3760eb358b38' or callee_uuid='01e9a67e-572a-442f-b470-3760eb358b38') and hostname='FW1';
delete from calls where (caller_uuid='4fe6b03d-13e2-42e8-aca6-91dfd1a038e4' or callee_uuid='4fe6b03d-13e2-42e8-aca6-91dfd1a038e4') and hostname='FW1';
delete from calls where (caller_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa' or callee_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa') and hostname='FW1';
delete from calls where (caller_uuid='447fbd16-bc6d-4fbf-b821-e80e285b3377' or callee_uuid='447fbd16-bc6d-4fbf-b821-e80e285b3377') and hostname='FW1';
delete from calls where (caller_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74' or callee_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74') and hostname='FW1';
delete from calls where (caller_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1' or callee_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1') and hostname='FW1';
delete from calls where (caller_uuid='32332272-3607-4717-a65c-e2fd0ae3bc53' or callee_uuid='32332272-3607-4717-a65c-e2fd0ae3bc53') and hostname='FW1';
delete from calls where (caller_uuid='cf1bd32c-b901-4b67-acb3-142e41557b8f' or callee_uuid='cf1bd32c-b901-4b67-acb3-142e41557b8f') and hostname='FW1';
update calls set callee_cid_name='3878',callee_cid_num='3878' where caller_uuid='fa335eb5-393a-444b-91f6-00ba38087ba9';
delete from calls where (caller_uuid='ab631d4e-eea5-4d97-bd1d-444b02f975f7' or callee_uuid='ab631d4e-eea5-4d97-bd1d-444b02f975f7') and hostname='FW1';
delete from calls where (caller_uuid='3be9eeb3-6661-4f11-83ae-4a54e3544c64' or callee_uuid='3be9eeb3-6661-4f11-83ae-4a54e3544c64') and hostname='FW1';
delete from calls where (caller_uuid='4c994aba-2e48-47dc-9f65-d7001daf22b7' or callee_uuid='4c994aba-2e48-47dc-9f65-d7001daf22b7') and hostname='FW1';
delete from calls where (caller_uuid='52d02e06-d3b2-4651-97fc-864442297132' or callee_uuid='52d02e06-d3b2-4651-97fc-864442297132') and hostname='FW1';
update calls set callee_cid_name='3281',callee_cid_num='3281' where caller_uuid='caaeca82-a2af-43b9-8d10-f674365597a5';
delete from calls where (caller_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21' or callee_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21') and hostname='FW1';
delete from calls where (caller_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf' or callee_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf') and hostname='FW1';
delete from calls where (caller_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a' or callee_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a') and hostname='FW1';
delete from calls where (caller_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5' or callee_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5') and hostname='FW1';
delete from calls where (caller_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b' or callee_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b') and hostname='FW1';
delete from calls where (caller_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b' or callee_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b') and hostname='FW1';
delete from calls where (caller_uuid='919792ae-f1c1-4b52-a370-3319f49c602c' or callee_uuid='919792ae-f1c1-4b52-a370-3319f49c602c') and hostname='FW1';
delete from calls where (caller_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b' or callee_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b') and hostname='FW1';
delete from calls where (caller_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21' or callee_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21') and hostname='FW1';
delete from calls where (caller_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a' or callee_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a') and hostname='FW1';
delete from calls where (caller_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5' or callee_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5') and hostname='FW1';
delete from calls where (caller_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf' or callee_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf') and hostname='FW1';
delete from calls where (caller_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b' or callee_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b') and hostname='FW1';
delete from calls where (caller_uuid='919792ae-f1c1-4b52-a370-3319f49c602c' or callee_uuid='919792ae-f1c1-4b52-a370-3319f49c602c') and hostname='FW1';
delete from calls where (caller_uuid='045d4221-3775-421c-92ad-d11b88762b4a' or callee_uuid='045d4221-3775-421c-92ad-d11b88762b4a') and hostname='FW1';
delete from calls where (caller_uuid='c0a1228c-ab3f-42ea-9345-4357bd03209c' or callee_uuid='c0a1228c-ab3f-42ea-9345-4357bd03209c') and hostname='FW1';
delete from calls where (caller_uuid='a71904b6-c45e-467f-a3d8-fb9ceb39d6b9' or callee_uuid='a71904b6-c45e-467f-a3d8-fb9ceb39d6b9') and hostname='FW1';
delete from calls where (caller_uuid='bab8f2a3-032a-49df-a00a-8385aaf44d93' or callee_uuid='bab8f2a3-032a-49df-a00a-8385aaf44d93') and hostname='FW1';
delete from calls where (caller_uuid='70cc3738-0ff9-4953-8627-afec7e949047' or callee_uuid='70cc3738-0ff9-4953-8627-afec7e949047') and hostname='FW1';
delete from calls where (caller_uuid='5bbff555-3e96-444c-9ded-b07ba8ec634f' or callee_uuid='5bbff555-3e96-444c-9ded-b07ba8ec634f') and hostname='FW1';
delete from calls where (caller_uuid='eb786292-15a8-465d-b900-8c782179ec61' or callee_uuid='eb786292-15a8-465d-b900-8c782179ec61') and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='Outbound Call',callee_num='59999123',callee_direction='RECV' where uuid='a99f1b81-f9a3-4c90-b8f2-2d43ef8c17f2' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='Outbound Call',callee_num='59999123',callee_direction='RECV' where uuid='0cc5ea89-08f1-4a18-8ef4-3c3888cdfbab' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3269',callee_num='3269',callee_direction='RECV' where uuid='41964c25-9b8c-429b-a20a-349f43cc19e1' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3876',callee_num='3876',callee_direction='RECV' where uuid='bc430451-c4d4-4247-9b7f-01d81eaddb85' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3796',callee_num='3796',callee_direction='RECV' where uuid='04625880-4fb1-491a-b8db-b3c621e52fb3' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3795',callee_num='3795',callee_direction='RECV' where uuid='24915c98-0c17-4ba9-9f15-6c658a66c5c5' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='4c0342a3-b999-43d1-8804-342612a1e545' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='61a52127-94e9-425c-b494-3451a41f72e1' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='cbe23
.........and so on.
you can see there are so many sql operations, so the resopnses are slow, the bye or register messages coming but no responses.
so how can I do configure to remove the problem?
I configure freeswitch using session timer about 320 second. when test for some time , The freeswitch will operation database on remote server,and send this,the packages numbers is 18268 in test.cap and flowing:
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='a99f1b81-f9a3-4c90-b8f2-2d43ef8c17f2';
update tasks set task_desc='heartbeat',task_group='core', task_sql_manager=0 where task_id=1 and hostname='FW1';
update tasks set task_desc='check_ip',task_group='core', task_sql_manager=0 where task_id=2 and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='0cc5ea89-08f1-4a18-8ef4-3c3888cdfbab';
update calls set callee_cid_name='3269',callee_cid_num='3269' where caller_uuid='41964c25-9b8c-429b-a20a-349f43cc19e1';
update calls set callee_cid_name='3876',callee_cid_num='3876' where caller_uuid='bc430451-c4d4-4247-9b7f-01d81eaddb85';
update calls set callee_cid_name='3796',callee_cid_num='3796' where caller_uuid='04625880-4fb1-491a-b8db-b3c621e52fb3';
update calls set callee_cid_name='3795',callee_cid_num='3795' where caller_uuid='24915c98-0c17-4ba9-9f15-6c658a66c5c5';
delete from calls where (caller_uuid='4c0342a3-b999-43d1-8804-342612a1e545' or callee_uuid='4c0342a3-b999-43d1-8804-342612a1e545') and hostname='FW1';
delete from calls where (caller_uuid='61a52127-94e9-425c-b494-3451a41f72e1' or callee_uuid='61a52127-94e9-425c-b494-3451a41f72e1') and hostname='FW1';
delete from calls where (caller_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf' or callee_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf') and hostname='FW1';
delete from calls where (caller_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46' or callee_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46') and hostname='FW1';
delete from calls where (caller_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2' or callee_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2') and hostname='FW1';
delete from calls where (caller_uuid='4c0342a3-b999-43d1-8804-342612a1e545' or callee_uuid='4c0342a3-b999-43d1-8804-342612a1e545') and hostname='FW1';
delete from calls where (caller_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c' or callee_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='2c9cf60a-1b42-40b0-9416-baa6adfa1540';
delete from calls where (caller_uuid='61a52127-94e9-425c-b494-3451a41f72e1' or callee_uuid='61a52127-94e9-425c-b494-3451a41f72e1') and hostname='FW1';
delete from calls where (caller_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf' or callee_uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf') and hostname='FW1';
delete from calls where (caller_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46' or callee_uuid='cbe23dea-7934-4d8a-b594-27dff1ee7e46') and hostname='FW1';
delete from calls where (caller_uuid='90ef8494-90e6-4ae1-a783-ba53f597fbfc' or callee_uuid='90ef8494-90e6-4ae1-a783-ba53f597fbfc') and hostname='FW1';
delete from calls where (caller_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2' or callee_uuid='bcfb33d7-0b1f-4ebe-ad99-688c4eae69b2') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='8a48ead4-f9de-45ff-be15-93255312cd78';
delete from calls where (caller_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c' or callee_uuid='840d0009-ea78-4d92-aeeb-c645d0a6585c') and hostname='FW1';
delete from calls where (caller_uuid='410a7a06-d8c8-45fd-935c-0d025fcd66bb' or callee_uuid='410a7a06-d8c8-45fd-935c-0d025fcd66bb') and hostname='FW1';
delete from calls where (caller_uuid='c8428a6f-63ca-47d9-b2fd-a7df62c3d9e2' or callee_uuid='c8428a6f-63ca-47d9-b2fd-a7df62c3d9e2') and hostname='FW1';
delete from calls where (caller_uuid='566f208b-3ef8-4815-ab5d-08f5fe597319' or callee_uuid='566f208b-3ef8-4815-ab5d-08f5fe597319') and hostname='FW1';
delete from calls where (caller_uuid='d267118c-2cce-40fe-8276-f4592e5c4e0c' or callee_uuid='d267118c-2cce-40fe-8276-f4592e5c4e0c') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='e52b987b-c245-4a03-bcf0-3a6a55bfc2d4';
delete from calls where (caller_uuid='76053bbc-0ca2-439a-a053-707106680fb0' or callee_uuid='76053bbc-0ca2-439a-a053-707106680fb0') and hostname='FW1';
update calls set callee_cid_name='3672',callee_cid_num='3672' where caller_uuid='823a0afe-7a11-4f89-85be-ecbf58d01e4f';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='9589aea1-0a1e-4e19-8ea1-fae6f27988b6';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='ac454c43-1fc9-40c1-b748-3ea877154102';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='d1a83468-95fd-4207-8a64-cfd505616b0e';
update calls set callee_cid_name='3274',callee_cid_num='3274' where caller_uuid='87de04b2-111b-458a-809e-0337188e5a3e';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='eef02923-f484-4f6b-bb44-c84b2258ab91';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='811a0433-ea9d-450f-8363-d3f6e18bb570';
delete from calls where (caller_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663' or callee_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663') and hostname='FW1';
delete from calls where (caller_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe' or callee_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe') and hostname='FW1';
delete from calls where (caller_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77' or callee_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77') and hostname='FW1';
delete from calls where (caller_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472' or callee_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472') and hostname='FW1';
delete from calls where (caller_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e' or callee_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e') and hostname='FW1';
delete from calls where (caller_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202' or callee_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202') and hostname='FW1';
delete from calls where (caller_uuid='76125030-5977-4967-9b0b-ea97d340bca1' or callee_uuid='76125030-5977-4967-9b0b-ea97d340bca1') and hostname='FW1';
delete from calls where (caller_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663' or callee_uuid='37aca336-f3ed-45dc-a443-b5332e5c5663') and hostname='FW1';
update calls set callee_cid_name='3468',callee_cid_num='3468' where caller_uuid='8325de30-f677-4eda-9087-405ecefb6c26';
delete from calls where (caller_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77' or callee_uuid='6b702997-79bc-4181-9a9d-b092aa68cf77') and hostname='FW1';
delete from calls where (caller_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e' or callee_uuid='7a414a15-47c9-4ab7-95fc-835bdd35fd3e') and hostname='FW1';
delete from calls where (caller_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472' or callee_uuid='d8aef717-1bdc-4113-ba4a-58998fc99472') and hostname='FW1';
delete from calls where (caller_uuid='b6781045-799e-4ce9-936a-80bb1d198623' or callee_uuid='b6781045-799e-4ce9-936a-80bb1d198623') and hostname='FW1';
update calls set callee_cid_name='3280',callee_cid_num='3280' where caller_uuid='3f115264-ac88-49f3-85eb-ea42edd2ecd0';
delete from calls where (caller_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202' or callee_uuid='e71a9bda-c8f7-4914-ae4a-a13a3a785202') and hostname='FW1';
delete from calls where (caller_uuid='76125030-5977-4967-9b0b-ea97d340bca1' or callee_uuid='76125030-5977-4967-9b0b-ea97d340bca1') and hostname='FW1';
delete from calls where (caller_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe' or callee_uuid='8ada7043-9b52-47ef-ab42-7f89d1327dfe') and hostname='FW1';
delete from calls where (caller_uuid='1317acf7-8c38-4d3c-9916-4b4af44d7494' or callee_uuid='1317acf7-8c38-4d3c-9916-4b4af44d7494') and hostname='FW1';
delete from calls where (caller_uuid='86cbb200-8a0b-4e22-92c6-ff5b82e7c5a8' or callee_uuid='86cbb200-8a0b-4e22-92c6-ff5b82e7c5a8') and hostname='FW1';
delete from calls where (caller_uuid='fcf8ea28-d1f1-4728-8579-63e8bd569580' or callee_uuid='fcf8ea28-d1f1-4728-8579-63e8bd569580') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='313fda31-0b2b-44f6-bf67-425adf582800';
delete from calls where (caller_uuid='8aaae1d6-2515-44c1-88ab-6ff22d0889bc' or callee_uuid='8aaae1d6-2515-44c1-88ab-6ff22d0889bc') and hostname='FW1';
delete from calls where (caller_uuid='df795060-367d-4976-8b36-798120232ef9' or callee_uuid='df795060-367d-4976-8b36-798120232ef9') and hostname='FW1';
delete from calls where (caller_uuid='eef18489-1941-4c77-8c17-b8c787b98094' or callee_uuid='eef18489-1941-4c77-8c17-b8c787b98094') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='45e4ce89-a7b4-4cd1-90b0-f8407dd39897';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='6a4ff2ef-5e3e-470a-9cd5-3335620d073d';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='8208b260-dbfb-4f91-bed7-07be25e00d4b';
delete from calls where (caller_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3' or callee_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3') and hostname='FW1';
delete from calls where (caller_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2' or callee_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2') and hostname='FW1';
delete from calls where (caller_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29' or callee_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29') and hostname='FW1';
delete from calls where (caller_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa' or callee_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa') and hostname='FW1';
delete from calls where (caller_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3' or callee_uuid='abc902e0-a03e-4fee-b032-acbf7a07a7d3') and hostname='FW1';
delete from calls where (caller_uuid='01e9a67e-572a-442f-b470-3760eb358b38' or callee_uuid='01e9a67e-572a-442f-b470-3760eb358b38') and hostname='FW1';
delete from calls where (caller_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2' or callee_uuid='884206b6-a256-4917-9236-46dd7f4ea8c2') and hostname='FW1';
delete from calls where (caller_uuid='9a520aac-73f8-431a-a28b-6d66082f88db' or callee_uuid='9a520aac-73f8-431a-a28b-6d66082f88db') and hostname='FW1';
delete from calls where (caller_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29' or callee_uuid='f57e1e7a-e41a-4e8b-b811-b3ca250eaf29') and hostname='FW1';
delete from calls where (caller_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74' or callee_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74') and hostname='FW1';
delete from calls where (caller_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1' or callee_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1') and hostname='FW1';
update calls set callee_cid_name='Outbound Call',callee_cid_num='59999123' where caller_uuid='b689e5c8-8f28-455c-a237-d81de6dea532';
delete from calls where (caller_uuid='9a520aac-73f8-431a-a28b-6d66082f88db' or callee_uuid='9a520aac-73f8-431a-a28b-6d66082f88db') and hostname='FW1';
update calls set callee_cid_name='3793',callee_cid_num='3793' where caller_uuid='a387c2e9-7bd6-4a79-ab55-3373020d08fd';
delete from calls where (caller_uuid='01e9a67e-572a-442f-b470-3760eb358b38' or callee_uuid='01e9a67e-572a-442f-b470-3760eb358b38') and hostname='FW1';
delete from calls where (caller_uuid='4fe6b03d-13e2-42e8-aca6-91dfd1a038e4' or callee_uuid='4fe6b03d-13e2-42e8-aca6-91dfd1a038e4') and hostname='FW1';
delete from calls where (caller_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa' or callee_uuid='4b6f774c-4363-42e4-b1ea-db31b074d9fa') and hostname='FW1';
delete from calls where (caller_uuid='447fbd16-bc6d-4fbf-b821-e80e285b3377' or callee_uuid='447fbd16-bc6d-4fbf-b821-e80e285b3377') and hostname='FW1';
delete from calls where (caller_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74' or callee_uuid='0c370b73-e1da-4efc-aa9f-decdd3cadd74') and hostname='FW1';
delete from calls where (caller_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1' or callee_uuid='9f293ed1-7e68-4d92-bf65-f381765424c1') and hostname='FW1';
delete from calls where (caller_uuid='32332272-3607-4717-a65c-e2fd0ae3bc53' or callee_uuid='32332272-3607-4717-a65c-e2fd0ae3bc53') and hostname='FW1';
delete from calls where (caller_uuid='cf1bd32c-b901-4b67-acb3-142e41557b8f' or callee_uuid='cf1bd32c-b901-4b67-acb3-142e41557b8f') and hostname='FW1';
update calls set callee_cid_name='3878',callee_cid_num='3878' where caller_uuid='fa335eb5-393a-444b-91f6-00ba38087ba9';
delete from calls where (caller_uuid='ab631d4e-eea5-4d97-bd1d-444b02f975f7' or callee_uuid='ab631d4e-eea5-4d97-bd1d-444b02f975f7') and hostname='FW1';
delete from calls where (caller_uuid='3be9eeb3-6661-4f11-83ae-4a54e3544c64' or callee_uuid='3be9eeb3-6661-4f11-83ae-4a54e3544c64') and hostname='FW1';
delete from calls where (caller_uuid='4c994aba-2e48-47dc-9f65-d7001daf22b7' or callee_uuid='4c994aba-2e48-47dc-9f65-d7001daf22b7') and hostname='FW1';
delete from calls where (caller_uuid='52d02e06-d3b2-4651-97fc-864442297132' or callee_uuid='52d02e06-d3b2-4651-97fc-864442297132') and hostname='FW1';
update calls set callee_cid_name='3281',callee_cid_num='3281' where caller_uuid='caaeca82-a2af-43b9-8d10-f674365597a5';
delete from calls where (caller_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21' or callee_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21') and hostname='FW1';
delete from calls where (caller_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf' or callee_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf') and hostname='FW1';
delete from calls where (caller_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a' or callee_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a') and hostname='FW1';
delete from calls where (caller_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5' or callee_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5') and hostname='FW1';
delete from calls where (caller_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b' or callee_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b') and hostname='FW1';
delete from calls where (caller_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b' or callee_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b') and hostname='FW1';
delete from calls where (caller_uuid='919792ae-f1c1-4b52-a370-3319f49c602c' or callee_uuid='919792ae-f1c1-4b52-a370-3319f49c602c') and hostname='FW1';
delete from calls where (caller_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b' or callee_uuid='ed2be1db-865e-45ab-822e-9aef6e2c909b') and hostname='FW1';
delete from calls where (caller_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21' or callee_uuid='049684cd-3b95-4f27-a2a0-89a391d57b21') and hostname='FW1';
delete from calls where (caller_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a' or callee_uuid='d9aaa9e2-4301-4189-b7d5-4b60f7b78f0a') and hostname='FW1';
delete from calls where (caller_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5' or callee_uuid='e065838e-fbf8-4e75-909c-573bad4a19c5') and hostname='FW1';
delete from calls where (caller_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf' or callee_uuid='740afbae-0d36-4ece-abe0-df84e1c5efcf') and hostname='FW1';
delete from calls where (caller_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b' or callee_uuid='b8f0630d-cd1e-47aa-9f27-6aaeaa00c10b') and hostname='FW1';
delete from calls where (caller_uuid='919792ae-f1c1-4b52-a370-3319f49c602c' or callee_uuid='919792ae-f1c1-4b52-a370-3319f49c602c') and hostname='FW1';
delete from calls where (caller_uuid='045d4221-3775-421c-92ad-d11b88762b4a' or callee_uuid='045d4221-3775-421c-92ad-d11b88762b4a') and hostname='FW1';
delete from calls where (caller_uuid='c0a1228c-ab3f-42ea-9345-4357bd03209c' or callee_uuid='c0a1228c-ab3f-42ea-9345-4357bd03209c') and hostname='FW1';
delete from calls where (caller_uuid='a71904b6-c45e-467f-a3d8-fb9ceb39d6b9' or callee_uuid='a71904b6-c45e-467f-a3d8-fb9ceb39d6b9') and hostname='FW1';
delete from calls where (caller_uuid='bab8f2a3-032a-49df-a00a-8385aaf44d93' or callee_uuid='bab8f2a3-032a-49df-a00a-8385aaf44d93') and hostname='FW1';
delete from calls where (caller_uuid='70cc3738-0ff9-4953-8627-afec7e949047' or callee_uuid='70cc3738-0ff9-4953-8627-afec7e949047') and hostname='FW1';
delete from calls where (caller_uuid='5bbff555-3e96-444c-9ded-b07ba8ec634f' or callee_uuid='5bbff555-3e96-444c-9ded-b07ba8ec634f') and hostname='FW1';
delete from calls where (caller_uuid='eb786292-15a8-465d-b900-8c782179ec61' or callee_uuid='eb786292-15a8-465d-b900-8c782179ec61') and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='Outbound Call',callee_num='59999123',callee_direction='RECV' where uuid='a99f1b81-f9a3-4c90-b8f2-2d43ef8c17f2' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='Outbound Call',callee_num='59999123',callee_direction='RECV' where uuid='0cc5ea89-08f1-4a18-8ef4-3c3888cdfbab' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3269',callee_num='3269',callee_direction='RECV' where uuid='41964c25-9b8c-429b-a20a-349f43cc19e1' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3876',callee_num='3876',callee_direction='RECV' where uuid='bc430451-c4d4-4247-9b7f-01d81eaddb85' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3796',callee_num='3796',callee_direction='RECV' where uuid='04625880-4fb1-491a-b8db-b3c621e52fb3' and hostname='FW1';
update channels set state='CS_HIBERNATE',callstate='ACTIVE',callee_name='3795',callee_num='3795',callee_direction='RECV' where uuid='24915c98-0c17-4ba9-9f15-6c658a66c5c5' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='4c0342a3-b999-43d1-8804-342612a1e545' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='61a52127-94e9-425c-b494-3451a41f72e1' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='a9f7f1ae-6f07-4f87-9d59-d369a04057bf' and hostname='FW1';
update channels set callstate='HANGUP' where uuid='cbe23
.........and so on.
you can see there are so many sql operations, so the resopnses are slow, the bye or register messages coming but no responses.
so how can I do configure to remove the problem?
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#3._Configure_.2Fetc.2Fodbc.ini_.26_.2Fetc.2Fodbcinst.ini
Otherwise we do not entertain load testing questions with our free support.