MySQL Forums
Forum List  »  Performance

Re: MySQL 5.5.31 cripplingly slow
Posted by: Rick James
Date: January 17, 2014 02:03PM

> I take it they're referring to the free RAM as listed by 'free' or 'top'?

Yeah, it is hard to really figure out how much RAM is available. "top" lists free memory and swapping. Swapping is a serious no-no. If you are not swapping and mysqld is running and there is still some "free" space, than think of that as how much you can increase key_buffer_pool and/or innodb_buffer_pool_size.

> The link that Peter gave me says to use 20% for *just* MyISAM and 70% for *just* InnoDB, but I use both as the situation dictates.

The link goes on to say "If you have a mixture of engines, lower both numbers." OK, that doesn't help enough.

I augmented that link for your case: http://mysql.rjweb.org/doc.php/memory#another_algorithm

> I haven't created any tables since the upgrade, so I'm assuming that the switch to the default of InnoDB

Correct. Ditto for innodb_file_per_table.

> I also enabled it for queries that don't use indexes

I find that setting virtually useless; turn it off so you can find the real problems.

> long_query_time ... changed it to 1

Good.

When you spot the naughty queries in the slowlog, let's see a couple of them, together with
SHOW CREATE TABLE
SHOW TABLE STATUS
EXPLAIN SELECT...

Options: ReplyQuote


Subject
Views
Written By
Posted
2676
January 15, 2014 07:16AM
1123
January 15, 2014 11:44AM
1185
January 15, 2014 02:12PM
3438
January 17, 2014 05:52AM
1450
January 17, 2014 07:56AM
1215
January 17, 2014 11:23AM
1247
January 17, 2014 11:29AM
Re: MySQL 5.5.31 cripplingly slow
1315
January 17, 2014 02:03PM
1092
January 17, 2014 02:43PM
1241
January 17, 2014 05:13PM
1485
January 18, 2014 09:53AM
1164
January 18, 2014 04:00PM
1141
January 18, 2014 08:55PM


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.