Lee.org

View notable entries only
Page 2 of 5«Newer12345Older»

Repair and Optimize your MySQL Database Occasionally

January 24th, 2008 6:26pm. Wordpress

My blog was getting slow so I called Dreamhost support. They wrote back

Okay, I see a pretty big issue. It looks like you’ve got 92MB of overhead (i.e. unoptimized queries) on your blog’s database. Optimizing the queries seems to have knocked your DB down to a more sensible 37.8MB - which can be trimmed further if you go thru and purge any questionable comments in Spam Karma as its tables take up 7.6MB. Go ahead and see how the optimizations have helped and let me know if you happen to have any further questions. I’ll be more than happy to help you get things sorted out if you need me to.
Thanks!
Jason

That helped muchly. I put on my calendar next to flipping my mattress, “Repair blog database tables to remove overhead. Then Optimize tables. Enjoy.”

Installed Search Everything 4.1

October 13th, 2007 11:03pm. Wordpress

I used to have Search Everything installed but it broke in some version of Wordpress. Well, it’s back. Now, when you search on my blog it looks at all of the comments as well as posts. You can also search for phrases with “quotation marks”. :-)

Upgraded to FLV-Embed 0.3.2

September 29th, 2007 10:27pm. Wordpress

FLV-Embed lets me put Flash videos on Wordpress with great ease.

Find it on the FLV-Embed homepage.

Here’s some tidbits from the homepage

(more…)

Upgraded to Wordpress 2.3

September 29th, 2007 10:16am. Wordpress

woopie

How to make Wordpress run faster

June 22nd, 2007 8:30am. Wordpress

To improve the performance of Wordpress, I simply removed all of the unactivated plugin files files from my plugins folder. It’s hard to tell exactly how much this improveds things, but page load times are definitely a little quicker.

I had several Wordpress plugins that weren’t activated but were in the plugins folder. Here’s the list: wp-db-backup.php, backuprestore.php, pagenavi.php, wpPaginate-v2.php, suggest.php, subscribe2.php, search-meter.php, popularity-contest.php, af-extended-live-archive.php, words_in_post.php, hello.php, wysiwordpress.php, textile1.php, markdown.php, enhanced-post-list.php, did_you_pass_math_functions.php, did_you_pass_math.php, challenge.php
Phew, I play a lot with Wordpress plugins :-)

Advertising on my blog

June 20th, 2007 9:07am. General, Wordpress

I’m sure you noticed that there’s now some ads on my site. I’ve been playing with them since May 15th or so. Here’s where I’ve come to…

I put one ad at the bottom of each article page in (what I hope is) a relatively unobtrusive spot with unobtrusive colors. Very popular pages that I don’t care too much about (like this) get a few more ads sprinkled in them.

Google Adsense says that my blog site gets about 500 ad impressions per day. Wordpress stats agrees with that but Analog stats says I’m getting more like 2,000 page views/day in my blog folders… hmm. Maybe it’s that Analog is counting spam bots and web crawlers. On the ads, Google says I have a clickthrough rate of about 0.5%. The site makes $0.50/day…. about $180/year. So the site pays for itself and buys me a nice dinner every few months. You might be able to extrapolate your potential earnings from these numbers.

I suppose it’s worth it.

Fixed delayed comment problem

May 14th, 2007 11:30am. Wordpress

WP-Cache and Spam Karma had an incompatibility. It made it so that when you post a comment to my blog, there was a delay of an hour before you see the comment. Spam Karma 2.3 RC1 fixed that problem.

Hurray

Installed FLV Embed Plugin

March 7th, 2007 11:38am. Wordpress

I can now inundate you with sounds and videos from my vast repertoire thanks to the FLV Embed plugin. I found that WP-FLV had trouble when you’d try to edit an existing post with an flv in it. It would lose the tag due to an incompatibility between the flv tag and the graphical input method in Wordpress 2.1.

To make an entry, I just write something like this:

(open square bracket)flv:http://lee.org/blog/wp-content/uploads/2007/03/swarm.flv 360 270]

Installed Sitemap Generator Plugin

March 6th, 2007 3:19am. Wordpress

I figure that this google sitemap generator can’t hurt my chances of being discovered as a rising budding star.

More interesting is that the sitemap (in the sidebar too) is pretty well human readable.  This tool made that possible.

Upgraded from WP 2.1 to WP 2.1.2

March 2nd, 2007 1:01pm. Wordpress

Dreamhost made it pretty easy to upgrade. Push the button. Wait a while. Tada. :-)

At first blush, it looks like performance is much improved :-))

Update: Ah. Performance increased because Dreamhost automatically upgraded my WP-Cache from 2.0 to 2.1. It appears that WP 2.1 wasn’t compatible with WP-Cache 2.0. All is speedy now.

Update. It was to 2.1.1… now it’s 2.1.2

Installed Flexible Upload Plugin

March 2nd, 2007 12:33pm. Art, Wordpress

Colossus at First Light

WordpressChris Knight’s Slippers from Real Genius 2.0 and 2.1 are peachy kean but one annoyance is the odd hard-coded thumbnail size. Thumbnails are fixed at 100 x 100 pixels or something like that.

