WordPress
Майстер класи WordPress
DB Cache plugin
The fastest cache engine for WordPress, that produces cache of database queries with easy configuration.
Description
This plugin caches every database query with given lifetime. It is much faster than other html caching plugins and uses less disk space for caching.
I think you’ve heard of WP-Cache or WP Super Cache, they are both top plugins for WordPress, which make your site faster and responsive. Forget about them – with DB Cache your site will work much faster and will use less disk space for cached files. Your visitors will always get actual information in sidebars and server CPU loads will be as low as posible.
See the DB Cache homepage for further information.
Installation
1. You should upload the db-cache folder to your wp-content/plugins
2. Go to your Plugins page and activate “DB Cache”
3. Now go to Settings->DB Cache and enable caching of DB queries. The plugin will create wp-content/tmp folder and db.php file for serving cached queries in wp-content folder.
That’s all! Enjoy the speed of loading pages.
Frequently Asked Questions
How do I know my blog is being cached?
Check your cache directory wp-content/tmp/ for cache files.
How can I ensure of reducing server usage?
View the source of your site page, there maybe some code like this at the foot:
<!– 00 queries. 00 seconds. –>
If not, please put these codes in your footer template:
<!– <?php echo get_num_queries(); ?> queries. <?php timer_stop(1); ?> seconds. –>
After using the DB Cache, I think you’ll find the number of ‘queries’ reducing a lot.
Why is DB Cache better than WP Super Cache?
This plugin is based on a fundamentally different principle of caching queries to database instead of full pages, which optimizes WordPress from the very beginning and uses less disk space for cache files because it saves only useful information.
It saves information separately and also caches hidden requests to database.
Troubleshooting
Make sure wp-content is writeable by the web server. If not you’ll need to chmod wp-content folder for writing and also config.ini file in plugin folder.
How do I uninstall DB Cache?
1. Disable it at Settings->DB Cache page. The plugin will automatically delete all cache files.
2. Deactivate it at plugins page.
Other Notes
Updates
Updates to the plugin will be posted here and the Ukrainian WordPress will always link to the newest version.
Thanks
I would like to thank Lviv for giving me the idea for this and RKG for support.
Download
Downloaded a total of 3244 times
Thanks everybody for comments. I’ve already noticed loads to filesystem instead of SQL. Searching the ways to optimize caching processes. Paul, Raul thanks for ideas!
amazing plugin,I really need this plugin.thx！
[...] destiné qu’aux utilisateurs de Wordpress. J’ai découvert et mis en place ce plugin DBcache et j’en suis très satisfait. Vous qui connaissez mon blog pour le lire, vous avez [...]
Great plugin!! Thanks!
[...] qualche giorno sto provando DB Cache che ha un funzionamento diverso: invece di creare versioni statiche delle pagine e servire queste [...]
It’s like db cache stopped working for me. See this report on mysql usage.
DB cache has been partially enabled on the 16th, and fully enabled the days 17, 18, 22 and 23. On days 16, 17 and 18 was installed db cache v.5 and on days 22 and 23 db cache v.6
As you can see days 17, 18 are under the mean (which is, looking at previous month, 7500) for queries but days 22 and 23 are over the mean.
with v.5 cache time was 120 minutes; with v.6 was 240 minutes, tables excluded: “_posts|_postmeta|_statpress”.
To end my report, I looked at the plugin report in the footer: on 17 and 18 it said (in home page) 2 queries done, 20 in the cache; on 22 and 23 (and now) it says: 9 queries, 13 in the cache. Nothing change if I remove _statpress from the non-cached tables.
Consider that nothing changed in the theme.
Do you have any idea of this strange behaviour?
The options page doesn’t exist. How do I rach the settings?
I’ve discovered today that db-cache also cache queries for the admin panel. Since you don’t know what others plug-in do (or even wp) in the admin panel maybe it’s a good idea not to cache wp-admin queries.
Just to give an example: if you install Gigs Calendar, you’ll find that if you add a venue or a performance, they won’t be shown in the admin panel, even if you’ve added them to the database (and this is nasty, because you can’t add performances if you haven’t a venue).
I filtered these tables and everything worked again, then I modified a category name, but that was cached, too and I needed to clear the cache to see the new category name.
I decided to give it another try since your recent update but it seems that your plugin doesn’t like my system. It locked up my site producing the following error:
Cannot redeclare class wpdb in /domains/discover-rhodes.com/html/wp-content/db.php on line 54
Any clues?
Don’t have any ideas on it.
At the moment I’m working on new caching method. Hope there will no be any problems like this
This is my first time installing this plugin. When I activated I get a error saying Fatal error: Cannot redeclare class wpdb in /home/ruriko/public_html/wp-content/db.php on line 54
What is wrong?
I indeed get the same redeclare $wpdb problem so I disabled it very quickly :( Look forward to an update!
[...] Cachowanie zapytań do bazy danych – plugin DB Cache [...]
[...] plugins available which I can try. I already mentioned Hyper Cache last time and today I discovered DB Cache (h/t diTii.com) which seems particularly promising, especially because it works not by [...]
[...] activado siempre), es cachear todas las querys que se realizan a la bbdd, esto es posible gracias a DB Cache. (el autor se jacta a decir es muchísimo mas superior que [...]
try again, please clean up for me… sorry ;(
Home page cache off
Generated in 0.201 seconds. Made 114 queries to database and cached queries. Memory used – 14.01MB
Cached by DB Cache
cache off
Generated in 0.204 seconds. Made 109 queries to database and cached queries. Memory used – 13.97MB
Cached by DB Cache
cache off
Generated in 0.203 seconds. Made 110 queries to database and cached queries. Memory used – 13.97MB
Cached by DB Cache
=================
cache on
Generated in 0.355 seconds. Made 83 queries to database and 27 cached queries. Memory used – 14.07MB Cached by DB Cache
cache on
Generated in 0.257 seconds. Made 88 queries to database and 23 cached queries. Memory used – 14.07MB
Cached by DB Cache
cache on
Generated in 0.218 seconds. Made 85 queries to database and 26 cached queries. Memory used – 14.07MB
Cached by DB Cache
[...] Hat jemand Erfahrung mit diesem WP DB Cache Plugin? Taugt das? http://wordpress.net.ua/db-cache [...]
Installed your plugin on a blog and a content-rich Web site (hochstadt.com and mygermancity.com) and in both cases it doesn’t seem to work? Vising both sites (logged out) it shows the same amount of queries, seconds, memory, and “0″ cached queries.
Any ideas?
~Marcus
Hey guys,
Have any of you attempted to use a “php speedy” with this plugin?
Do they work together? Any adverse effects or extra code?
Thanks!!
They are working together on my site.
This plug-in is incompatible with “Ajax Force Comment Preview ” Please check this
(http://wordpress.org/extend/plugins/ajax-force-comment-preview/)
[...] DB Cache [...]
If Timur it is possible, also I will take, I will place here best-disk.ru
on my site the plugin not works :(
Generata in 3.283 secondi. Effettuate 29 query al database e 0 query nella cache. Memoria usata – 18.89MB
The class define of wpdb in db.php caused some major problems on my site. I couldn’t figure out a working solution.
I had to kill the plugin.
[...] trying to optimise my WP blogs – Is the DB cache plugin really faster than super-cache? http://wordpress.net.ua/db-cache [...]
Its the plugin compatible with wp Lastest version ?
I installed this plugin on 2 blogs and it worked flawlessly.
I then installed it on a 3rd blog and I got this error.
Fatal error: Cannot redeclare class wpdb in /public_html/jobs/wp-includes/wp-db.php on line 53
any thoughts?