Have fun reading. There is a *LOT* of information in the MySQL documentation about all of this. Don't expect someone to give you an answer in 3 paragraphs in this forum when MySQL gives you pages and pages and pages of information and all you have to do is read it.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.