Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 27

Displaying posts with tag: odtug (reset)

Why Dave Schleis is Looking Forward to Kscope12
+0 Vote Up -0Vote Down

Guest Blogger: David Schleis

For the last dozen years, springtime has always meant one thing: cleaning up all the surprises exposed by the melting snow (you northern-tier dog-owners know what I’m talking about). But aside from that, this time of year always meant that it was crunch-time for writing the paper for my upcoming presentation at Kscope. I enjoy writing these papers, but I’d be lying if I said that it was all fun. There are pressures of the deadlines, making sure I get things right, that I don’t use “then” when I mean “than,” and generally that I read smarter

  [Read more...]
Free webinar on preventing MySQL downtime
+0 Vote Up -0Vote Down

I’ll be presenting a free one-hour webinar on preventing downtime in production MySQL servers, in conjunction with the ODTUG. It is scheduled on Thursday, November 10, 2011 3:00 PM – 4:00 PM EST, and you can register for free.

Here’s an abstract of what you’ll learn:

Everyone wants to prevent database downtime by being proactive, but how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have solved, to better understand what types of problems really occur in production environments. The results are somewhat surprising, and will be detailed in this talk. Most incidents

  [Read more...]
Oracle OpenWorld 2010 Wrap-Up – from an #ODTUG Perspective
+0 Vote Up -0Vote Down

Oracle OpenWorld 2010 is over!  While I had to leave early Tuesday (the paying job takes precedence over the volunteer job), there are many things to talk about that happened while I was at OpenWorld this year.  I’ll attempt to cover a few of them in this posting.

Saturday Night, the ODTUG Board and YCC staff got together to discuss our plans and obligations for the week.  With Sunday User Forum, MySQL Sunday, and Oracle Develop to attend to during the week, along with many other meetings, this was an important start to the week.  It was nice for everyone to see everyone again, and to recharge and energize for the tasks ahead during the week.  Below is a picture of fellow Board Members Barbara Morris and Monty Latiolais at the dinner at Annabelle’s Bar and Bistro.

  [Read more...]
Free webinar on MySQL performance this Thursday
+5 Vote Up -0Vote Down

ODTUG invited me to give a webinar and I said yes, so this Thursday you’re invited to join me as I talk about MySQL performance. We’ve come a very long way towards a MySQL that can perform well on modern hardware, and there really isn’t broad recognition of this. A lot of the best work has gone into the InnoDB “plugin” storage engine, which was announced after my co-authors and I sent High Performance MySQL to the press. I will explain what you should be doing differently now than you did two years ago, and suggest a performance-in-a-nutshell configuration baseline for MySQL that’s quite different from what I’d have said in 2008. You can register for free through GoToWebinar. See you there.

Related

  [Read more...]
Data Warehousing Best Practices: Comparing Oracle to MySQL pt 2
+5 Vote Up -3Vote Down

At Kscope this year, I attended a half day in-depth session entitled Data Warehousing Performance Best Practices, given by Maria Colgan of Oracle. My impression, which was confirmed by folks in the Oracle world, is that she knows her way around the Oracle optimizer.

See part 1 for the introduction and talking about power and hardware. This part will go over the 2nd “P”, partitioning. Learning about Oracle’s partitioning has gotten me more interested in how MySQL’s partitioning works, and

  [Read more...]
Data Warehousing Best Practices: Comparing Oracle to MySQL pt 1
+4 Vote Up -3Vote Down

At Kscope this year, I attended a half day in-depth session entitled Data Warehousing Performance Best Practices, given by Maria Colgan of Oracle. My impression, which was confirmed by folks in the Oracle world, is that she knows her way around the Oracle optimizer.

These are my notes from the session, which include comparisons of how Oracle works (which Maria gave) and how MySQL works (which I researched to figure out the difference, which is why this blog post took a month after the conference to write). Note that I am not an expert on data warehousing in either Oracle or MySQL, so these are more concepts to think about than

  [Read more...]
Determining I/O Throughput for a System
+3 Vote Up -3Vote Down

