http://wordpress.org/support/ WordPress › Support Tag: db-cache en Thu, 26 Nov 2009 13:25:41 +0000 http://wordpress.org/support/topic/306979#post-1279766 Fri, 13 Nov 2009 07:38:11 +0000 marsev 1279766@http://wordpress.org/support/ <p>I just tried version 1.4.2 with WPMU but it still does not work. In the moment I activate the plugin and visit my website, I am redirected to the page, where it is said that this domain is not set up and a new WPMU-blog can be created. </p> <p>Any other experiences? </p> http://wordpress.org/support/topic/275443#post-1245989 Wed, 14 Oct 2009 10:54:49 +0000 Erunafailaro 1245989@http://wordpress.org/support/ <p>There is a new plugin that does the same as DBCache and it is working with WP2.8+:</p> <p><a href="http://wordpress.org/extend/plugins/db-cache-reloaded/">DB Cache Reloaded</a></p> <p>So the solution for all of you would be to uninstall DBcache 0.6 and to install <a href="http://wordpress.org/extend/plugins/db-cache-reloaded/">DB Cache Reloaded</a> instead. </p> http://wordpress.org/support/topic/275443#post-1245902 Wed, 14 Oct 2009 08:31:18 +0000 KillerSneak 1245902@http://wordpress.org/support/ <p>I can confirm this porblem. It started to happen yesterday. Also using:</p> <p><strong>WordPress 2.8.4</strong><br /> <strong>DBcache 0.6</strong></p> <p>I hope this will get fixed soon as DBcache really did speed up my site allot. </p> http://wordpress.org/support/topic/237479#post-1231343 Thu, 01 Oct 2009 12:07:04 +0000 x00374 1231343@http://wordpress.org/support/ <p>You need to CHMOD db-config.ini in wp-content folder. </p> http://wordpress.org/support/topic/306979#post-1230595 Wed, 30 Sep 2009 20:00:09 +0000 sirzooro 1230595@http://wordpress.org/support/ <p>I have updated plugin, so it should look for included file in correct place. It also detects and handles erroneous situations now, so it should not crash whole site as before.</p> <p>WPMU is not officially supported yet - I plan to do so in one of next releases. However with last updates you should be able to run DB Cache Reloaded on WPMU - please update to version 1.1 and try again. </p> http://wordpress.org/support/topic/306979#post-1213095 Tue, 15 Sep 2009 21:37:10 +0000 Bonusball 1213095@http://wordpress.org/support/ <p>I installed this on my wp 2.8 MU installation, immediately my site went down, it couldn't find some files it needed in db.php</p> <p>I deleted the plugin, and deleted those files, and got my site back.</p> <p>I modified /wp-content/ to make sure it was writeable, and then reinstalled the plugin, and the site went down again.</p> <p>I can't recommend this plugin to anyone, as much as I wanted it to work! </p> http://wordpress.org/support/topic/306979#post-1197019 Wed, 02 Sep 2009 19:46:21 +0000 sirzooro 1197019@http://wordpress.org/support/ <p>Hi All,<br /> Please take a look on a <a href="http://wordpress.org/extend/plugins/db-cache-reloaded/">DB Cache Reloaded</a> plugin. I took last version od DB Cache (0.6) and updated it to make it compatible with WordPress 2.8.x. Additionally I have cleaned up the code, so few annoying bugs should be fixed now (especially the tags one). </p> http://wordpress.org/support/topic/234465#post-1196851 Wed, 02 Sep 2009 17:46:05 +0000 Pinoy.ca 1196851@http://wordpress.org/support/ <blockquote><p>it may be possible that the cpu overhead of parsing the cache is equal to the i/o overhead of calling the database if you are dealing with small queries. I'd be interested to get some input from others on this. </p></blockquote> <p>This is seen very easily with a <code>define(&#39;SAVEQUERIES&#39;, true);</code> (as per <a href="http://codex.wordpress.org/Editing_wp-config.php#Save_queries_for_analysis" rel="nofollow">http://codex.wordpress.org/Editing_wp-config.php#Save_queries_for_analysis</a> ) and a simple hack on <code>db-module.php</code> (and also to the copy in <code>/wp-content/db.php</code>). Add the following somewhere near line 720:</p> <pre><code>if ( defined(&#39;SAVEQUERIES&#39;) &amp;&amp; SAVEQUERIES ) $this-&gt;queries[] = array( $query, $this-&gt;timer_stop(), $this-&gt;get_caller(), &quot;Cache hit&quot; );</code></pre> <p>(Posterd, you may like to commit this hack to your code.)</p> <p>Then load a page in two browser windows, one minute apart. </p> <p>It will be evident that DB Cache shaves milliseconds on some queries such as queries with JOINs. </p> http://wordpress.org/support/topic/294694#post-1196834 Wed, 02 Sep 2009 17:26:44 +0000 Pinoy.ca 1196834@http://wordpress.org/support/ <p>If "doing a 'large number of MySQL calls.'" is your problem then use the DB Cache plugin. DB Cache cuts down the number of actual SQL calls by caching previous SQL queries to the filesystem. </p> http://wordpress.org/support/topic/243172#post-1196739 Wed, 02 Sep 2009 15:49:45 +0000 Pinoy.ca 1196739@http://wordpress.org/support/ <p>1) Oui, monsieur.</p> <p>2) <code>dbc_clear</code> only deletes expired cache files.</p> <p>3) some queries and situations are automatically skipped:</p> <pre><code>// cache only frontside if ( defined(&#39;DOING_CRON&#39;) || strpos($_SERVER[&#39;REQUEST_URI&#39;],&#39;wp-admin&#39;) || strpos($_SERVER[&#39;REQUEST_URI&#39;],&#39;wp-login&#39;) || strpos($_SERVER[&#39;REQUEST_URI&#39;],&#39;wp-register&#39;) || strpos($_SERVER[&#39;REQUEST_URI&#39;],&#39;wp-signup&#39;) || preg_match(&quot;/\\s*(insert|delete|update|replace|alter|SET NAMES|FOUND_ROWS)/si&quot;,$query) ) $dbc_cachable = false; // for hard queries if (preg_match(&quot;/\\s*(JOIN | \* |\*\,)/si&quot;,$query)) $dbc_cachable = true;</code></pre> <p>3) Yes<br /> 4) No, see #2<br /> 5) See above conditions. </p> http://wordpress.org/support/topic/252983#post-1196721 Wed, 02 Sep 2009 15:40:02 +0000 Pinoy.ca 1196721@http://wordpress.org/support/ <blockquote><p>If it does offer improvements, then likely your mySQL server needs some work.</p></blockquote> <p>Retrieving a past query result from the file system may be faster than a JOIN.</p> <p>The plugin is better for shared hosting where one can't tweak the MySQL config (query cache).</p> <p>Plus, with this plugin's "$tag" system, one can quickly hack it such that certain queries are cached longer, shorter or not at all. </p> http://wordpress.org/support/topic/302930#post-1188068 Tue, 25 Aug 2009 23:54:41 +0000 bseidner 1188068@http://wordpress.org/support/ <p>The DB cache Plugin settings need to be changed </p> http://wordpress.org/support/topic/302930#post-1185765 Mon, 24 Aug 2009 07:52:29 +0000 fkrauthan 1185765@http://wordpress.org/support/ <p>What do you mean. Must i update my plugin so it works with the cache plugin? or what?^^ </p> http://wordpress.org/support/topic/294431#post-1184241 Sat, 22 Aug 2009 16:17:45 +0000 stevemagruder 1184241@http://wordpress.org/support/ <p>I've run into this too. After disabling DB Cache, the error went away.</p> <p>Note that this error displays when editing a page, not a post. And when saving changes to a page, it goes to a white screen with error messages, even those the changes are saved anyway.</p> <p>I hope the author fixes this problem so I can re-enable this very valuable plugin. </p> http://wordpress.org/support/topic/302930#post-1182708 Fri, 21 Aug 2009 02:22:26 +0000 bseidner 1182708@http://wordpress.org/support/ <p>set your Cache filter to this: _posts|_postmeta|_usermeta|_useronline|_users|wp_wp_mpdf_allowed</p> <p>Do not cache queries that contains this input contents. Divide different filters with '|' (verical line, '_posts|_postmeta') </p> <p>Hopefully this plugin gets updated.</p> <p><a href="http://wordpress.org/extend/plugins/db-cache/" rel="nofollow">http://wordpress.org/extend/plugins/db-cache/</a> </p> http://wordpress.org/support/topic/275443#post-1181676 Thu, 20 Aug 2009 10:47:39 +0000 tommix 1181676@http://wordpress.org/support/ <p>No need to disable any plugins when upgrading... it have nothing to do with upgrading. There is something wrong in your installation, not with wordpress. i ALWAYS upgrading without backuping DB or disabling plugins-it works always. </p> http://wordpress.org/support/topic/294431#post-1181653 Thu, 20 Aug 2009 09:58:03 +0000 mattwaddell 1181653@http://wordpress.org/support/ <p>Also had the same issue, so I too disabled DB cache v0.6 and the error was gone.</p> <p>Thanks for posting! </p> http://wordpress.org/support/topic/275443#post-1175817 Sat, 15 Aug 2009 06:21:54 +0000 quartzimodo 1175817@http://wordpress.org/support/ <p>I'm glad that I'm not alone with the admin panel comment editing problem after upgrading to the earliest version of WP 2.8. As I hadn't been posting new entries in my watch <a href="http://quartzimodo.com/">blog</a> since last April, I didn't notice any problems until very recently.</p> <p>I did not realize that DB Cache was incompatible with version 2.8 upwards, thinking it was a quirk of WP 2.8. Currently I'm running WP 2.8.4 and after seeing that the comment editing and tagging problems persistent, I Googled for an answer and found a post stating that DB Cache was the culprit.</p> <p>I disabled DB Cache and tried to edit one of my readers' comments. It worked flawlessly. When I re-enabled DB Cache, the symptoms returned. I later found out that the author of DB Cache has yet to update this plugin to work with WP 2.8.x.</p> <p>IMO, my blog appears to perform faster with DB Cache enabled (along with WP Super-Cache), therefore while waiting for DB Cache to be updated for compatibility with WP 2.8 all I have to do is to temporarily disable it when I have to edit comments and turn it back on when I'm done.</p> <p>I know it's not an elegant workaround but I'm already addicted to DB Cache until I find something equivalent or better. :-)</p> <p>On an unrelated note, I also discovered that the automatic upgrade of WP core files within the admin panel usually fails unless I <strong>manually disable</strong> all active plugins. While the instructions tell you to back up your databases before upgrading (of course I do backup my WP database before performing the auto upgrade), WP unfortunately doesn't tell you to disable your plugins first.</p> <p>I assumed that the upgrade job will take care of that for you (for example, upgrading an individual plugin within the admin panel will <strong>automatically disable</strong> the current plugin first), but it looks like WP doesn't disable all of your plugins. </p> <p>You have to remember to disable all active plugins first before performing the automatic WP version upgrade and go through the list of plugins that require manual enabling <strong>after</strong> upgrading to the latest WP version. A good example is the WP Super Cache plugin, which always defaults to "OFF" whenever it is disabled albeit temporarily. </p> http://wordpress.org/support/topic/298212#post-1174976 Fri, 14 Aug 2009 14:23:29 +0000 Ramoonus 1174976@http://wordpress.org/support/ <p>this plugin is out-dated :-( </p> http://wordpress.org/support/topic/300409#post-1174975 Fri, 14 Aug 2009 14:22:58 +0000 Ramoonus 1174975@http://wordpress.org/support/ <p>the only thing you have to do is enable the plugin and make the caching folder<br /> as in the readme </p> http://wordpress.org/support/topic/300409#post-1173881 Thu, 13 Aug 2009 16:47:16 +0000 usera 1173881@http://wordpress.org/support/ <p>I cannot seem to figure out if db-cache is working on wordpress 2.84. The problem is that in the source it says db cache has cached it but I do not see any files or even the directory wp-content/tmp or the file db.php. Also the queries does not seem to be reduced as I have a footer that displays load speed and queries.</p> <p>Thanks for any info. </p> http://wordpress.org/support/topic/298212#post-1168626 Sun, 09 Aug 2009 11:43:08 +0000 Marcomail 1168626@http://wordpress.org/support/ <p>mmm i don't know if it's possible or not, but in the admin panel it's very noise every time disable the db-cache plugin </p> http://wordpress.org/support/topic/298212#post-1167348 Fri, 07 Aug 2009 23:58:57 +0000 tommix 1167348@http://wordpress.org/support/ <p>it don't supose to do that. </p> http://wordpress.org/support/topic/298212#post-1166528 Fri, 07 Aug 2009 11:24:56 +0000 Marcomail 1166528@http://wordpress.org/support/ <p>is there some way for the next release of this plugin doesn't cache queries under the admin panel ? Thanks</p> <p><a href="http://wordpress.org/extend/plugins/db-cache/" rel="nofollow">http://wordpress.org/extend/plugins/db-cache/</a> </p> http://wordpress.org/support/topic/294694#post-1165525 Thu, 06 Aug 2009 17:11:51 +0000 donncha 1165525@http://wordpress.org/support/ <p>That's a lot of posts but it can be handled. Install wp-super-cache and that will help. </p> http://wordpress.org/support/topic/294902#post-1154995 Wed, 29 Jul 2009 07:23:33 +0000 Gautier_Girard 1154995@http://wordpress.org/support/ <p>There is small bug while using db cache and simple tags, when editing a post.</p> <p>Please see it and how to solve it (hopefully) :</p> <p>-&gt; What steps will reproduce the problem?<br /> 1. Install Simple Tags &amp; DB-Cache plugins<br /> 2. Create a New post, add tags, save<br /> 3. Edit tags within the post and Save post</p> <p>-&gt; What is the expected output? What do you see instead?</p> <p>Tags should be updated but it's not the case: DB-Cache displays former tags instead of new entered tags.</p> <p>-&gt; What version of the product are you using? On what operating system?</p> <p>Simple Tags 1.5.6<br /> DB-Cache : 0.6</p> <p>-&gt; Please provide any additional information below.</p> <p>To solve this :<br /> - edit db-cache.php<br /> - go to line 100 '// Add cleaning on publish and new comment'<br /> - Below these lines :<br /> add_action('publish_post', 'dbc_clear', 0);<br /> add_action('edit_post', 'dbc_clear', 0);<br /> add_action('delete_post', 'dbc_clear', 0);<br /> - Add these two lines :<br /> add_action('clean_page_cache', 'dbc_clear', 0);<br /> add_action('clean_post_cache', 'dbc_clear', 0);</p> <p>That's all.</p> <p>DB Cache is great!</p> <p>Gautier</p> <p><a href="http://wordpress.org/extend/plugins/db-cache/" rel="nofollow">http://wordpress.org/extend/plugins/db-cache/</a> </p> http://wordpress.org/support/topic/294694#post-1154254 Tue, 28 Jul 2009 17:20:03 +0000 jbickers 1154254@http://wordpress.org/support/ <p>So we have four WP sites, two of which are rather large. We use posts as a tool to drive a real-time playlist of songs we're playing, so the result is we're posting a new (blank, except for the title) post every 3 minutes or so. (One of the sites in question is wfpk.org, if it helps to see it.)</p> <p>We had been hosting the sites internally, and several times a day they would slow to a crawl, if not halt entirely. They were on a crappy box, so the powers that be decided to move us to a hosting company with plenty of server juice.</p> <p>We did just that, migrated and got everything running, and it looks great, moving much faster. Then, out of nowhere, our host suspends our accounts, saying that our CPU usage was pegging the needle - doing a "large number of MySQL calls."</p> <p>So, trying to figure this out. I know there are many WP sites out there larger than ours. But I wonder if the sheer number of posts in a single day - and, as a result, the sheer number that would need to be looked up by the calendar widget - is somehow prohibitive. I've just installed/activated WP-SuperCache on all the sites, so we'll see if that does anything.</p> <p>But any other ideas? </p> http://wordpress.org/support/topic/294431#post-1153313 Mon, 27 Jul 2009 23:09:54 +0000 Erikam45 1153313@http://wordpress.org/support/ <p>I got the error message</p> <blockquote><p>Warning: implode() [function.implode]: Invalid arguments passed in /home/.garaged/mm/mm.net/blog/wp-includes/post.php on line 1762</p> </blockquote> <p>by using Wordpress 2.8.2 and plugins <strong>Google XML Sitemaps</strong> v3.1.4, <strong>WP Widget Cache</strong> v0.25.2, <strong>HyperCache</strong> v2.3.2 and <strong>DB Cache</strong> v0.6 together on three blogs with different themes. After deleting all files cached by <strong>DB Cache</strong> v0.6, disabling the caching process AND deactivation of the plugin the error messages were gone and all blogs came back with better performance.<br /> Maybe we've to wait this plugin will be updated! </p> http://wordpress.org/support/topic/275443#post-1151203 Sat, 25 Jul 2009 21:13:36 +0000 designshard 1151203@http://wordpress.org/support/ <blockquote><p>Problem exists with WP 2.8.2 and DB Cache Version 0.6. I had to disable the plugin for now. </p></blockquote> <p>I have the same problem i hope an update comes out soon, i wanted to change from wp-supercache :( </p> http://wordpress.org/support/topic/275443#post-1148966 Thu, 23 Jul 2009 19:06:24 +0000 olex0003 1148966@http://wordpress.org/support/ <p>Problem exists with WP 2.8.2 and DB Cache Version 0.6. I had to disable the plugin for now. </p>