Explore why COUNT(*) can be slow in MySQL and learn effective strategies for optimizing row counting in large tables.