Providing educational resources and monetary grants to IT professionals.

MySQL Charging for Features? ZOMG!

In 3 words:

They already do.

MySQL Enterprise is more than just a binary. http://mysql.com/products/enterprise/ has the details on the other features MySQL Enterprise includes.

One of these features is the MySQL Enterprise Monitor, which is closed source, proprietary alerting software.

So when bloggers make statements such as:

MySQL will start offering some ...

Liveblogging: Extending MySQL by Brian “Krow” Aker

Liveblogging: Extending MySQL by Brian "Krow" Aker

Brian wins the award for "most frequent great quotes during a talk".

Before MySQL 5.1 a UDF was the only way to extend MySQL.

All you need in a UDF is: init() execute() deinit()

my_bool id3_parse_init(UDF_INIT *initid UDF_ARGS *args, char *message)

UDF_ARGS tell you about incoming ...

Jonathan Schwartz's Keynote at the 2008 MySQL Conference

Jonathan Schwartz's Keynote at the 2008 MySQL Conference can be played from the embedded video at the bottom of this post or directly at YouTube at http://www.youtube.com/watch?v=zpfHnmt1KOc

I finally realized who Jonathan Schwartz reminds me of:

That's right, comedian and magician Penn Jillette.

Best Practices for Database Administrators slides and links

slides in pdf form

cacti
nagios
rt

MySQL 5.0 manual
explain
show variables
show status
data types
procedure analyse()
mysqldumpslow's manual page says "Use mysqldumpslow --help to see the options that this command supports."

mysqlsla
mysqlreport
Maatkit, contains mk-query-profiler and mk-table-sync

mytop
innotop

Does MySQL Send Passwords In the Clear?

I was asked this question recently, and I thought it was a great little tidbit of knowledge to pass along. The short answer is "no". The slightly longer answer was written up by Jan Kneschke when dealing with a forum post about proxy + connection pooling.

From http://forums.mysql.com/read.php?146,169265,169700

The clear-text ...

Hating MySQL for the Wrong Reasons

In Spotting the Wolf in Sheep's Clothing, Frank Mash writes about a specific person who is spreading fear, uncertainty and doubt about MySQL.

Now, this always gets me, especially with MySQL. For how long will MySQL be the bastard stepchild of the database world? Because really, it's been a ...

Pop Quiz: MySQL Password Hashing

The answers to the last pop quiz are up: http://www.pythian.com/blogs/868/pop-quiz-mysql-cluster

So here's another pop quiz. Given the following:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16450949 to server version: 4.1.14-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> ...

Neighborhoods and Communities

Recently I acquired Sesame Street Volume 1, and on the third DVD in the set I came across one of my favorite Sesame Street songs: "Who are the people in your neighborhood?"

Here's a sample of one such skit, if you are not familiar with it, or if you want ...

Saying What You Mean

Ah, the perils of working in a shared, client environment. One client has us using a login that is not exclusive to us. I prefer using bash; the client is set to use zsh. This is not a problem in and of itself.

However, there is a section ...

Pages