How to reduce load on mysql?

Question

MySQL

How to reduce load on mysql?
1. show full processlist - 10-12 requests maximum ( Sorting result , Waiting for table level lock )
2. slog is empty, there are no such requests
3. 150-200 people work in the system
4. records in the database - 600k

Answer 1

Upgrade to MariaDB 10, it's a fully compatible fork. I have been working in production for 2 years. On the default config, LA fell from 7 to 0.4.
The most important thing is to switch from InnoDB to Xtradb, from MyISAM to ARIA. All are fully compatible

Answer 2

Waiting for table level lock

table level? Is there myisam instead of storage engine?
Why is there an empty slow query log:
dev.mysql.com/doc/refman/5.6/en/slow-query-log.html

The time to acquire the initial locks is not counted as execution time.

Answer 3

optimize settings - mysqltuner.pl, for example, run
if there are constantly requests in the queue - it means that it does not have time for something;)