Many of you might know HowToForge, but for those who don't - there's a
bunch of excellent and interesting tutorials relating to Linux
and OpenSource.
There are also many about MySQL or using MySQL - here are some
examples:
Dear Diary, today I ventured into one of the
darkest realms of the sysadmin profession: I started playing with
SNMP. My goal was very simple and quite clearly stated: Make the
output of "SHOW GLOBAL STATUS" available to a SNMP client. One
would think that this is a reasonable and easily fulfilled
wish.
Little did I know of the madness and despair that linger in the
depths which are guarded by the dread named ASN.1 and where the
noxious fumes of the organisation no longer called CCITT can
still strongly be smelled.
But let us begin this story at the beginning - with a clean
install of Suse Linux 10.0 and my trusty apt4rpm and me. It was
my thought that the perl support of net-snmp might me handy to
get me where I wanted to me: perl is easily the more convenient
language for prototyping that C or C++ and getting to the data …
I got a lot of feedback on my question a few weeks back when pondering what I might choose for an OS to run MySQL. I also got a few "so what did you go with" questions.
A week ago I decided to give Ubuntu server a shot at winning my favor. I haven't used Ubuntu much, but all the fuss over it warrants giving it a shot.
I'm quite pleased so far. It meets at least two of the items on my list from that original post (minimal processes and minimal footprint). I'm not familiar with the philosophy behind building the Ubuntu kernel, but I'll accept the fact that there's nothing specifically tailored for MySQL.
Four clues that the server is installed minimal:
The sixteenth edition of Log Buffer, the weekly review of database blogs, has been published by Guy Bowerman on his blog, Informix Application Development. Log Buffer has a distributed editorship. If you’d like to share your POV on the database blogosphere, read the Log Buffer homepage and get involved. Take it away, Guy.
A bit ago ago I posted some optimizer hints and recommended using them to write more readable queries. Today I stumbled across an example of my own work that I changed. This is not quite a case of using BETWEEN instead of AND statements, but it sort of is. Basically, I needed to reuse this query:
SELECT count(*),city,
CASE WHEN lastLogin < now ()-interval 90 day THEN 90
WHEN lastLogin < NOW()-interval 60 day THEN 60
WHEN lastLogin < NOW()-interval 30 day THEN 30
WHEN lastLogin > NOW()-interval 30 day THEN 0
ELSE -1
END
FROM . . .
I wrote this query less than a month ago.
I looked at this query today and wondered, “why did I not put
lastLogin < now ()-interval 60 AND
lastLogin>NOW()-interval 90 in there?” I then realized
what I did.
Because the CASE statement …
[Read more]A bit ago ago I posted some optimizer hints and recommended using them to write more readable queries. Today I stumbled across an example of my own work that I changed. This is not quite a case of using BETWEEN instead of AND statements, but it sort of is. Basically, I needed to reuse this query:
SELECT count(*),city,
CASE WHEN lastLogin < now ()-interval 90 day THEN 90
WHEN lastLogin < NOW()-interval 60 day THEN 60
WHEN lastLogin < NOW()-interval 30 day THEN 30
WHEN lastLogin > NOW()-interval 30 day THEN 0
ELSE -1
END
FROM . . .
I wrote this query less than a month ago.
I looked at this query today and wondered, “why did I not put
lastLogin < now ()-interval 60 AND
lastLogin>NOW()-interval 90 in there?” I then realized
what I did.
Because the CASE statement …
[Read more]If foreign keys are a part of the database namespace, why is it that you have to ALTER TABLE to add and remove them? Why not alter the database? I suspect the issue is more in MySQL’s limitations that names of foreign keys be unique among tables in a database. . . but it does make me wonder.
If foreign keys are a part of the database namespace, why is it that you have to ALTER TABLE to add and remove them? Why not alter the database? I suspect the issue is more in MySQL’s limitations that names of foreign keys be unique among tables in a database. . . but it does make me wonder.
Joke of the day from our character sets ubergod:
10:59 < bar> mysql> set names utf8; 10:59 < bar> Query OK, 0 rows affected (0.00 sec) 10:59 < bar> mysql> create table t1 (a text, 10:59 < bar> -> fulltext index `
So what am I up to?
I am taking a vacation.
What does that mean?
I am on a "Hacker Holiday"
In other words I am at staying at home and screwing around with
some technology that I have been wanting to look at.
One of the things I am trying to do is see why my network goes
down the tubes every so often (or am I supposed to now say the
Tubes get full?). I use DD-WRT , http://www.dd-wrt.com/, on all of my routers.
I got the brilliant idea of enabling QOS on Wednesday to see if I
could get better bandwidth shaping. This pretty much broke
everything... I disabled it suspecting that it was causing the
router to max out its CPU only to discover that the network
issues were related to the maximum number of open connections
that my WRT54GL can handle. Which means that I need to find a
faster box to run DD-WRT on. Problem is... I …