THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Sean D. Tucker plane ride winners: the pictures are in

It looks like our lucky recipients of plane rides with Sean D. Tucker had a great time. Pictures are below. Thanks again to Team Oracle for facilitating the flights.
Read the rest of this entry . . .

Pythian Speaking @ Oracle OpenWorld 2010

If you’re attending Oracle OpenWorld 2010 in San Francisco, Sept. 19-23, 2010, be sure to stop by one of Pythian’s many sessions.

We’ll be all over the show, with experts Alex, and Marc speaking as listed below. Or, you might find Paul, Alex and others attending the bloggers meetup, participating in Oracle ACE/ACE Director activities, or at some of the User Group or OPN sessions on Sunday. Drop us a line on twitter @pythian while you’re at the show to connect with Pythian.
Read the rest of this entry . . .

Log Buffer #188, a Carnival of the Vanities for DBAs

It’s Friday already, and we know what that means! Log Buffer, the industry’s weekly review of database blogs is here again for your reading pleasure in the 188th issue.

Starting off this week’s issue is a request from Mark Grennan a DBA who would like to let the community know about his blog MySQL Fan Boy, where he wrote an interesting post on including a script to replace MySQL table files on a live system, making it faster and limiting locking on large table loads. Also a post this week on whether MariaDB is a drop in replacement for MySQL.

Read the rest of this entry . . .

Log Buffer #187, a Carnival of the Vanities for DBAs

Welcome to Log Buffer. This week’s issue #187 was another group effort. Thanks to all our contributors – you rock!

Suggested by Pythian’s Bradd Piontek, is a post he really liked because he used to write pipelined functions for Dynamic Search queries, – Tom Kyte’s something new I learned about estimated cardinalities. He’s also highlighted something new Tom learned about sqlplus. And the fact that Richard Foote announced the Oak Table’s new website. Bradd’s last note highlights tips and tricks from Christian Antognini on analysing a SQL Trace File with SQL Statements on his blog Striving for Optimal Performance.

Contributing from Chris Presley on the SQL Server side of things is Kimberly L Trip’s post about single use plans in the procedure cache, or Glenn Berry’s SQL Server Performance blog – A DWV a Day – Day 29, sys.dm_exec_connections. Chris also suggests these cool restore myths debunked from Paul Randal’s blog In Recovery.

Read the rest of this entry . . .

Log Buffer #186, a Carnival of the Vanities for DBAs

Welcome to the 186th Edition of Log Buffer. Lots to report this week, so read on…

In Oracle news:

We begin with Gary Myers at the Sydney Oracle Lab who mixes GUI and CLI and shows how to manage your database from EMACS. You have to read a post that starts with: “There is a place of shadow, a place between the dark lands of the command-line interface, and the shining brightness of the GUI. In the days of yore, many dwelled in the shadow lands, but almost all have been attracted to the lights of SQL Developer…”
Read the rest of this entry . . .

Videos of Pythian Sessions from the 2010 O’Reilly MySQL Conference and Expo

Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).

TitlePresenterSlidesVideo link
(hr:min:sec)
Details (Conf. site link)
Main Stage
Keynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)N/A18:16
session 14808
Ignite talk: MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31N/A
Interview
Thoughts on Drizzle and MySQLSheeri K. Cabral (Pythian)N/A9:22N/A
Tutorials
MySQL Configuration Options and Files: Basic MySQL Variables (Part 1)Sheeri K. Cabral (Pythian)
PDF
1:25:04, pre-break

1:35:47, post-break
session 12408
MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)Sheeri K. Cabral (Pythian)
PDF
1:25:04, pre-break

1:24:28, post-break
session 12435
Sessions
Better Database Debugging for Shorter DowntimesRob Hamel (Pythian)PDF33:13
session 13021
Find Query Problems Proactively With Query ReviewsSheeri K. Cabral (Pythian)PDF45:59session 13267
Time Zones and MySQLSheeri K. Cabral (Pythian)PDF45:54
session 12412
Security Around MySQLDanil Zburivsky (The Pythian Group)ODP37:27session 13458
Continual Replication SyncDanil Zburivsky (The Pythian Group)ODP45:57session 13428

