|
If the MySQL site (including documentation) isn't working for you, try a mirror site.
"But," you ask, "how do I know what the mirror sites are if I can't access the site?"
Great question! Technocation has a mirror site (updated daily) at http://technocation.org/mirror/mysql/.
Also, we have purchased www.mysqlmirrors.com which points to the official list of mirrors at http://technocation.org/mirror/mysql/downloads/mirrors.html.
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
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/
Video for the presentation at the 2009 MySQL Conference:
SPIDER Storage Engine: Database Sharding by Storage Engine
Kentoku SHIBA (ST Global.,Inc)
The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6837
Video for the presentation at the 2009 MySQL Conference:
Map/Reduce and Queues for MySQL Using Gearman
Eric Day (Sun Microsystems), Brian Aker (Sun Microsystems, Inc.)
The official conference page is at
http://www.mysqlconf.com/mysql2009/public/schedule/detail/7346
Video for the presentation at the 2009 MySQL Camp:
Grand Tour of the Information Schema and its Applications
Roland Bouman
Description:
The following topics will be covered:
- Introduction of the information schema and it’s components
- How to generate WIKI documentation from the information schema
- Generating code (triggers, SPs) to maintain a rich history database
- Creating a stored procedure to check violated foreign key constraints
- Creating a stored procedure to create federated tables
Video for the presentation at the 2009 MySQL Conference:
Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)
The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009
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.
Video for the presentation at the 2009 MySQL Camp:
Intro to XtraDB, a Scalable InnoDB-based Storage Engine
Ewen Fortune (Percona)
Description:
XtraDB is a storage engine for MySQL based on the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB.
XtraDB includes all of InnoDB’s robust, reliable ACID-compliant design and advanced MVCC architecture, and builds on that solid foundation with more features, more tunability, more metrics, and more scalability. In particular, it is designed to scale better on many cores, to use memory more efficiently, and to be more convenient and useful. The new features are especially designed to alleviate some of InnoDB’s limitations. Vadim will talk about current status of XtraDB and directions of development.
Video for the presentation at the 2009 MySQL Conference:
Using the Event Scheduler: The Friendly Behind-the-Scenes Helper
Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems)
The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7115
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.
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.
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/
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.
Sheeri K. Cabral speaks at the April meeting of the Los Angeles MySQL User Group about What's New in MySQL 5.1 -- the changes in MySQL 5.1 and everything you need to know about upgrading.
Get the slides at http://technocation.org/files/doc/2008_12_New51.pdf
See an accompanying blog post with more information at http://www.pythian.com/news/1414/new-in-mysql-51-sheeris-presentation