MySQL Forums
Forum List  »  Performance

Re: Mysql tuning
Posted by: Rick James
Date: September 24, 2013 09:19PM

If the link (to my doc) that Peter gave you is not sufficient,...

> mysql responding quite slow.

Do you mean the network is slow? Or that some SELECTs run slowly?

How much RAM do you have? You have set several things excessively high. Perhaps you need them high; or perhaps they are leading to swapping.

You have the slowlog turned on. What are the 'worst' queries captured there?

> query_cache_size = 128M
Too high.

If you have slow queries, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
and surround them with [ code ] and [ / code ]

SHOW VARIABLES;
SHOW GLOBAL STATUS;

Options: ReplyQuote


Subject
Views
Written By
Posted
4113
September 23, 2013 01:13AM
1181
September 23, 2013 07:36PM
Re: Mysql tuning
1166
September 24, 2013 09:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.