ejabberd - Comments for "pub-sub support in 15.07 with mysql as backend" https://www.ejabberd.im/forum/25134/pub-sub-support-1507-mysql-backend en sorry to hijack your thread https://www.ejabberd.im/forum/25134/pub-sub-support-1507-mysql-backend#comment-66249 <p>sorry to hijack your thread but can you explain why and what mod_pubsub is used for ?</p> <p>I just disabled it and CPU dropped drastically. I inherited this system and it was enabled for some reason and I am trying to figure out why.</p> Tue, 20 Oct 2015 23:32:58 +0000 mshenoy comment 66249 at https://www.ejabberd.im It is https://www.ejabberd.im/forum/25134/pub-sub-support-1507-mysql-backend#comment-66116 <p>It is supported:</p> <div class="codeblock"><code>mod_pubsub:<br />&nbsp;&nbsp;&nbsp; db_type: odbc<br />&nbsp;&nbsp;&nbsp; access_createnode: pubsub_createnode<br />&nbsp;&nbsp;&nbsp; ## reduces resource comsumption, but XEP incompliant<br />&nbsp;&nbsp;&nbsp; ignore_pep_from_offline: true<br />&nbsp;&nbsp;&nbsp; ## XEP compliant, but increases resource comsumption<br />&nbsp;&nbsp;&nbsp; ## ignore_pep_from_offline: false<br />&nbsp;&nbsp;&nbsp; last_item_cache: false<br />&nbsp;&nbsp;&nbsp; plugins:<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - &quot;flat&quot;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - &quot;hometree&quot;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - &quot;pep&quot; # pep requires mod_caps</code></div> <p>Here db_type: odbc should help you achieve what you intend.</p> <p>-Prasad</p> Tue, 22 Sep 2015 19:35:00 +0000 prasadv comment 66116 at https://www.ejabberd.im