Upload

Loading icon Loading...

This video is unavailable.

MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike tcation's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add tcation's video to your playlist.

Uploaded on Apr 19, 2010

Sheeri K. Cabral (Pythian) speaks at the 2010 O'Reilly MySQL User Conference & Expo.

Slides: http://bit.ly/my10vars2

From the official description at http://en.oreilly.com/mysql2010/publi...

MySQL offers a complex amount of information in commands like SHOW VARIABLES, SHOW STATUS and SHOW ENGINE INNODB STATUS. This 2-part tutorial will mine through the information to show how to use the information to make decisions about performance tuning and capacity planning. Sheeri Cabral of the Pythian group explains all the variables and how to use them in a way that a MySQL newbie can understand and a seasoned MySQL expert will learn something new.

Part II: Intermediate MySQL Variables * Locking variables * MyISAM basic variables * MyISAM FULLTEXT variables * MyISAM repair variables * MyISAM index cache variables * INSERT DELAYED variables * Basic transaction variables * InnoDB basic variables * InnoDB performance tuning variables * InnoDB concurrency variables and how the InnoDB ticketing system works * InnoDB deadlock and semaphore variables * InnoDB File I/O variables * Global File I/O variables * OS-specific variables (for Windows, Linux, Solaris) * OS-related variables (relating to file descriptors, thread handling, etc) * Network-related variables (including timeouts) * Profiling variables

This is the second video in a day-long tutorial.

See also:

part 1, before break: http://www.youtube.com/watch?v=3H0-CL...
part 1, after break: http://www.youtube.com/watch?v=Mn9h7i...
part 2, before break: http://www.youtube.com/watch?v=RKwfv7...

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Suggestions

Loading...
Working...
to add this to Watch Later

Add to