At Kscope this year, I attended a half day in-depth session entitled Data Warehousing Performance Best Practices, given by Maria Colgan of Oracle. In that session, there was a section on how to determine I/O throughput for a system, because in data warehousing I/O per second (iops) is less important than I/O throughput (how much actual data goes through, not just how many reads/writes).

The section contained an Oracle-specific in-database tool, and a standalone tool that can be used on many operating systems, regardless of whether or not a database exists:

If Oracle is installed, run DBMS_RESOURCE_MANAGER.CALIBRATE_IO:

SET SERVEROUTPUT ON
DECLARE


  [Read more...]
Log Buffer #193 – A Carnival of The Vanities for DBAs
+1 Vote Up -0Vote Down

Welcome to Log Buffer, the weekly roundup of DBA industry happenings.

Read on for the latest updates in Log Buffer #193. Don’t forget, we’re always looking for volunteer editors to publish and host an issue of Log Buffer. If you’d like this to be you, contact the Log Buffer coordinator.

ODTUG/Kaleidoscope 2010 roundup:

Sheeri

  [Read more...]
ODTUG Kscope Wrap-up and Slides
+2 Vote Up -0Vote Down

Ronald Bradford and I produced a successful MySQL track at Kaleidoscope (hereinafter referred to as Kscope). With a speaker list of Philip Antoniades, Josh Sled and Craig Sylvester of Oracle, Laine Campbell of PalominoDB, Patrick Galbraith of Northscale, Sarah Novotny of Blue Gecko, Padrig O’Sullivan of Akiba, Dossy Shiobara of Panoptic.com and Matt Yonkovic of Percona, we knew the technical content was going to be great.

As someone who’s helped organize

  [Read more...]
Improving MySQL Productivity – From Design to Implementation
+2 Vote Up -1Vote Down

My closing presentation at the dedicated MySQL track at ODTUG Kaleidoscope 2010 discussed various techniques and best practices for improving the ROI of developer resources using MySQL. Included in the sections on Design, Security, Development, Testing, Implementation, Instrumentation and Support were also a number of horror stories of not what to do, combined with practical examples of improving productivity.

Increasing MySQL Productivity View more presentations from Ronald Bradford.
ODTUG Kaleidoscope 2010: Best Practices
+1 Vote Up -0Vote Down

Updated: 29-Jun-2010, 30-Jun-2010.

For me, ODTUG Kaleidoscope 2010 started on Friday with the ACE Directors briefing. Best practices topic was touched there slightly and I twitted about it. I decided that the feedback deserves a blog post so I’m simply quoting the conversation here. If you have anything to add, you know where to find the comment box.

alexgorbachev:
best practices should be forbidden or rather renamed to blue-prints #
  [Read more...]
MySQL Idiosyncrasies That Bite
+2 Vote Up -0Vote Down

The following are my slides that I presented at ODTUG Kaleidoscope 2010. This presentation talks about the MySQL defaults including a non-transactional state, silent data truncations, date management, and transaction isolation options. These are all critical for data integrity and consistency. I also cover in-depth topics including SQL_MODE, character sets and collations.

MySQL Idiosyncrasies That Bite View more presentations from Ronald Bradford.
MySQL’s SQL Deviations and Extensions
+3 Vote Up -1Vote Down

Today at Kaleidoscope I will be doing a 90-minute session comparing MySQL’s SQL syntax to the ANSI/ISO SQL:2003 standard, entitled What Do You Mean, “SQL Syntax Error”?

You can download the PDF slides now.

For those that may be following along the presentation later today (4 pm Eastern time), here are some links that I may throw out during the session:

  • SQL 2003 standard – actually it is “Information taken from the Final Committee Draft (FCD) of ISO/IEC 9075-2:2003″ but it’s extremely close to the actual standard. The actual standard is a document that costs a non-trivial amount of money to get, and cannot be



  [Read more...]
ODTUG Kaleidoscope 2010 — Ready… Set… Go-o-o!
+1 Vote Up -0Vote Down

