Title: huge problem with database size !
Last modified: August 24, 2016

---

# huge problem with database size !

 *  Resolved [MLH17](https://wordpress.org/support/users/mlh17/)
 * (@mlh17)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/)
 * First of all: thanks for this wonderful plugin !!
 * I like it very much, mostly for the good customizability – e.g. the possibility
   to use html-Code in popups.
 * Worked fine here for 1 month – but then it caused a huge problem – suddenly I
   couldn’t login to the dashboard.
    After enabling the debug mode, it was clear:
   a database problem – the max-size was exceeded.
 * Popup-Maker Plugin produced over 25.000 entries in the postmeta-table of the 
   database – more than 23.000 with no value, but using space.
    So the database 
   enlarged more than 30 MB.
 * Here’s the result of a database query:
    SELECT count(*) FROM `wp_postmeta` WHERE
   meta_key like ‘popup_%’ and meta_value=” -> 23015
 * SELECT count(*) FROM `wp_postmeta` WHERE meta_key like ‘popup_%’ and meta_value
   <> ”
    -> 1863
 * Is there a reason for this or better: a solution?
    Would like to use Popup-Maker
   again – as a workaround I deactivated it and deleted the empty entries in the
   database.
 * Thanks a lot for your help!
 * [https://wordpress.org/plugins/popup-maker/](https://wordpress.org/plugins/popup-maker/)

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Author [Daniel Iser](https://wordpress.org/support/users/danieliser/)
 * (@danieliser)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009442)
 * [@mlh17](https://wordpress.org/support/users/mlh17/) – Hmm, how many popups do
   you have created? Also what was the DB size after deletion, 23k rows isn’t actually
   that much in terms of space generally and really shouldn’t cause a huge slowdown,
   at least on my own servers.
 * Just thinking though, it may be post revisions that have stored meta. Simply 
   cleaning out revisions from time to time would take care of that, plenty of plugins
   to do that for sure.
 *  Thread Starter [MLH17](https://wordpress.org/support/users/mlh17/)
 * (@mlh17)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009443)
 * Sorry, I forgot to give the link to the website:
    [http://www.livingfromyoursoul.org](http://www.livingfromyoursoul.org)(
   I activated the plugin temporarily again.)
 * And here is the script I used to have a form of Stefano Lissa’s newsletter-plugin
   in the popup:
 *     ```
       <script type="text/javascript">// <![CDATA[
       if (typeof newsletter_check !== "function") {
       window.newsletter_check = function (f) {
           var re = /^([a-zA-Z0-9_\.\-\+])+\@(([a-zA-Z0-9\-]{1,})+\.)+([a-zA-Z0-9]{2,})+$/;
           if (!re.test(f.elements["ne"].value)) {
               alert("The email is not correct");
               return false;
           }
           if (f.elements["nn"] && (f.elements["nn"].value == "" || f.elements["nn"].value == f.elements["nn"].defaultValue)) {
               alert("The name is not correct");
               return false;
           }
           if (f.elements["ns"] && (f.elements["ns"].value == "" || f.elements["ns"].value == f.elements["ns"].defaultValue)) {
               alert("The last name is not correct");
               return false;
           }
           if (f.elements["ny"] && !f.elements["ny"].checked) {
               alert("You must accept the privacy statement");
               return false;
           }
           return true;
       }
       }
       // ]]></script>
       <p><!--</p>
       <div class="newsletter3 newsletter-subscription"> --></p>
       <form action="http://www.livingfromyoursoul.org/wp-content/plugins/newsletter/do/subscribe.php" method="post">
       <table border="0" cellspacing="0" cellpadding="3"><!-- first name -->
       <tbody>
       <tr><th>Name</th>
       <td><input class="newsletter-firstname" name="nn" required="" size="30" type="text" /></td>
       </tr>
       <!-- email -->
       <tr><th>Email</th>
       <td align="left"><input class="newsletter-email" name="ne" required="" size="30" type="email" /></td>
       </tr>
       <tr>
       <td class="popuprightcode-td-submit" colspan="2"><input class="popuprightcode-submit" type="submit" value="Subscribe" /></td>
       </tr>
       </tbody>
       </table>
       </form>
       ```
   
 * Hope, these information help.
    Thanks.
 *  Plugin Author [Daniel Iser](https://wordpress.org/support/users/danieliser/)
 * (@danieliser)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009444)
 * [@mlh17](https://wordpress.org/support/users/mlh17/) – I will add an issue to
   our github to find a solution. I see some on our site as well, not nearly as 
   many as you found but over 1800. The keys are mostly checkboxes that are unchecked
   and extension fields that are unfilled. Examples are when auto open is not enabled
   its still storing a meta key for each auto open setting.
 * Will look into better way of storing that info.
 * [https://github.com/PopupMaker/Popup-Maker/issues/62](https://github.com/PopupMaker/Popup-Maker/issues/62)
 *  Thread Starter [MLH17](https://wordpress.org/support/users/mlh17/)
 * (@mlh17)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009447)
 * [@daniel](https://wordpress.org/support/users/daniel/) – Thanks for your reply.
   
   A friend of mine, a database specialist, helped me with cleaning, and he said
   the empty entries of popup ‘occupied’ about 12 MB in the database. Thanks a lot
   for the hint with the revisions – I will check this; perhaps this is the main
   problem – I will report. kind regards Markus
 *  Plugin Author [Daniel Iser](https://wordpress.org/support/users/danieliser/)
 * (@danieliser)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009450)
 * If your using phpMyAdmin it actually has a size stat, should be pretty easy to
   determine exact size next time 🙂
 * It likely is revisions though.
 * Gonna work on it for future versions.
 *  Thread Starter [MLH17](https://wordpress.org/support/users/mlh17/)
 * (@mlh17)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009508)
 * @ Daniel
    I did the deleting of old revisions and some other optimization, and
   now the stats in the database show a size of 13 MiB overall – so, everythings
   seems to be fine again 🙂 Thanks a lot for your support !! I will check the database
   from time to time, and Popup Maker is running again 🙂
 * sunny greetings from Berlin
 * Markus
 *  Plugin Author [Daniel Iser](https://wordpress.org/support/users/danieliser/)
 * (@danieliser)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009533)
 * [@mlh17](https://wordpress.org/support/users/mlh17/) – Awesome, glad to hear 
   it. I will be making many optimizations in future versions to reduce this, including
   making revisions optional.
 * Please take a moment to [rate and review the plugin](https://wordpress.org/support/view/plugin-reviews/popup-maker)
   and or support.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘huge problem with database size !’ is closed to new replies.

 * ![](https://ps.w.org/popup-maker/assets/icon-256x256.gif?rev=3097653)
 * [Popup Maker - Boost Sales, Conversions, Optins, Subscribers with the Ultimate WP Popup Builder](https://wordpress.org/plugins/popup-maker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/popup-maker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/popup-maker/)
 * [Active Topics](https://wordpress.org/support/plugin/popup-maker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/popup-maker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/popup-maker/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [size](https://wordpress.org/support/topic-tag/size/)

 * 7 replies
 * 2 participants
 * Last reply from: [Daniel Iser](https://wordpress.org/support/users/danieliser/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/huge-problem-with-database-size/#post-6009533)
 * Status: resolved