Query Optimization

OurSQL Episode 78: Removing Evil Queries, part 2

This week, we continue our series on query optimization by talking about how to use EXPLAIN to optimize queries. Part 1 of the series.

Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th at the Santa Clara, CA convention center. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!
. Check out the tutorial and session schedule!

OurSQL Episode 77: Removing Evil Queries, part 1

This week, we talk about how to find mysql queries to optimize in part 1 of a series on query optimization.

Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!.

The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies will be held in Buenos Aires in June. It is called the MariaDB NoSQL & Cloud Latin American Conference and we'll bring you more information as it becomes available.

Video: Chasing Bottlenecks

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.

Video: Map/Reduce and Queues for MySQL Using Gearman

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

Download the PDF slides.

http://www.youtube.com/v/xDRDu

Video: Beginner Guide to Website Performance with MySQL and memcached

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: Top 10 MySQL Pet Peeves and How to Workaround Them

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:

Video: Advanced Query Manipulation with MySQL Proxy

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

Video: Testing with the MySQL Random Query Generator

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: Sphinx Full-Text Search Engine

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/

http://www.youtub

Real Time Data Warehousing Presentation

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.

Pages


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32