OurSQL Podcast Interviewing Brian Aker — What Are Your Questions?

At 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL.
If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment […]

At 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL.
If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment […]

OK, Now I Am a Bit Worried

SUN Microsystems just bought MySQL, see the announcement at http://www.sun.com/aboutsun/pr/2008-01/sunflash.20080116.1.xml
Now, MySQL isn’t going away any time soon; there are just way too many people that use it. And while Postgres is not actually owned by SUN, they do employ some great folks to develop on it, and those folks are the the “known” Postgres […]

SUN Microsystems just bought MySQL, see the announcement at http://www.sun.com/aboutsun/pr/2008-01/sunflash.20080116.1.xml
Now, MySQL isn’t going away any time soon; there are just way too many people that use it. And while Postgres is not actually owned by SUN, they do employ some great folks to develop on it, and those folks are the the “known” Postgres […]

Duplicate binlog-do-db entry — Solution

At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this:
(copied from http://lists.mysql.com/replication/607)

master my.cnf:
binlog-do-db=db1

slave my.cnf:
replicate-do-db=db1;

Relevant show slave status output

Replicate_Do_DB: db1;,db1;

When db1 is modified on master, Read_Master_Log_Pos and Relay_Log_Pos do
changes, also I can open and see the changes in rh3-relay-bin.000002, but
they do not appear in […]

At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this:
(copied from http://lists.mysql.com/replication/607)

master my.cnf:
binlog-do-db=db1

slave my.cnf:
replicate-do-db=db1;

Relevant show slave status output

Replicate_Do_DB: db1;,db1;

When db1 is modified on master, Read_Master_Log_Pos and Relay_Log_Pos do
changes, also I can open and see the changes in rh3-relay-bin.000002, but
they do not appear in […]

Handler_read_first MySQL Haiku

I was writing up some notes about a client’s status variables, and I’d had to remind myself of Handler_read_first. Handler_read_first is a counter that increments when the first entry in the index is read, which may indicate that a full index scan is being used.
With this particular client, I ran a SHOW […]

I was writing up some notes about a client’s status variables, and I’d had to remind myself of Handler_read_first. Handler_read_first is a counter that increments when the first entry in the index is read, which may indicate that a full index scan is being used.
With this particular client, I ran a SHOW […]

SHOW VARIABLES Shows Variables MySQL Does Not Know About

The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly.
innodb_data_home_dir is listed there as a dynamic variable, but it is not one, and trying to change it on-the-fly doesn’t work:

mysql> set global innodb_data_home_dir=”/data/mysql/data”;
ERROR 1193 (HY000): Unknown system variable ‘innodb_data_home_dir’

mysql> set session innodb_data_home_dir=”/data/mysql/data”;
ERROR […]

The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly.
innodb_data_home_dir is listed there as a dynamic variable, but it is not one, and trying to change it on-the-fly doesn’t work:

mysql> set global innodb_data_home_dir=”/data/mysql/data”;
ERROR 1193 (HY000): Unknown system variable ‘innodb_data_home_dir’

mysql> set session innodb_data_home_dir=”/data/mysql/data”;
ERROR […]

Replication Presentation at the November 2007 Boston MySQL User Group

Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.

References mentioned in the video:
Brian Aker’s DBIx::Password

Giuseppe Maxia’s article about federated tables — I think that’s the right one, feel free to comment if it’s not.

MySQL Toolkit — renamed Ma’atkit — lives at http://sourceforge.net/projects/maatkit

sample my.cnf files for 2 different dual-master replication scenarios

Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.

References mentioned in the video:
Brian Aker’s DBIx::Password

Giuseppe Maxia’s article about federated tables — I think that’s the right one, feel free to comment if it’s not.

MySQL Toolkit — renamed Ma’atkit — lives at http://sourceforge.net/projects/maatkit

sample my.cnf files for 2 different dual-master replication scenarios

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.

read more

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.

read more

Forging the Board of Your Dreams February 2008


Forging the Board of Your Dreams

An effective board of directors is essential to a healthy organization. Executive Directors and Boards must work together, share a clear vision, and understand the keys to achieving shared success. This workshop will teach participants:


  • The roles and responsibilities of the board

  • The role of board committees

  • Roles and expectations for individual board members

  • The role of the board versus that of paid staff

  • Efficient board structure and management

  • How to develop leaders and an ongoing leadership succession

We will also cover the do’s and don’ts of effective board operations. This seminar will provide board members and executive staff with the tools and knowledge necessary to build the effective board that you all desire.

Tuition: $75.00
9:15 am – 12:15 pm
One Monday Morning Session: 2/4

Sheeri’s feed of articles from the pythian group
Sheeri’s feed of articles from the pythian group
Sheeri’s feed of articles from the pythian group


Major Donor Fundraising

The largest revenue category in most nonprofit budgets comes from those most dedicated and prized stakeholders – major donors. These donors make large individual contributions, thousands, and even millions of dollars to support the work of groups about which they are passionate. We will learn how to find these crucial supporters, develop your group’s relationship with them, and to work with them to expand the reach of your work and your budget. Familiarity with the basics of fundraising is recommended prior to taking this class. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced

Sheeri’s feed of articles from the pythian group
Sheeri’s feed of articles from the pythian group


Major Donor Fundraising

The largest revenue category in most nonprofit budgets comes from those most dedicated and prized stakeholders – major donors. These donors make large individual contributions, thousands, and even millions of dollars to support the work of groups about which they are passionate. We will learn how to find these crucial supporters, develop your group’s relationship with them, and to work with them to expand the reach of your work and your budget. Familiarity with the basics of fundraising is recommended prior to taking this class. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced

Sheeri’s feed of articles from the pythian group


Major Donor Fundraising

The largest revenue category in most nonprofit budgets comes from those most dedicated and prized stakeholders – major donors. These donors make large individual contributions, thousands, and even millions of dollars to support the work of groups about which they are passionate. We will learn how to find these crucial supporters, develop your group’s relationship with them, and to work with them to expand the reach of your work and your budget. Familiarity with the basics of fundraising is recommended prior to taking this class. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced


How to Start a Planned Giving Program

Many nonprofit fundraisers have heard of planned giving, easy-to-implement ways of incorporating this powerful development tool into your work. No prior experience with planned giving is required. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced

Sheeri’s feed of articles from the pythian group
Sheeri’s feed of articles from the pythian group


Major Donor Fundraising

The largest revenue category in most nonprofit budgets comes from those most dedicated and prized stakeholders – major donors. These donors make large individual contributions, thousands, and even millions of dollars to support the work of groups about which they are passionate. We will learn how to find these crucial supporters, develop your group’s relationship with them, and to work with them to expand the reach of your work and your budget. Familiarity with the basics of fundraising is recommended prior to taking this class. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced

Sheeri’s feed of articles from the pythian group


Major Donor Fundraising

The largest revenue category in most nonprofit budgets comes from those most dedicated and prized stakeholders – major donors. These donors make large individual contributions, thousands, and even millions of dollars to support the work of groups about which they are passionate. We will learn how to find these crucial supporters, develop your group’s relationship with them, and to work with them to expand the reach of your work and your budget. Familiarity with the basics of fundraising is recommended prior to taking this class. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced


How to Start a Planned Giving Program

Many nonprofit fundraisers have heard of planned giving, easy-to-implement ways of incorporating this powerful development tool into your work. No prior experience with planned giving is required. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced

Sheeri’s feed of articles from the pythian group


Major Donor Fundraising

The largest revenue category in most nonprofit budgets comes from those most dedicated and prized stakeholders – major donors. These donors make large individual contributions, thousands, and even millions of dollars to support the work of groups about which they are passionate. We will learn how to find these crucial supporters, develop your group’s relationship with them, and to work with them to expand the reach of your work and your budget. Familiarity with the basics of fundraising is recommended prior to taking this class. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced


How to Start a Planned Giving Program

Many nonprofit fundraisers have heard of planned giving, easy-to-implement ways of incorporating this powerful development tool into your work. No prior experience with planned giving is required. Limited to twenty students.

6:00 pm – 7:45 pm
Dates To Be Announced


Forging the Board of Your Dreams

An effective board of directors is essential to a healthy organization. Executive Directors and Boards must work together, and understand the keys to achieving shared success. This workshop will teach participants:


  • The roles and responsibilities of the board

  • The role of board committees

  • Roles and expectations for individual board members

  • The role of the board versus that of paid staff

  • Efficient board structure and management

  • How to develop leaders and an ongoing leadership succession

We will also cover the do’s and don’ts of effective board operations. This seminar will provide board members and executive staff with the tools and knowledge necessary to build the effective board that you all desire.

Tuition: $75.00
9:15 am – 12:15 pm
One Monday Morning Session: 2/4

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 […]

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 […]

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 […]