[sr-dev] [kamailio/kamailio] schema: add indexes to topos Mysql tables (#1355)

sergey-vb notifications at github.com
Fri Dec 8 07:54:52 CET 2017


#### Type Of Change
- [x] Small bug fix (non-breaking change which fixes an issue)
- [ ] New feature (non-breaking change which adds new functionality)
- [ ] Breaking change (fix or feature that would change existing functionality)

#### Checklist:
<!-- Go over all points below, and after creating the PR, tick the checkboxes that apply -->
- [x] PR should be backported to stable branches
- [x] Tested changes locally
- [ ] Related to issue #XXXX (replace XXXX with an open issue number)

#### Description
Using topos module in production I have found slow queries in MySQL.
After analyzing it I have add indexes to topos_t and topos_d tables.
You can view, comment on, or merge this pull request online at:

  https://github.com/kamailio/kamailio/pull/1355

-- Commit Summary --

  * schema: add indexes to topos Mysql tables (#13)

-- File Changes --

    M src/lib/srdb1/schema/topos_d.xml (10)
    M src/lib/srdb1/schema/topos_t.xml (10)

-- Patch Links --

https://github.com/kamailio/kamailio/pull/1355.patch
https://github.com/kamailio/kamailio/pull/1355.diff

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/pull/1355
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20171208/05b41ccb/attachment.html>


More information about the sr-dev mailing list