MySQL - Main

I have being using MySQL for a while now, but never really understood the internal workings, I wanted a site that covers the finer details of MySQL, this will help me to fix difficult problems and tune the database, this site will cover MySQL versions 5.1, 5.5 and the new Oracle 5.6 version.

The site has been comprised of reading the following books and real world experience, if you are new to MySQL I highly recommend that you should purchase these books as they contain far more information than this web site contains and of course the Oracle web site contains all the documentation you will ever need.

Please feel free to email me any constructive criticism you have with the site as any additional MySQL knowledge or mistakes that I have made would be most welcomed.

Introduction

	Introduction
	MySQL Storage Engines
	Accessing MySQL

Extensions and Deviations

	Introduction
	MySQL Deviations
	MySQL Extensions

Tables and Data Types

	Introduction
	Tables
	Data Types
	Enum and Sets
	SQL Modes
	Using NULL
	Optimal Data Types

Indexes

	Introduction
	Speed
	Indexes
	Foreign Key Constraints
	Index Maintenance

Stored Routines, Triggers, Cursors and Events

	Introduction
	Triggers
	Stored Routines
	Handlers
	Cursors
	Events

Views

Introduction

Transactions

	Introduction
	Isolation Levels
	Locking

Tuning

	Introduction
	Tuning MySQL

Caching

Introduction

Backups and Recovery

	Introduction
	Backups and Recovery
	Recovery from Crashes

Users

	Introduction
	Access Control Lists
	Resetting the root password
	Debugging account problems

Partitioning

	Introduction
	Partitioning types - range, list, hash and key
	Merge Tables

Replication

	Introduction
	Replication configurations

Performance

	Introduction
	Benchmarking
	Profiling

Query Analysis

	Introduction
	Explain
	Profiling

Securing

	Introduction
	Operating System Level
	Data Security

Books

MySQL Books
MySQL Administrator's Bible - Sheeri Cabral, Keith Murphy	This book covers all you need to know about MySQL, however it does cover the older version 5.1, but it's still an excellent book
Oracle 11g and MySQL 5.6 Developer Handbook - Michael Mclaughlin	This is one of the first MySQL 5.6 books, it compares Oracle with MySQL, this is a good book if you wish to understand MySQL but have a background in Oracle.