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).
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 http://technocation.org/node/693/play.
…
[Read more]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.
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:
Interpreting the output of the MySQL EXPLAIN command can be
tricky. From all the information you get, some of the most
important information is:
This can be hard to see in the raw output. Example query:
EXPLAIN SELECT b.item_id, b.bidder_id, u.username, MAX(price)
AS price FROM bid b JOIN user u ON (b.bidder_id = u.user_id)
WHERE b.item_id = '1' GROUP BY b.bidder_id ORDER BY price
DESC
The explain outputs:
id, select_type, table, type, possible_keys, key, key_len, ref,
rows, Extra
1, SIMPLE, b, ALL, null, null, 0, null, 22660, Using where; Using
temporary; Using filesort
1, SIMPLE, u, eq_ref, PRIMARY, PRIMARY, 4,
heavybidder.b.bidder_id, 1,
We've been experimenting how to visualize the output of …
At the 2008 MySQL Conference and Expo, Ronald Bradford delivered "The Top 20 Design Tips for Enterprise Data Architects". See the slides on the Forge at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Top_20_DB_Design_Tips_Every_Architect_Needs_to_Know
At the 2008 MySQL Conference and Expo, there was a panel discussion on "Addressing Challenges of Data Warehousing - a Panel Discussion" including:
Robin Schumacher (Sun/MySQL) (moderator)
Brian Miezejewski (MySQL), Charles Hooper (Pro Relational Systems), Paul Whittington (NitroSecurity, Inc.), Raj Cherabuddi (Kickfire), Victoria Eastwood (InfoBright Inc.)
At the 2008 MySQL User Conference and Expo, Farhan Mashraqi spoke about "Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008ThursdayNotes#Optimizing_MySQL_and_InnoDB_on_Solaris_10_for_World.27s_Largest_Photo_Blogging_Community
At the 2008 MySQL User Conference and Expo, Baron Schwartz spoke on "The MySQL Query Cache". Download the slides, see people's notes, and more on the MySQL Forge Wiki at http://forge.mysql.com/wiki/MySQLConf2008WednesdayNotes#The_MySQL_Query_Cache
I have finally managed to watch and slightly edit the September 2007 Boston MySQL User Group presentation I did on the MySQL Proxy.
It's geared towards beginners, and has lots of examples, including explaining some of the examples that come bundled with the MySQL Proxy.
Download video (.wmv file, 612 Mb)
Download video (.wmv file, 76.10 Mb)
Enjoy!
Some resources:
Presentation Slides PowerPoint (ppt) or PDF or …