I had a fairly big MySQL database for a customer. They had a top of line server with 64GB of RAM and fast drives. Number of users was not an issue. I spent a lot of time tuning the database. At the time I used MonYog which provided loads of tips on how to get the most out of the server and MySQL. Here's a link to the company with their latest tools.