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 30 of 72 Next 30 Older Entries

Displaying posts with tag: Presentations/Videos (reset)

OurSQL Episode 49: Stalking MySQL
+2 Vote Up -1Vote Down

Reminder: Due to busy summer conference schedules, we are going to be publishing the podcast every other week.

This week we talk about a monitoring plugin from PalominoDB that uses caching (like the cacti templates) and allow for arbitrary calculations of thresholds based on status and system variables, and items from the PROCESSLIST.

Nagios
pnp4nagios - from the site, "PNP is an addon for the Nagios Network Monitoring System. PNP provides easy to use, easy to configure RRDTools based performance charts feeded by the performance data output of the Nagios Plugins."

read more

OurSQL Episode 32: Backup tools you already have [Backup series #2]
+2 Vote Up -0Vote Down

Show notes:

Previous backup series podcast:
Backup glossary [Backup series #1]

Feedback:
In the backup glossary we asked if anyone knew how to get logical data out of physical InnoDB files. Mike Hamrick of Blue Gecko wrote in to say that Percona's InnoDB recovery tool helps to do just that. He writes:

"The 'page_parser' tool will read ibdata files or individual .ibd files and turn them into a series of 16k page files suitable for processing with a tool called 'constraints_parser' which spits out a number of tab separated lines of table data suitable for a LOAD DATA INFILE.

read more

Fantastic VoltDB presentation (video and slides available) by Tim Callaghan at the Boston MySQL User Group
+4 Vote Up -0Vote Down

Special thanks to Tim Callaghan for giving a fantastic presentation of VoltDB at Monday's Boston MySQL User Group meeting. Even though the title was "for SQL developers" there was a lot of content for DBAs as well (how backups are done, what the data and server-level architecture is, etc). It was an EXCELLENT presentation on how VoltDB works, and what applications it is and is not appropriate for. The video is almost 2 hours long; there's a LOT of excellent information in it.

The slides can be downloaded (PPT format) from:
http://technocation.org/files/doc/2010_09_VoltDB.ppt

read more

MySQL User Group Videos
+1 Vote Up -0Vote Down

2009 Boston MySQL User Group Videos:

Dec 2009 - Time Zones in MySQL (Sheeri K. Cabral) - video - PDF presentation - Description

Nov 2009 - How InnoDB works: Exploring SHOW ENGINE INNODB STATUS (Sheeri K. Cabral) - video - PDF presentation - Description

read more

Eric Day and Patrick Galbraith speak about Drizzle at the July 2009 Boston MySQL User Group
+0 Vote Up -0Vote Down

Eric Day and Patrick Galbraith spoke on Drizzle, Gearman and Narada at the July 2009 Boston MySQL User Group. This is part 1 of the video, which is about an hour long and is about Drizzle.

"We will explain what the Drizzle project is, what we aim to accomplish, and an overview of where we are at."

The slides can be downloaded from http://www.oddments.org/notes/DrizzleGearmanBoston2009.pdf

The User Group calendar item for this event is http://www.meetup.com/mysqlbos/calendar/10607736/

read more

Video: Chasing Bottlenecks
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Camp:
Chasing Bottlenecks
by Morgan Tocker

Description:
The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.

read more

How I hacked the HP Mini Mobile drive port to be a normal USB port
+0 Vote Up -0Vote Down

So I got my hands on an HP mini 1000 last week. Not bad for $250 at Best Buy, although it has needed some help, namely:

- External USB hard drive - I got the Mini 1000 that comes with a 16 Gb SSD, and want this to be my primary computer (I'm not a gamer, just web surfing and *occasional* video editing). I bought a 320Gb Buffalo Mini Station, for about $60 at Microcenter.

- 2 Gb RAM - already had a stick, free for me (otherwise $20), easy to pop in.

- USB to VGA adapter - HP has a nice proprietary VGA port, to which they didn't have an adapter for a long time (6 months or so)....now, the adapters exist, but they're out of stock. I bought a USB to VGA adaptor at Microcenter for about $70.

read more

Making Drupal Dance: Techniques for Non-obvious Theme Manipulations
+0 Vote Up -0Vote Down

John Albin Wilkins presents "Making Drupal Dance: Techniques for Non-obvious Theme Manipulations at the 2009 Design 4 Drupal conference in Boston. Unfortunately the beginning is cut off; however there is still over 40 minutes of video and plenty of good information in the video.

read more

Video: MySQL 5.4
+0 Vote Up -0Vote Down

Giuseppe Maxia spoke at the May 2009 Boston MySQL User Group about MySQL 5.4 and what it can do, the new performance features, etc.

Video: Optimizing MySQL Performance with ZFS
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Conference:

Optimizing MySQL Performance with ZFS
Allan Packer (Sun Microsystems), Neelakanth Nadgir (Sun Microsystems)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7121

Watch the video at

read more

Video: Top 10 MySQL Pet Peeves and How to Workaround Them
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Camp:
Top 10 MySQL Pet Peeves and How to Workaround Them
Jeremy Zawodny

Watch it online here:

Download the 106 Mb .mov file at

read more

Video: ScaleDB Storage Engine
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Conference:

The ScaleDB Storage Engine: Enabling High Performance and Scalability Using Materialized Views and a Shared-Disk Clustering Architecture
Moshe Shadmon (ScaleDB)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7112

read more

Video: InnoDB Database Recovery Techniques
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Camp:
InnoDB Database Recovery Techniques
Peter Zaitsev (Percona)

Description:
Have you ever had Innodb database corrupted or have deleted data accidentally and want it back ? This session will go through various approaches you can use to get most of your data back using MySQL build in features as well as third party open source tool.

This session speaks about Innodb database recovery techniques (apart from recovering from back).

First we will discuss various types of Innodb corruption and data loss scenarios ranging from user error to hardware failures.

read more

Video: High Performance Ruby on Rails and MySQL
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Conference:

High Performance Ruby on Rails and MySQL
David Berube (Berube Consulting)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6942

read more

Video: Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Conference:

Tricks and Tradeoffs of Deploying MySQL Clusters in the Cloud
Thorsten von Eicken (RightScale, Inc)

Slides

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/6912

Unfortunately, this video was cutoff, but most of the presentation is available.

read more

Video: Advanced Query Manipulation with MySQL Proxy
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Conference

Advanced Query Manipulation with MySQL Proxy
Kay Roepke (Sun Microsystems)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7040

Play the video directly in your browser
Download the video

Video: Testing with the MySQL Random Query Generator
+0 Vote Up -0Vote Down

Video from the 2009 MySQL Conference presentation:

If You Love It, Break It: Testing MySQL with the Random Query Generator Philip Stoev (Sun Microsystems)

The description is at:
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363

Download the presentation slides (ppt).

Video: Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled
+0 Vote Up -0Vote Down

The video for the 2009 MySQL Conference presentation:

Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled
Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.)

Description

(no slides available at the time of the posting).

Video: Understanding How MySQL Works by Understanding Metadata, part 2
+0 Vote Up -0Vote Down

Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

read more

Video: Understanding How MySQL Works by Understanding Metadata, part 1
+0 Vote Up -0Vote Down

Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

read more

Video: What the MySQL Is This, Anyway?
+0 Vote Up -0Vote Down

Giuseppe Maxia and I are in the exact middle of our leg of the MySQL Campus Tour. Yesterday's session is was recorded -- A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb).

The video is below:

read more

Real Time Data Warehousing Presentation
+0 Vote Up -0Vote Down

At the March Boston MySQL User Group meeting, Jacob Nikom of MIT's Lincoln Laboratory presented "Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications." In the middle of the talk, Jacob said he sometimes calls what he did in this application as "real-time data warehousing", which was so accurate I decided to give that title to this blog post.

The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf. The 54 minute video can be downloaded (644Mb) at http://technocation.org/node/693/download or streamed directly in your browser at

  [Read more...]
Video: Partitioning in MySQL 5.1
+0 Vote Up -0Vote Down

At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.

The sildes are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The 380.6 Mb .mov movie (1 hr 16 min) can be played directly in your browser at http://technocation.org/node/671/play or downloaded at http://technocation.org/node/671/download.

read more

New in MySQL 5.1: The Presentation
+0 Vote Up -0Vote Down

What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html.

Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x").

And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

read more

How to Stop Hating MySQL
+0 Vote Up -0Vote Down

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths".

The presentation slides can be downloaded as a PDF at:

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

View the video online at http://technocation.org/node/646/play or download the 202.5 MB Flash video file (.flv) directly at http://technocation.org/node/646/download.

Here are some notes and links I referred to:

read more

The State of Open Source Databases: OpenSQL Camp Keynote Featuring Brian Aker
+0 Vote Up -0Vote Down

Brian Aker delivers the keynote speech at OpenSQL Camp: State of the Open Source Databases.

The presentation begins with:
"There is no way I'm going to tell you exactly where the future of databases go. We have way too many egos in the room to ever even begin a discussion..."

and ends with Aker saying,
"What the hell does that mean?"

My summary: open source databases are already ubiquitous, we need to make them better/faster/consume fewer resources.

Brian's summary: What part of my keynote surprised people? How ubiquitous bot nets are, and how they act as a big decentralized data store.

read more

MySQL Views Presentation at the September 2008 Boston MySQL User Group
+0 Vote Up -0Vote Down

This Monday, September 8th, the Boston MySQL User Group broke our 2-month summer hiatus with a presentation on MySQL Views.

The slides can be downloaded from http://www.technocation.org/files/doc/2008_09_Views.pdf -- 89 kB, .pdf format.

The 199 Mb .flv file can be downloaded at http://technocation.org/node/621/download or played directly in your browser at http://technocation.org/node/621/play.

The presentation covers:

read more

OSCon 2008 Video: Does Open Source Need to Be Organic?
+0 Vote Up -0Vote Down

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there’s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

read more

OSCon 2008 Video: State of ... Lightning Talks
+0 Vote Up -0Vote Down

"The State of" Lightning talks, moderated by Josh Berkus, is always a great highlight.
OSCon 2008's speakers and projects included:

  • Alan Kasindorf: Memcached
  • Glynn Foster: OpenSolaris
  • OSI: Danese Cooper
  • MySQL: Monty Widenius
  • PostgreSQL: Bruce Momjian
  • GNOME: Dave Neary
  • Gentoo: Donnie Berkholz
  • OpenOffice.org: Louis Suarez-Potts
  • Jabber: Peter Saint-Andre
  • Mozdev: Brian King
  • OpenID: Scott Kveton
  • Open Scrum: James Dixon
  • Talking Book Project: Cliff Schmidt
  • read more

OSCon 2008 Video: Does Open Source Need to Be Organic?
+0 Vote Up -0Vote Down

A panel consisting of Brian Aker of MySQL, Rob Lanphier of Linden Lab, Stephen O'Grady of Redmonk, and Theodore Ts'o of the Linux Foundation gives some answers to the question, "Does Open Source Need to Be Organic?" This topic stemmed from a few posts by Ts'o a few months before OSCon.

From the official conference description:

there?s much more to a software project than just the license. Are software projects dominated by a single company still open source? Does a project need to be 'organic' to be truly open source? What does "organic" even mean in this context? Join us as we discuss these topics and more.

read more

Showing entries 1 to 30 of 72 Next 30 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.