MySQL Forums
Forum List  »  InnoDB

Re: Mysql mysql hangs up 1-2 times per day
Posted by: Rick James
Date: November 08, 2014 09:57AM

I see that Galera is involved.

Please provide
* SHOW VARIABLES LIKE '%open%'; -- I'm worried that one of the caches is less than your "1000 partitions". (You can skip most of the fields and partitions; need to see the type of partitioning, all indexes, engine.)
* SHOW VARIABLES LIKE 'innodb%'; -- file_per_table is possibly relevent; plus others.
* EXPLAIN PARTITIONS SELECT ... -- and be sure to show the end of the SELECT (unlike the STATUS you provided); need to see JOINs, WHERE, etc. The EXPLAIN will say what pruning, if any, is being done.
* The DROP PARTITION statement -- (not expecting anything exciting here)
* Topology: How many nodes? How far apart are the nodes (millisecond latency between them if cross-country)? Any Slaves hanging off the nodes?
* Version

Until you get to 5.7, having a table with more than about 50 partitions is impractical an inefficient.

Options: ReplyQuote


Subject
Views
Written By
Posted
4503
November 07, 2014 07:01AM
Re: Mysql mysql hangs up 1-2 times per day
1757
November 08, 2014 09:57AM


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.