used for operations like sort and joins in queries • Not written in stone: users can SET it overriding its value • But if more memory is used, it spills to disk (and may use different algorithm) reducing performance • Not the same if you are OLTP, OLAP, DW (small to very large) • Raise it from defaults, but don’t forget it could be times max_connections