Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 255 10 Older Entries

Displaying posts with tag: Group Blog Posts (reset)

Log Buffer #189, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #189 is generously published by Iggy Fernandez, editor of the quarterly journal of the Northern California Oracle User Group (NoCOUG).

As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.

Please enjoy Iggy’s issue of Log Buffer #189.

Liveblogging: Senior Skills: Grok awk
+3 Vote Up -3Vote Down

[author's note: personally, I use awk a bunch in MySQL DBA work, for tasks like scrubbing data from a production export for use in qa/dev, but usually have to resort to Perl for really complex stuff, but now I know how to do .]

Basics:
By default, fields are separated by any number of spaces. The -F option to awk changes the separator on commandline.
Print the first field, fields are separated by a colon.
awk -F: '{print $1}' /etc/passwd

Print the first and fifth field:
awk -F: '{$print $1,$5}' /etc/passwd

Can pattern match and use files, so you can replace:
grep foo /etc/passwd | awk -F: '{print $1,$5}'
with:
awk -F: '/foo/ {print $1,$5}' /etc/passwd

NF = built in variable (no $) used to mean “field number”








  [Read more...]
Log Buffer #188, a Carnival of the Vanities for DBAs
+2 Vote Up -1Vote Down

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

  [Read more...]
Log Buffer #187, a Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

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

  [Read more...]
Log Buffer #186, a Carnival of the Vanities for DBAs
+2 Vote Up -0Vote Down

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…”

Tanel Poder gives a step by step tour of his

  [Read more...]
2010 O’Reilly MySQL Conference Slides and Videos
+7 Vote Up -1Vote Down

Here’s a matrix of all the videos up on YouTube for the 2010 O’Reilly MySQL Conference and Expo. The matrix includes the title, presenter, slide link (if it exists), video link, and link to the official conference detail page, where you can rate the session and provide feedback that the presenter will see. They are grouped mostly by topic, except for the main stage events (keynote, ignite) and interviews.

If there’s a detail missing (ie, slides, or there are other videos you know about), please add a comment so I can make this a complete matrix.TitlePresenterSlidesVideo link
(hr:min:sec)Details (Conf. site link)

Keynotes

State of the DolphinEdward Screven (Oracle)29:10

  [Read more...]
MySQL Conference 2010 – Last day
+1 Vote Up -0Vote Down

The post is a little late since we came back to the hotel in the wee hours of the morning and I had to get up at 5:00am this morning.

Anyway, The morning’s keynotes again were quite good especially the one from Ubunto. I attend another packed Facebook session and one from Ronald Bradford. It was the first time I head him speak and he is very good.

I didn’t attend many of the afternoon events because of customer commitments but the remain group at the hotel had a passionate discussion on Oracle role in the MySQL community so its far from over and Oracle has one year to fix it. See you all next year

Log Buffer #185, a Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

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

  [Read more...]
MySQL 2010 Conference – Day 2
+1 Vote Up -0Vote Down

We started with the morning keynotes again today and I was a little surprised at the snipping going on while people are promoting their products it felt very counterproductive and will end harming the MySQL eco system. The Community Keynote on the other hand looked into the future for itself under the Oracle umbrella. Its still remains to be seen what form the conference will have next year.

The first session that I attended today were around MySQL partitioning in the beta releases and beyond. They were saying the right things but it remains to be seen when some of these features will be available. I would hope that the engineers responsible for MySQL partitioning have a little talk with their Oracle counterparts which have been at it for quite a while. They should sync the features up which would make it easier for us multi-disciplinary DBAs

The next set of sessions were on IO

  [Read more...]
MySQL Conference 2010 – Day 1
+0 Vote Up -0Vote Down

Well the first day has come and gone and I really enjoyed my first day as a newbie. The keynote from Oracle was well received, they touched on the new Beta version of MySQL and the new mysql enterprise which to a trained oracle eye is looking more and more like Grid Control. The end result is providing more instrumentation to help the DBA but I am a little disappointed that a lot of that instrumentation is not actually in the database itself which forces you to buy the product.

The O’Reilly Keynote provided some interesting glimpse into the future.

There is a strong contingent from Facebook and those sessions are just packed with everybody wanting to know how they scale their infrastructure.

The spider storage engine presentation tweaked by interested with the promise of vertical partitioning…I’ll have to try that when I come back.

My presentation

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 255 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.