Update: bugfix release b2v6 available.
Some conversations with Chow Kah Soon, who’s site is full of diversions from work , finally convinced encouraged me to solve some small problems that were giving him big trouble. Chow Kah Soon is in the lucky, but rare, position of having over 20,000 unique daily visitors to his site, so he’s sort of my designated stress-tester.
After looking at the logs he shared with me, the table structure, and the queries in bsuite, it was pretty clear that I needed to make some changes to the indexes.
Optimizing the indexes was easy, but how can I make bsuite update those indexes on existing installs? That’s where these docs explaining WordPress’ rather unique dbDelta function come in:
Instead of using a normal $wpdb query to make our table, there is a special function in WordPress that we’ll use that can create a table if it isn’t there, or change the structure if it doesn’t match the current table. This will come in very handy if we ever need to make changes to the MySQL structure in the future.
The function’s a little finicky, and it took me a couple minutes to realize that it was tripping up on the backtick quotes (`) I had wrapped around my table and field names. But with that out of the way, it solves the big problem of how to easily add indexes to existing tables. What it doesn’t solve, sadly, is how to delete existing indexes that aren’t in the new table definition.
With the dbDelta function implemented, I also finally got around to implementing an auto-install hook that creates or re-configs the tables upon plugin activation. Here’s the example from the docs:
add_action('activate_pluginurl','jal_install');
But I had to Google for this support forum post to understand what the “pluginurl” should be.
…you simply have to use the path of your plugin relative to /wp-content/plugins. Eg: you have a plugin in /wp-content/plugins/wp-spamfilter/wp-spamfilter.php then you have to call add_action as following:
add_action(‘activate_wp-spamfilter/wp-spamfilter.php’, ’somefunction’);
Yes, all of these updates will be released soon. I promise.
bstat, bsuite, Chow Kah Soon, documentation, KahSoon.com, mysql, optimization, update, wordpress
Related:
Posted April 5, 2006 by Casey
Categories: Technology. Tags: bstat, bsuite, Chow Kah Soon, documentation, KahSoon.com, mysql, optimization, update, wordpress.
4 Comments
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
www.sexvıew.net (148) - sex footo (70) - www sex wiew com (59) - footo sex (50) - sex view (41) - www.sex wiew.com (41) - sex wiew com (41) - google (38) - sex wiew (33) - sex view plugin (26) - sex wiew.com (25) - bsuite (24) - google earth (24) - sex (21) - sex wiew net (21) - sexview plugin (20) - WWW SEX VIEW TV (19) - sexv tv (19) - sexview hack (19) - www.sex vew.com (17) - www.sex.view (17) - Chow Kah Soon (16) - sex view tv (16) - wordpress dbDelta (15) - www.sex.view.it (15) - www sex wiew (15) - footo (15) - www.sex.wıew.com (14) - sexview (14) - goole (14) - WWW SEX VIEW IT (13) - WWW.SEX.WİEW.NET (13) - wwwsexview.com (13) - www sex wiew net (13) - s (12) - plugins sexview (12) - plugin sexview (12) - www sex wiew tv (12) - www.sex wiew.net (12) - time passing quote (12) - xxx (12) - sexv.tv (12) - kah soon (11) - WWW SEX VIEW (11) - activate pluginurl (11) - plugins sex view (11) - xxl (11) - www.sex vıew (11) - WWW SEX View TV Com (10) - www.sex.view.tv (10) - sex wiew tv (9) - plugin sex view (9) - WWW.SEX VIEW TV.COM (8) - sexview plugins (8) - www.sex view.tv (8) - sex.wiew.com (8) - SEX VIEW plugins (8) - www.sex.view.tv.com (8) - www.sex view.it (7) - site:maisonbisson.com www.sexvıew.net (7) - xxxl (7) - sex view.it (7) - sexs wiew (7) - definition google com (6) - sexcom (6) - www.sex view xxx.com (6) - www.sex wiew (6) - plugins for sex view (6) - www.sexv?ew.net (6) - sex vew (5) - hack the world com (5) - HACK SEXVIEW (5) - sex.vıew (5) - sexs wiew com (5) - sexv (5) - www.sex view tv (5) - www sexv?ew net (5) - sex view hacken (5) - sex view tv com (5) - www sex vıew net (5) - kahsoon com (5) - www.sex vıew.tv.com (5) - mss (5) - sex wiew.net (5) - sex view plug (5) - sex view hack (5) - XXXL SEXCOM (5) - sex wiew xxx (4) - sexs vew (4) - hacking the world com (4) - www.sex.wiew.com. (4) - plugin for sexview (4) - hot FOOTO (4) - xxl footo (4) - add action activate pluginurl jal install (4) - footo xxx (4) - sexview hacken (4) - definition google (4) - big car in world (4) - sexx wiew (3) - video wiew (3) - wiew-com (3) - عن sexx (3) - sexs view (3) - footo de xxx (3) - sexview tv (3) - 6012379453158 (3) - Google Video hacking (3) - xxx xxxl sexv (3) - sex vew.com (3) - plugins for sexview (3) - plugin sex (3) - sex view it (3) - sex view hot (3) - sexvıew.net (3) - www.sexv.ew.net (3) - sex view.tv (3) - www;sexv[ew;net (3) - www. sexsi wiew.net (3) - hot (3) - sibel can footo (3) - www.sex vew vedio (3) - spamfilter php (3) - hacking sex (3) - plugins sex (3) - www.sexv.tv.com (3) - sex f lmi (3) - l (3) - sexs vew xxx (3) - sex.view.xxx.com (2) - sexview tv hack (2) - footo sexsex (2) - w w w . sexview .net (2) - Sex View TV hacken (2) - wordpress dbdelta won t create table (2) - hacking spacer gif (2) - xxxl for hacking (2) - PLUGIN SEX WIEW (2) - hot sexy footo (2) - more on hacking (2) - sex vew tv.com (2) - wwwsexvıew com (2) - sexx video.google.com sexx (2) - footo 18 sex (2) - sex.vıew.plug (2) - www:sex view: tv (2) - footo sex sex (2) - sex.footo (2) - hacking sex view (2) - www.sex.wiew.net. (2) -
Looking forward to it!
I’ve tried twice recently to deactivate this plugin so it is only active when I want to view it (thinking it would be less of a load, just like my wp-slimstat suggest doing for their’s) but each time I tried with bsuite, my blog site goes completely void of data; the only thing displayed is my theme lol. Needless to say, I leave it active all the time now, have you run across this before? TIA.
Thanks for your great plugin!
I’ve noticed a small error in bsuite.php on l. 753: instead of using the variable get_settings(’home’) you should use the variable get_settings(’siteurl’), otherwise you won’t get the right path to spacer.gif in case wordpress is not in the same directory as index.php.
By the way, do you include RSS feeds in your stats?
Thx for the response, guess I won’t be getting one for this either… no updates since I saw you visit yesterday. Interesting.
[...] This version finally creates and configures it’s tables automatically upon activation. You no longer need to visit the plugin’s option screen for this to happen. [...]