How to squeeze all juice from MYSQL

Any tips to squeeze max performance from mysql ? I been reading so many articles and cant see any clear suggestions.

I need at least max performance for 1 table, which most of the time doing INSERTs and UPDATE

 

depends on where you're limited. Make sure to create indexes where applicable.

 

I agree, most important is create index.

For insert, if you trying to insert many data, you can try place them in a temp table