The Flexible Upload plugin lets you get past that silly limitation in the WP interface. So now I can specify silly tiny thumnails or gigantic, sumptuous thumbnails, as I see fit. It also has some other nice bells and whistles. :-)

Fiddling with WP Themes

February 15th, 2007 11:23am. Wordpress

One (or more) of my snazzy Wordpress plugins is making my WP2 install run slowly. So I’ll be fiddling with Wordpress plugins for a while. I’ll display another theme for a while until I figure out what’s up. Here’s a pretty theme as a replacement, Thirteen.

Wordpress 2.1 Installed

February 9th, 2007 4:37pm. Wordpress

I just finished installing Wordpress 2.1. If you notice anything wonky, please tell me.

With the installation of WP 2.1, I was finally able to fix Spam Karma’s captcha. That should do a good job against the increasing number of almost-false-negative comment spams.

Installed Snap Previews Plugin

January 21st, 2007 3:27am. Wordpress

After trying out Snap Previews on TJIC’s site for a while, I find them useful. If you disagree, tell me.

If you dislike it, it can be turned off of all the sites you visit by clicking on “options” when a Snap-thingie pops up. I’m still wondering whether letting Snap look over my users’ shoulders is the right thing to do… hmmm.

I had a little trouble installing it with my theme. My custom theme didn’t initially have the following standard code in the footer template: <?php wp_footer(); ?>

update 6-22-07: I removed it after using it for a while.

  • While the popup is coming up, you can’t click on the link; this happened a lot.
  • I started seeing some semi-pseudo advertising going on. I forget exactly what. Maybe it was “search for pages like this one” or some such. And there is a Firefox “search plugin” for users… so they’re using the plugin to get data from me.
  • Why in the world would I want the Snap popup to have a “search the web” text box? -That- is advertising.
  • It was kinda annoying.

Changed Subscribe to Comments Default

January 17th, 2007 3:30pm. Wordpress

Please note that I changed it so that if you want to subscribe to comments while you are leaving your own comment, you have to check the check-box.

(this should reduce the number of bounces I get from fictitious people like WinFreeViagra@yahoo.net.

Installed Math Comment Spam Protection Plugin

January 11th, 2007 12:54am. Wordpress

(note: I disabled the plugin. See the comments for more info)

To try and keep the 100+ comment spams per day out of my life (and even my ‘moderated’ pile), I’ve installed Math Comment Spam Protection. I’ve tried several “makes you add two numbers” plugins and this one seems to work best with what I have. If it makes posting comments too terrible, please tell me…. in a comment… or…. whatever.

Installed Challenge Plugin

November 6th, 2006 1:56pm. Wordpress

update: I removed this plugin. I now just trust in Spam Karma

Spam Karma does a great job of managing my comment spam. But I’d like to do more to keep those 500 comment spams/day out of my database entirely. So I’ve installed the Challenge plugin. It’ll make you do math in order to leave a comment. Spammers hate math. It’s like their kryptonite. I hope you don’t hate math so much as to not leave a comment.

Installed FastCGI

November 5th, 2006 12:23am. Wordpress

Update Feb 10, 2008: See this post where it is now successfully installed! W00t!

Update Nov 10, 2006: FastCGI isn’t stable. So I am disabling it. I’d sometimes see a 30 second timeout error right next to a 2 second load time. It just isn’t stable. :-( Sometimes it would crap out on an upload, sometimes on downloads…

The whole site should be much faster now that I’ve set up FastCGI on my Dreamhost account :-)

Here’s how I had configured it:Put the following at the beginning of the .htaccess file of the directory I wanted to run FastCGI on. IE: in ./lee.org for the whole site or in ./lee.org/blog for just the blog:
Options +ExecCGI
AddHandler php5-fastcgi .php
Action php5-fastcgi /php5-wrapper.fcgi

Create a file called php5-wrapper.fcgi and put it at ./lee.org. Make it executable by the user. Put the following in it:

#!/bin/sh
export PHP_FCGI_CHILDREN=3
exec /usr/local/dh/cgi-system/php5.cgi

Click the checkbox in the Domain section of the Dreamhost Panel saying “FastCGI”.

That’s it.

600 Comment Spams per day

October 4th, 2006 12:31am. Wordpress

I’m now getting 600 comment spams per day. Phew. Spam Karma is keeping up with them but jeez….

If you leave a comment and get a crazy error, don’t worry. Spam Karma’s Captcha test is broken somehow. If you get the error, it means Spam Karma tried to give you the Captcha test but barfed. I’ll get around to “approving” your comment in a day or three. Sorry about the inconvenience.

 update 6-22-07:  I fixed the captcha test a while back.

Installed WP-DB-Backup 1.7

September 22nd, 2006 5:30pm. Wordpress

The old backup program had some issue when I moved servers. This one doesn’t have any issues. I didn’t install the very latest 1.7, I installed a slightly older one because it wasn’t compatible with WP1.5

WP-DB-Backup

Page 2 of 5«Newer12345Older»