Archive for the 'Databases' Category

How to embed a Google Video in SMF

About a year ago I wrote a post on how to embed a YouTube video in a Simple Machines Forum post. Well, as it works out today I needed to embed a Google Video in a post so I went through and did almost the same process to get it to work.

addthis_url [...]

SQL_CALC_FOUND_ROWS - Is it faster?

Reading through a post on SQL_CALC_FOUND_ROWS actually being slower that running one query followed by a count query I decided I needed to do a little benchmarking on my own.

addthis_url = ‘http%3A%2F%2Fforumsblogswikis.com%2F2008%2F06%2F12%2Fsql_calc_found_rows-is-it-faster%2F’;
addthis_title = ‘SQL_CALC_FOUND_ROWS+-+Is+it+faster%3F’;
addthis_pub = ‘RyanNutt’;

Comparing MySQL search speed for different column types

Starting work on a new website I wanted to know which type of MySQL column was the fastest to search on. I assume it’s a numeric column, but I really want to know how much of a difference it makes. What I’m working on right now is an options table and it would [...]

Clearing out MySQL binary logs

Over the past few weeks WHM has been sending me emails that my server space was getting full. I guess 80% is the threshold for those emails. But it was creeping up so slowly that over the course of 8 or 10 weeks it had only gone from 80% to 82% which I [...]

How to reset your Wordpress password

Help! I’ve forgotten my Wordpress password!
Ever been there? Wordpress has a built in method to email you a new password, but what happens if it’s been so long that you don’t have access to the email address any longer? Or if you have too many email addresses and can’t remember what address [...]