For all the people that were looking for the presentation I gave last night to the Jacksonville PHP user group – I have uploaded it to my presentations page as a PDF. Included are all my speaker notes and references as well.
I pleased and proud to announce that I have been accepted to be an Oracle ACE for MySQL.
For those not familiar with it, Oracle ACEs are community members that are nominated and eventually chosen for their (in my case) MySQL community involvement. To learn more about the Oracle ACE program, check out the Oracle page or the FAQ’s.
And just cause I want to show it off a little – my ACE page
A huge thank you to Keith and Dave for submitting my name. I am truly humbled to have been chosen.
As some know I left MySQL Support last week and started working for Kaplan Professional as their MySQL DBA.
To all my old colleagues at MySQL Support – I miss you. You have been my friends, teachers, mentors and co-conspirators. Thank you for everything and don’t be strangers.
To my new colleagues at Kaplan, thank you for the wonderful opportunity you have given me. I look forward to learning and working with you
Man time goes by fast. Only about a week left before Tek. I have to admit to being rather excited about it. I will be giving a tutorial on Optimizing MySQL Essentials that will cover many areas including queries and the server. I also have a regular session called “Why be Normal” that will be an intro into data normalization.
Both of these talks are new for me, so it has been quite a lot of fun putting things together. I hope you will come out and join me and others of the PHP Community at Tek. If you haven’t registered for it yet, there is still time. So get out there!
Crazy but true – I am on Voices of the Elephpant this week. I had a great time talking with Cal about PHPWomen, so be sure to check it out!
And if you know someone who is one of the unsung members of the PHP Community, be sure to nominate them for an interview at http://voicesoftheelephpant.com/nominate-a-voice/
Short Braindump:
– undo log == rollback segment
– everything kept within the tablespace
– primarily for removing data changes that had been written to disk when a crash occurred, but should not have been written, because they were for uncommitted transactions.”
– “History list length 6 is number of unpurged transactions in undo space. It is increased as transactions which have done updates are commited and decreased as purge runs. ” – comes from http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
– number of undo log entries for a specific transaction can also be found in the TRANSACTION section of INNODB STATUS
References:
1) http://forge.mysql.com/wiki/MySQL_Internals_Files_In_InnoDB_Sources – “Some Notes About Structures”
2) http://dev.mysql.com/doc/refman/5.1/en/innodb-multi-versioning.html
3) http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-rollback-segments.html
I am pleased and proud to announce that I will be presenting at this years Dutch PHP Conference from May 19th to the 21st in Amsterdam, Netherlands.
I will be giving a tutorial on the basics of optimizing MySQL along with a session on character sets. I, in particular, look forward to the tutorial since it covers areas that I find fascinating – query and server optimization.
On a personal note, neither I or my husband have ever been to Amsterdam before. So since we have never yet had the opportunity to play tourist there, my husband plans to join me on the trip for the conference. We hope to play tourist while there and at least see the Van Gogh museum. Though hopefully we will get to see much more then just that.
I missed last years BarCamp Orlando since it was being held Easter weekend. This year I am hoping to make it!
This year it will be Saturday, April 2, 2011 from 9:30 am to 6:00 pm at:
Wall St. Cantina
19 N Orange Ave
Orlando, FL 32801
Not sure if I will present yet.. But thinking about it.
I have to admit – I am both pleased as punch, and jealous as heck that my colleague, Geert Vanderkelen, will be presenting a MySQL Performance Tuning tutorial at this years PHP Benelux Conference.
Lots of stuff will be discussed, including configuration, understanding status variables, finding bad queries, schema tips, etc.
Wonder if he will let me steal away in his luggage?
I am honored to announce that I will be presenting at Day Camp 4 Developers #2: Telecommuting.
I will be presenting on what for me is a constant struggle – to balance your home and work life when you telecommute. I must admit that I and my family fight with this every day.
If you want learn more about telecommuting, what is involved, what tools are needed and how to talk to your boss about setting up a telecommuting program, I hope you will consider joining us!
