Upload

Loading icon Loading...

This video is unavailable.

MySQL Configuration Options and Files: Basic MySQL Variables (Part 1) (after break)

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/my10vars1

From the official conference 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 I: Basic MySQL Variables * System vs. Status variables * Variables relating to functions and features * Using more than one config file * MySQL files and directories * Global performance tuning variables (including optimizer variables) * Query tuning variables (sorts, joins, full table scans) * Replication variables * Variables used in logging * How to run SQL commands on server start, on slave start and on each client connection * Global memory variables (including query cache) * Global security variables * Connection and thread variables * Locale, character set, and collation variables * Variables affecting SQL behavior * Variables that are not used, or not useful.

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 2, before break: http://www.youtube.com/watch?v=RKwfv7...
part 2, after break: http://www.youtube.com/watch?v=WfO0Zp...

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