This presentation was be done by Sheeri Cabral of The Pythian Group and went into how to use SHOW ENGINE INNODB STATUS to get more information about your Innodb tables, foreign keys and transactions. This is a great presentation to learn how InnoDB works.

It also went through how to use SHOW ENGINE INNODB STATUS to tune several InnoDB variables:

innodb_adaptive_hash_index
innodb_commit_concurrency
innodb_concurrency_tickets
innodb_file_io_threads
innodb_log_buffer_size
innodb_max_purge_lag
innodb_sync_spin_loops
innodb_thread_concurrency
innodb_thread_sleep_delay

The slides can be downloaded from:

http://technocation.org/files/doc/ShowEngineInnoDBStatus.pdf

(Note that the slides open up to the middle section, which …

On Monday, October 12, 2009* from 7-9 pm at MIT, I will be giving a presentation explaining SHOW ENGINE INNODB STATUS for the Boston MySQL User Group. There is information about foreign keys, transactions, deadlocks and mutexes just waiting to be discovered, and I will show how to decipher the information.

For all those in the Boston area, I hope to see you there! For those who cannot be there, we will video this presentation and make it available online, and post here when the video/slides are up.

*Yes, I realize that this is a bank holiday in the US.

Most notable, after the session, we continued the cultural exchange to a local restaurant that bears my name (correctly spelled!), where this heap of bread caught my eye. Thanks to …

Well, I announced it a few months ago, and now Sheeri made it happen. The MySQL Users Conference and Expo 2009 will have a MySQL Camp embedded.

What is it? Asked most of the people I know, including many colleagues, some of them worried that I was giving away the company jewels.

For starters, it is not a competitor of the Users Conference. It won't duplicate its contents, nor is a way of sneaking into the main conference without a pass. It is a camp, and if you have attended either one of the previous MySQL Camps or the OpenSQLCamp, you know what I mean.

MySQL Camp is a gathering of MySQL geeks, developers, enthusiasts, …

Well, I announced it a few months ago, and now Sheeri made it happen. The MySQL Users Conference and Expo 2009 will have a MySQL Camp embedded.

What is it? Asked most of the people I know, including many colleagues, some of them worried that I was giving away the company jewels.

For starters, it is not a competitor of the Users Conference. It won't duplicate its contents, nor is a way of sneaking into the main conference without a pass. It is a camp, and if you have attended either one of the previous MySQL Camps or the OpenSQLCamp, you know what I mean.

MySQL Camp is a gathering of MySQL geeks, developers, enthusiasts, …

Well, I announced it a few months ago, and now Sheeri made it happen. The MySQL Users Conference and Expo 2009 will have a MySQL Camp embedded.

What is it? Asked most of the people I know, including many colleagues, some of them worried that I was giving away the company jewels.

For starters, it is not a competitor of the Users Conference. It won't duplicate its contents, nor is a way of sneaking into the main conference without a pass. It is a camp, and if you have attended either one of the previous MySQL Camps or the OpenSQLCamp, you know what I mean.

MySQL Camp is a gathering of MySQL geeks, developers, enthusiasts, …

Listening to Sheeri's presentation on MySQL 5.1, I saw that there are a few questions left unanswered. I am listing here some of the questions that I found interesting, plus a few from an early webinar on the same topic.

Q: does Partitioning physically split data?

A: No. Some engines (MyISAM, Archive) do a physical split, but this is not necessary, as you see if you apply partitioning to a InnoDB table. Partitioning is a logical split of data, for easy retrieval. It is completely transparent to the user.

Q: Can you set partitions to different servers?

A: No. Partitions are logical parts of one table within one server. Partitioning through the Federated engine is not supported.

Q: How efficient are Row-Based …

Diary: Saturday 16th June 2007

Today, Miss She-BA Sheeri Kritzer married partner Tony in Boston. For those that remember, Sheeri was the 2007 Community Advocate of the Year at the MySQL Conference.

The official photos and videos are already up, so I’ve add my snaps online now. This was an excellent day, it had some the best planning I’ve seen in a …

mysqlconf mysqlconf07

“What societies value is what they memorize. And how they memorize it and who has access to its memorized form determines who has power.”

We’re starting to become a society that “memorizes” private facts — not just public records being written down, but private thoughts, dreams and wishes.

“Living largely in a world of expensive written material and seeking to build a private database of things experienced and learned, early modern Europeans built in their minds memory palaces — imaginary rooms furnished with complex bric-a-brac and decorations. . . By walking through the rooms of the memory palace in their minds, [they] remembered things they needed to know.”

Photographs took a factual and emotional snapshot of experience …