It is time… Time for one more very special conference for me. Why special?

  • I have never been to ODTUG Kaleidoscope before. I always like new conferences — new experience.
  • Unlike Sheeri, I do not speak! This is one of those rare conferences where I come to slack off, meet old friends and make new ones, go to lots of sessions and actually learn stuff.
  • Coming from the DBA background, it’s not often that I come to development oriented conferences and I think I should do more of that.
  • It’s in Washington, DC. I lived there for some time and have number of good friends there. I’m really excited to see them again!
  • So what am I going to do there? I just arrived and right in time for the Oracle ACE Directors’

      [Read more...]
    Next Week’s MySQL Sessions at ODTUG Kaleidoscope
    +3 Vote Up -1Vote Down

    By now you know that there is a MySQL Track during next week’s ODTUG Kaleidoscope in Washington, DC. Ronald Bradford and I organized the schedule at the last minute (Ronald did a lot of the work!). It was difficult to fill a schedule with 19 sessions that are either 1 hour or 1.5 hours long, and to do it I ended up with three presentations.

    At each presentation I will be giving away a copy of The MySQL Administrator’s Bible, so be sure to show up! All MySQL track sessions are in Maryland C, and all times are Eastern.

    On Monday, June 28th from 4 pm – 5:30 pm I will be presenting

      [Read more...]
    #ODTUG Kaleidoscope 2010 Odds and Ends
    +0 Vote Up -0Vote Down

    Several things to think about in the next 10 days leading up to Kaleidoscope.

    1. The Marriott Wardman Park is out of rooms. If you’re attending and haven’t reserved a room yet, you may get lucky with a cancellation, but there are several hotels on the Metro line that should have openings. The conference and location is very popular, and while I wish we could accommodate everyone, it’s not going to be possible. Here’s a good suggestion: when next year’s conference dates and location are announced, register and reserve your room as soon as possible (hint – these announcements will be made at our general session on Monday, June 28 starting at 8:30 AM).

    2. The

      [Read more...]
    Still room at Kaleidoscope for MySQL attendees
    +3 Vote Up -0Vote Down

    Today I received notice that next week’s Velocity conference is at maximum capacity. With just under 2 weeks before the start of ODTUG Kaleidoscope in Washington DC we still have room for late registrations. There is 4 days of MySQL content, free events and also a Sunday Symposium that includes talks on performance and high availability.

    Contact any of the MySQL speakers directly and you can receive a special 50% discount code. This is only for MySQL attendees.

    If you live in the DC area and only want the FREE option then come along and join use on Monday night for a free session and reception.

    ODTUG Kaleidoscope 2010
    July 27 – July 1
    Marriott Wardman Part Hotel
    2660 Woodley Road NW
    Washington, District Of Columbia 20008





      [Read more...]
    I’ll have a MySQL shot to go!
    +0 Vote Up -0Vote Down

    Wednesday night of the MySQL track of ODTUG Kaleidoscope will include an evening with Last Comic Standing comedian, John Heffron. It should be great way to unwind after day 3 of the conference. Black vodka anybody.

    Check out the MySQL Schedule for more information of presentations for the 4 days. More details is also available here.

    Introducing #Oracle #MySQL ACE Director Ronald Bradford to #ODTUG
    +0 Vote Up -0Vote Down

    As I promised in my previous blog posting, I got the opportunity to ask Ronald Bradford some questions.  I hope this serves as an introduction to Ronald, and that you’ll attend Kaleidoscope to learn more from Ronald in person.

    Ronald Bradford

    MR: Would you like to share some background information about yourself for our ODTUG readers?

    RB: “I have worked with various RDBMS technologies for 20+ years.   I was first introduced to Ingres at university and after my Bachelors Degree in 1989. I started my professional IT career

      [Read more...]
    ODTUG and MySQL
    +0 Vote Up -0Vote Down

    With the help of the MySQL community leaders, ODTUG has embraced the opportunity to add MySQL content to the already jam-packed agenda at ODTUG Kaleidoscope 2010, in Washington, DC from June 27 – July 1.

    This track starts on Monday, and will have presentations running the entire length of the conference. The track is highlighted by its participation in the Sundown Sessions with the Oracle ACE Directors. In this session, Sheeri K. Cabral and Ronald Bradford, two of the current three Oracle MySQL

      [Read more...]
    The MySQL Track at Kaleidoscope is set!
    +5 Vote Up -1Vote Down

    The MySQL track at Kaleidoscope in Washington, DC during June 28-July 1st is set! Here is the schedule, Lincoln VI is the MySQL track room.

    Ronald has done a super job and spent a ton of hours in the past several weeks coordinating this effort. Work has kept me much busier than normal, but I have lent some time to the coordination as well. It is a credit mostly to Ronald that we have been able to plan an entire 19-session conference track, complete with confirming speakers, in less than a month. (You may notice the schedule does not have all 19 sessions full, we are just waiting for some more speakers to confirm details.)

    Whether or

      [Read more...]
    MySQL track with free event at Kaleidoscope 2010
    Employee_Team +7 Vote Up -0Vote Down

    The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. The great news this year is that, at popular demand, there will be a MySQL track, organized and manned by the MySQL community.

    The even greater news is that, in addition to the general schedule, there are SUNDOWN SESSIONS

    Monday, June 28, 5:45 p.m. – 6:45 p.m. (reception immediately following)

    Join us on Monday, June 28 for a lively open discussion with Oracle MySQL ACE Directors. In addition to a specific session on MySQL, other Sundown Sessions will address: Middle Tier and Client-Side Development, Database

      [Read more...]
    ODTUG Announces #MySQL Track at Kaleidoscope
    +0 Vote Up -0Vote Down

    Just a quick blog posting today…ODTUG Kaleidoscope 2010 is proud to announce the addition of a FULL MySQL track for the conference! Starting on Monday, June 28th, and running until the end of the conference on Thursday, July 1st, the track will host 19 sessions on MySQL. The MySQL database is the world’s most popular open source database, and is used by many popular and successful websites.

    The track was put together in much the same way that ODTUG added its highly successful Hyperion and Essbase content to the conference, starting back in 2008. ODTUG recognized an opportunity to help out the community by providing room for content to be presented. Then, we connected with a respected leader in the MySQL community, one of the first three

      [Read more...]
    Free MySQL Event in Washington DC
    +13 Vote Up -0Vote Down

    As the program chair for the recently announced MySQL Track at the ODTUG Kaleidoscope conference located in Washington DC we are also looking into an associated free community event for MySQL locals in addition to a dedicated track for 4 days.

    Please let us know your name and email via the form at http://ronaldbradford.com/ODTUG/free-event/ so we can provide more details in the coming week as we try to finalize logistics.

    Registration will be necessary for attendance however for now we just want to know who is local so we can provide more details soon!

    Updated. Full details of the free Monday night sundown sessions and reception can be found at MySQL track with free event at Kaleidoscope 2010

    Wishing I could be at ODTUG
    +2 Vote Up -1Vote Down

    Ronald asked me if I could present at ODTUG’s Kaleidoscope conference, which is only a couple hours from me, but I’ll be at the Netways OSDC that week. Matt Yonkovit will be there representing Percona. I wish I could go: I would really like to mingle with more Oracle users and developers, and I think that participation is the key to building relationships between MySQL and Oracle users — two groups of people who are going to be overlapping more in the future. If you can attend, I hope you will — and blog about it so I can read.

    Related posts:

  • OpenSQL Camp events in 2009 There are
  •   [Read more...]
    MySQL track at ODTUG conference 2010
    Employee_Team +11 Vote Up -0Vote Down

    The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. The great news this year is that, at popular demand, there will be a MySQL track, organized and manned by the MySQL community.

    . Also see TAG -->

    The ODTUG is an independent group of very skilled Oracle users,  [Read more...]

    MySQL Track at Kaleidoscope
    +11 Vote Up -2Vote Down

    On Monday, Ronald Bradford posted that the independent Oracle Developer Tools User Group had opened up their Kaleidoscope Conference, well-known throughout the Oracle community for in-depth technical sessions for developers, to the MySQL community. Giuseppe Maxia posted his thoughts on Tuesday.

    We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle. We contacted

      [Read more...]
    Showing entries 1 to 27

    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.