Home

General

Trouble with Percona blog at mysqlperformanceblog.com

Posted August 25th, 2009 by sheeri

In the past few days it has come to my attention that some people are having problems with Percona's blog at http://www.mysqlperformanceblog.com. I was told that trackbacks seem to be broken and some comments were not showing up.

Anyone else having any problems with what looks like censorship? [edit: trackbacks were a technical error, Dave's comment was trapped in a spam trap. Still looking for people to comment whether or not they're seeing a similar issue, as it's important for people to check to see if their comments are showing up.]

Video: MySQL 5.4

Posted May 15th, 2009 by sheeri

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: Beginner Guide to Website Performance with MySQL and memcached

Posted April 22nd, 2009 by sheeri

Video for the presentation at the 2009 MySQL Conference:

Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)

Slides

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

Video: Understanding How MySQL Works by Understanding Metadata, part 2

Posted April 20th, 2009 by sheeri

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.

Video: Understanding How MySQL Works by Understanding Metadata, part 1

Posted April 20th, 2009 by sheeri

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.

Video: Sphinx Full-Text Search Engine

Posted April 19th, 2009 by sheeri

Andrew Aksyonoff speaks at the April 2009 Los Angeles MySQL User Group about how to use Sphinx, the free open source full-text search engine.

Description:
Just how do you implement keyword search through that 10-million-row InnoDB table? Meet Sphinx, a blazing fast open source engine that makes it a breeze. We'll talk about what it is, how it works, and when and why use it.

The user group page is at: http://www.meetup.com/lamysql/calendar/9882984/

Video: MySQL Sandbox

Posted April 19th, 2009 by sheeri

Giuseppe Maxia speaks at the April 2009 Los Angeles MySQL User Group about MySQL Sandbox and how to use it for simple and complex sandbox scenarios.

Tom Kyte Presents: Why Upgrade to Oracle 11g?

Posted April 2nd, 2009 by sheeri

Tom Kyte speaks for about an hour on the newest features in Oracle 11g, including how many new features and enhancements there are. The presentation itself can be downloaded from Tom's site and the video can be directly played in your browser on YouTube at http://www.youtube.com/watch?v=25oUes-pMwI or in the embedded video below:

Drizzle Podcast #1

Posted February 25th, 2009 by sheeri

25:10 minutes (5.77 MB)

In this first Drizzle Podcast, Sheeri K. Cabral and Jay Pipes talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint.

OpenSQLCamp Video: How SQL Database Engines Work

Posted November 15th, 2008 by sheeri

Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008.

The description:
To many programmers, SQL RDBMSes are a magical black box. A talk can help clear up a lot of the mystery. SQL users tend to make better use of the language once they have a rough idea of what is going on beneath the covers.

Moving Application Logic Into the Database by Bruce Momjian

Posted November 15th, 2008 by sheeri

Bruce Momjian talks about general strategies for moving application logic into databases, mostly why to do it and why to not do it. This talk is mostly DB agnostic. Note that the slides have a title of "Processing Data Inside PostgreSQL". The slides can be found at http://www.slideshare.net/EnterpriseDB/data-processing-inside-postgresql.

The State of Open Source Databases: OpenSQL Camp Keynote Featuring Brian Aker

Posted October 16th, 2008 by sheeri
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.

MySQL Views Presentation at the September 2008 Boston MySQL User Group

Posted September 12th, 2008 by sheeri
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: * Defining views, changing views, deleting views * Using views for column and row level security * Using views for schema abstraction * Simulating check constraints using views * Performance implications * How to find out which tables are views, and information about views * What a materialized view is, and that MySQL does not have them * What makes a view updateable * Problems with updateable views * How views interact with replication

OSCon 2008 Video: Does Open Source Need to Be Organic?

Posted August 25th, 2008 by sheeri
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. Stream directly online at http://technocation.org/node/614/play or download the 271 Mb .wmv file at http://technocation.org/node/614/download.

OSCon 2008 Video: Open Voices (Legal Panel)

Posted August 25th, 2008 by sheeri

"Open Voices" was a legal panel consisting of Jim Zemlin of The Linux Foundation, Keith Bergelt of the Open Invention Network, Karen Sandler of the Software Freedom Law Center and Phil Robb of Hewlett Packard (FOSS Bazaar project).

123next ›last »