Mysql cannot do parallel query. That's a single query won't spin off multiple threads and work in parallel. This makes it a bad solution for say aggregating over large data. Mysql can handle lots of threads(queries) in parallel making it an ideal solution for web.

Postgres can do parallel query.