MySQl has many tweaks available. Most all are done through My.ini, but it's something of a black art.

Unfortunately, MySQL is mostly used for small DBs and the issues we find in a big one (the one I work with is 60GB) are seldom discussed online. While DBAs for other DBs are readily available for hire, MySQl seems to be much tougher.