[asterisk-bugs] [Asterisk 0018687]: [patch] high iowait due to ast_db_put of realtime peers

[Asterisk Bug Tracker]

The following issue has been UPDATED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18687 
====================================================================== 
Reported By:                wdoekes
Assigned To:                russell
====================================================================== 
Project:                    Asterisk
Issue ID:                   18687
Category:                   Channels/chan_sip/DatabaseSupport
Reproducibility:            always
Severity:                   tweak
Priority:                   normal
Status:                     closed
Asterisk Version:           1.6.2.16.1 
JIRA:                       SWP-3018 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 won't fix
Fixed in Version:           
====================================================================== 
Date Submitted:             2011-01-27 03:32 CST
Last Modified:              2011-02-10 13:28 CST
====================================================================== 
Summary:                    [patch] high iowait due to ast_db_put of realtime
peers
Description: 
Hi,

on an asterisk 1.6.2 server, I receive lots of REGISTERs (around 20
packets per second). For every (succesful) registration, it seems to be
writing a new astdb. This causes an unnecessary disk load. (It writes a new
blob of astdb data 10 times per second.)

As I understand it, there is no reason to store these realtime peers in
the astdb as the needed info is already in the SQL db.

I've patched asterisk to not do that, and I haven't noticed any adverse
effects after two weeks.


Regards,
Walter Doekes
OSSO B.V.
====================================================================== 

---------------------------------------------------------------------- 
 (0131821) russell (administrator) - 2011-02-10 13:28
 https://issues.asterisk.org/view.php?id=18687#c131821 
---------------------------------------------------------------------- 
In Asterisk 1.8 (I think, definitely trunk) the load of astdb has been
significantly reduced.  It was previously doing an fsync() on every db
modification.  It now rate limits them. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-02-10 13:28 russell        Note Added: 0131821                          
2011-02-10 13:28 russell        Status                   ready for testing =>
resolved
2011-02-10 13:28 russell        Resolution               open => won't fix   
2011-02-10 13:28 russell        Assigned To               => russell         
2011-02-10 13:28 russell        Status                   resolved => closed  
======================================================================