Log Buffer #185, a Carnival of the Vanities for DBAs

It’s a busy time of year for Pythian. With many of our team tied up on client engagements, away at MySQL conference this week, and Collaborate 2010 next week, I’m pinch hitting as volunteer editor in helping to pull together this week’s edition of Log Buffer. Enjoy!

MySQL Conference 2010

Big news this week from MySQL Conference as Oracle’s Edward Screven elaborates on Oracle’s plans for MySQL in his opening keynote. Pythian’s Paul Vallee was interviewed by Network World’s John Brodkin, before the conference in anticipation of the session.

Ronald Bradford responds, writing about his disappointment with the keynote and then elaborates on being named an Oracle ACE Director.

Pythian’s Sheeri Cabral, recently recognized for her MySQL community contributions as Oracle’s first ACE Director for MySQL was in the middle of all the action. Sheeri outlines how Oracle can be MySQL’s friend-with-benefits in her community keynote. And then shares her thoughts on Drizzle with O’Reilly Media’s Tim O’Reilly. And on the keynote, Sheeri comments it was an ad to “come join us at OpenWorld”.

Read the rest of this entry . . .

Gearing Up for MySQLConf 2010

I’m looking forward to traveling to San Jose for this year’s MySQL Conference. If there’s anything that can trump the drama of conf two years ago, where we observed how Sun would handle its new property, and then the drama of last year, where we observed how Oracle would handle the pending acquisition, it’s going to be the drama around this one — the first MySQLConf since the Oracle/Sun merger has been finalized and approved.

I think there is some finality to the changing of the guard this time, since there aren’t really that many companies that could conceivably swallow up Oracle itself! (Maybe I shouldn’t say that — next thing you know they’ll spin it off heh.) But regardless, I am looking forward to getting to know Edward Screven and getting a sense from the keynote and other communications exactly what he’s planning to … DO … with MySQL.

Read the rest of this entry . . .

Welcome Chen Shapira to Pythian

I’m excited to announce that Chen Shapira has started with Pythian this week. :) Chen is no stranger here and many of my colleagues already know her and were in touch — she just naturally fits in.

Chen is the world class production Oracle DBA. She has been maintaining a popular Oracle blog and is a great addition to Pythian bloggers — Chen posted on Pythian blog before her actual official join date authoring Log Buffer last week. She is also on Twitter and you can follow her @gwenshap. Turns out that even Pythian SQL Server DBA’s are frequent readers of her blog — who knew?

Chen is also a frequent presenter at the conferences such as RMOUG10, Hotsos09, OOW09 and OOW08.

Chen is an Oracle ACE and also a member of OakTable Network. She is very active in her local user group, Northern California Oracle User Group (NoCOUG), carrying duties of the Training Day Coordinator.

Welcome Chen to the Pythian team! I’m sure you are already working on acceptance testing of that new Oracle 11g RAC cluster that is slated to go live… eh… this weekend? ;-)

Meet the First Oracle ACE Director in MySQL — Sheeri Cabral

Sheeri Cabral - The First Oracle ACE Director in MySQL I’m excited to share the news that Oracle ACE program has been extended to cover MySQL community now and Pythian’s Sheeri Cabral has become the very first Oracle ACE Director in MySQL expertize area. It’s a special privilege for me to blog about it because I had a pleasure to nominate Sheeri in the first place. Being an Oracle ACE Director myself and knowing what’s involved, I believed that if Oracle ACE program is extended to MySQL, Sheeri must be the number one candidate.

It’s impossible to overestimate Sheeri’s role in the MySQL community — her advocacy for the technology and commitment to building and supporting the community. She’s been presenting about MySQL countless number of times and been actively involved in several community projects and organizations. She blogs frequently and with passion. It’s no surprised that Sheeri has been awarded MySQL’s Community Advocate, Communicator and Facilitator of the Year for two years in a row (2007 and 2008). Read the rest of this entry . . .

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @FN_Press2: Schooner Information Technology Teams with Pythian to Deliver Advanced Support and High... http://finanznachrichten.de/20
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more