Posts Tagged ‘MySQL’

Well, this is certainly interesting. It looks like my stupid-intensive MySQL Query is using waaaaaaay too much processor to return some quick figures. In addition to that, it seems that this same query is making the processor work so hard that it’s running at over 130% utilization.

Apache, a wonderful bit of software, can be configured to collect and record all sorts of wonderful information. But what can we do with it? Well … why not shove it into a MySQL table and massage it for reporting purposes? I’ll even show you how.

This post is the second in a short series outlining how anyone can take measures to simplify WordPress installations on shared or private hosting solutions, improving security and reducing maintenance time. Yesterday I showed one possible way to host multiple
Read More →

How many times have you had the luxury to create a database from scratch?  If you’re like me, the answer is probably “not enough.”  But, regardless of how often we can flex our mental muscles with the complete design and
Read More →

Hmm … it seems that a nice round number occurred on this site, and I had almost completely missed the milestone! Today is the day that the 1800th comment was left on my site, and the author was none other
Read More →

I didn’t think it was going to happen … but I’ve finally upgraded to the latest version of WordPress. It wasn’t easy, and I’ve been swearing like an Irishman as issue after issue was uncovered when I started to bring
Read More →