sorted by: recent | see :
popular
Content Tagged with Optimization + MySQL
The Top 20 Design Tips for Enterprise Data Architects
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
Server
MySQL
query
optimization
performance
tuning
presentations/videos
Video: The MySQL Query Cache
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
Server
MySQL
query
optimization
performance
tuning
Conferences
Video: Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community
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
Server
MySQL
query
optimization
performance
Conferences
presentations/videos
Video: Addressing Challenges of Data Warehousing - a Panel Discussion
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.)
Server
MySQL
query
optimization
performance
tuning
Conferences
EXPLAIN Cheatsheet
At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive.
For those not at the conference, or those that want to make more, the file is downloadable as a 136Kb PDF at explain-diagram.pdf
* or tea, for those of us in the civilized world.
google-mysql-tools - Google Code
open-source: del.icio.us tag/open-source
Database
MySQL
python
Google
sysadmin
optimization
performance
MySQL Proxy Presentation at the September 2007 Boston MySQL User Group
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 Flash (swf) More »
High Performance MySQL, Second Edition: Schema Optimization and Indexing
I've been trying to circle back and clean up things I left for later in several chapters of High Performance MySQL, second edition. This includes a lot of material in chapter 4, Schema Optimization and Indexing. At some point I'll write more about the process of writing this book, and what we've done well and what we've learned to do better, but for right now I wanted to complete the picture of what material we have on schema, index, and query optimization. The last two chapters I've written about (Query Performance Optimization and Advanced MySQL Features) have generated lots of feed back along the lines of "don't forget X!" to which I'm obliged to reply "It's in a different chapter."
Click through to the full article for more prose, plus the outline.
High Performance MySQL, Second Edition: Query Performance Optimization
Your comments on the Advanced MySQL Features chapter were great. A lot of the questions I got (in the comments and via email) about chapter 6 are really addressed in chapter 5, "Query Performance Optimization," so I'm posting its outline too. I have the same questions: are there things you'd like to see us cover? Do you have any favorite techniques you'd like to see us include? Any other comments or questions?
High Performance MySQL, Second Edition: Advanced SQL Functionality
Work continues apace on High Performance MySQL, Second Edition (the link leads to the chapter outline). I'm working now on Chapter 6, Advanced SQL Functionality, and thought I'd solicit input on it. Are there things you'd like to see us cover? Do you have any favorite techniques you'd like to see us include? Feel free to leave feedback in the comments. The chapter is already significantly done, with 26 pages written, but the ink's not on paper yet, so there's still time to correct omissions!
How to check and optimize MySQL tables in parallel
I wanted to point out something that might not be obvious from the name: MySQL Parallel Dump can be used as a generic wrapper to discover tables and databases, and fork off worker processes to do something to them in parallel. That "something" can easily be invoking mysqlcheck -- or any other program. This makes it really easy for you to do multi-threaded whatever-you-need-to-do on MySQL tables. Here's how.
MySQL Proxy
opensource: del.icio.us tag/opensource
Software
SQL
MySQL
proxy
optimization
scalability
opensource