How to optimize mysql?

A

Alexey Tutubalin2014-11-21 08:07:15

MySQL

Alexey Tutubalin, 2014-11-21 08:07:15

I have a server on debian, websites are spinning on it and sometimes loading mysql loads the processor up to 160-180%, and for a long time. How can you optimize and what? What you can read on this topic is only what really helps, since soon the load will increase greatly, and there is still no way to transfer the database to a separate server.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

S

Sergey Petrikov, 2014-11-21
@Kennius

Are you looking for psychics here so that you can optimize your project without seeing it? Start with mysqltuner.pl - in basic situations it gives quite competent advice, if it doesn't help, connect the database administrator to the project analysis.

E

Eugene, 2014-12-08
@e-antonov

See what mysqltuner will show Read
a good article on tuning mysql habrahabr.ru/post/159085
Analyze slow queries and arrange indexes, if necessary

B

brutal_lobster, 2014-11-21
@brutal_lobster

Book
Links

E

Eugene, 2014-11-21
@Nc_Soft

Give more memory and put tmp_dir in RAM, it might help.