Xaprb

Stay curious!

How to change the default database in MySQL

with 10 comments

Dear Lazyweb, quick question: once I’ve USE-ed a database in MySQL, how can I un-USE it so I have no default database? Is it even possible?

Written by Xaprb

October 11th, 2008 at 10:40 pm

Posted in SQL

Tagged with

Three steps to stopping blog comment spam

with 3 comments

This is part knowledge share, part appeal: fellow bloggers, I’d comment a lot more on your blogs (and I want to!) if I could. Please, make it easy for me to comment — don’t make me log in (I won’t do it) or moderate me. I’ve found a solution that works really well for me; maybe it’ll help you too.

Read the rest of this entry »

Written by Xaprb

October 11th, 2008 at 12:23 pm

Posted in SQL, World Wide Web

Tagged with ,

Would Tufte approve of mixing units on a graph?

with 7 comments

I’ve created a set of Cacti templates for graphing stats about MySQL. While these were based on several other people’s work, there are many improvements. One of them in particular I want to bring up, and I’ll go so far as to say it ought to be a “best practice” for graphing. That is, don’t mix units on a graph.

Read the rest of this entry »

Written by Xaprb

October 9th, 2008 at 9:58 pm