Providing educational resources and monetary grants to IT professionals.

Technocation Grants a Free Shmoocon Membership!

ShmooCon is an annual East coast hacker convention hell-bent on offering three days of an interesting atmosphere for demonstrating technology exploitation, inventive software & hardware solutions, and open discussions of critical infosec issues. Technocation has started the year off right by granting a FREE Shmoocon membership to a lucky high school student.

Garrett is a Junior at Maumee Valley Country Day School in Toledo, Ohio. His avid fascination with technology began at an early age, starting with an amateur radio license at 12 which was followed by a self-built computer shortly after. He has also always been interested in electronics and the like, and has the soldering iron burns to prove it. Garrett's enthrallment with computer security started in late 2005 when he became interested with wireless security practices, which spawned an unhealthy love for Linux.

Log Buffer #77: a Carnival of the Vanities for DBAs

Welcome to the 77th edition of Log Buffer, the weekly review of database blogs.
This is the last Log Buffer of 2007. . . a time for looking back at the year, looking ahead to the next, and generally focusing on time.
It may not be the Oscars, but Firebird News is thrilled that Firebird is Sourceforge’s [...]

InnoDB’s Adaptive Hash

MySQL’s manual page for InnoDB’s adaptive hash states:
If a table fits almost entirely in main memory, the fastest way to perform queries on it is to use hash indexes. InnoDB has a mechanism that monitors index searches made to the indexes defined for a table. If InnoDB notices that queries could benefit building a [...]

Query Profiling Tools — part 1, mysqlsla

The “sla” in mysqlsla stands for “statement log analyzer”. This does a much better job than mysqldumpslow of analyzing your slow query log. In fact, you can sort by many different parameters — by sheer number of times the query shows up in the slow query log, by the total or average query [...]

MySQL: “SOUNDS LIKE” vs. Full-Text search

A friend of mine asked me:
I’m hoping you can help me out with something — I’m trying to optimize a search feature. Since it uses a MySQL database, the search already uses the LIKE statement to get matches for a search query, we might be needing something more flexible. I found mention on MySQL’s website [...]

Sheeri’s First Week at Pythian

The Pythian family got a new song last Monday — “Sheeri” means “my song” in Hebrew. This post on my own blog explains how I got the job.
High winds delayed my flight last Monday, and we’ve had two snow storms since I arrived. Luckily, my real-life context switch has not been too difficult. [...]

MySQL Query Profiling Tools — part 0, Ma’atkit Query Profiler

Today I’ve been checking out a new client environment. My mission is to figure out (cold) some of the characteristics of the queries being run, and particularly if they’re “good” or “bad”. In my arsenal of “tools I really want to check out” has been Ma’atkit’s Query Profiler.
They’re very different tools. Ma’atkit’s query [...]

Scaling MySQL via Replication and Sharding OpenSQLCamp Video

Scaling MySQL via Replication and Sharding - Peter Zaitsev, CEO of Percona

This session discusses how to use replication and sharding to scale your systems very large.

Video - MySQL Questions: Corruption and Upgrades

MySQL Boston September/October 2007 User Group

Before the MySQL Proxy tutorial at the September/October Boston MySQL User Group, we had a few questions. This video has those questions -- odd myisam corruption from having 2 machines with the same server-id and a question on upgrading Mysql from 3 to 5, with a followup on how to figure out when to upgrade.