Yes. MySQL is fully multi-threaded, and will make use of multiple CPUs provided the operating system supports it.