Best way to optimize MySQL database

I need a good solution on how to get more users. JM load test says will not work with 500 concurrent users.
Are their specific things to check with the DB? And things to improve the concurrent users?

See original post by Brad77