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
Posted April 5, 2006 by Casey Bisson
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 (151) - sex footo (72) - www sex wiew com (59) - sex view (54) - footo sex (50) - www.sex wiew.com (42) - sex wiew com (41) - google (38) - sex wiew (37) - sex view plugin (26) - bsuite (25) - sex wiew.com (25) - google earth (24) - sex (21) - sexv tv (21) - sex wiew net (21) - sexview plugin (20) - WWW SEX VIEW TV (19) - sexview hack (19) - www.sex vew.com (18) - www.sex.view (17) - sex view tv (17) - sexv.tv (16) - wordpress dbDelta (16) - Chow Kah Soon (16) - footo (15) - www.sex.view.it (15) - www sex wiew (15) - www.sex.wıew.com (14) - goole (14) - sexview (14) - wwwsexview.com (14) - www sex wiew net (13) - WWW.SEX.WİEW.NET (13) - WWW SEX VIEW IT (13) - s (12) - www sex wiew tv (12) - time passing quote (12) - plugins sexview (12) - xxx (12) - plugin sexview (12) - www.sex wiew.net (12) - kah soon (11) - WWW SEX VIEW (11) - www.sex vıew (11) - www.sex view.tv (11) - plugins sex view (11) - activate pluginurl (11) - xxl (11) - www.sex.view.tv (10) - WWW SEX View TV Com (10) - plugin sex view (9) - sex wiew tv (9) - WWW.SEX VIEW TV.COM (8) - sexview plugins (8) - sex.wiew.com (8) - SEX VIEW plugins (8) - www.sex.view.tv.com (8) - www.sexv.tv.com (8) - sex view.it (7) - site:maisonbisson.com www.sexvıew.net (7) - sexs wiew (7) - www.sex view.it (7) - sexv (7) - xxxl (7) - sexcom (6) - www.sex view xxx.com (6) - plugins for sex view (6) - definition google com (6) - www.sexv?ew.net (6) - www.sex wiew (6) - عن sexv (6) - HACK SEXVIEW (5) - www sexv?ew net (5) - www.sex vıew.tv.com (5) - hack the world com (5) - sex view plug (5) - sex wiew.net (5) - sexs wiew com (5) - sex view hack (5) - sexs view (5) - mss (5) - kahsoon com (5) - www sex vıew net (5) - sex view tv com (5) - sex view hacken (5) - www.sex view tv (5) - sex vew (5) - sex.vıew (5) - XXXL SEXCOM (5) - definition google (4) - plugin for sexview (4) - xxl footo (4) - www. sexsi wiew.net (4) - sexview hacken (4) - hot FOOTO (4) - www.sibel can sexs.com (4) - www.sex.wiew.com. (4) - add action activate pluginurl jal install (4) - sex wiew xxx (4) - footo xxx (4) - big car in world (4) - sexs vew (4) - hacking the world com (4) - عن sexx (3) - plugins for sexview (3) - sibel can footo (3) - sexview tv (3) - 6012379453158 (3) - www.sexv.ew.net (3) - video wiew (3) - www.sex vew vedio (3) - Google Video hacking (3) - footo de xxx (3) - wiew-com (3) - sexs vew xxx (3) - sexvıew.net (3) - sexx wiew (3) - plugins sex (3) - sex view it (3) - spamfilter php (3) - www;sexv[ew;net (3) - sex f lmi (3) - sex view.tv (3) - l (3) - sex view hot (3) - plugin sex (3) - xxx xxxl sexv (3) - hot (3) - sex vew.com (3) - hacking sex (3) - sexs wıew.com (2) - footo sex sex (2) - www.sex.wiew.net. (2) - www:sex view: tv (2) - more on hacking (2) - footo 18 sex (2) - sexv xxl (2) - www.sex blue film.com (2) - wordpress dbdelta won t create table (2) - hacking spacer gif (2) - www.sex view tv. (2) - xxxl for hacking (2) - PLUGIN SEX WIEW (2) - www. sex vıew.tv net (2) - footo sexsex (2) - sex.view.xxx.com (2) - wwwsexvıew com (2) - gif footo sex (2) - hacking sex view (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. [...]