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.
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
1751
November 10, 2014 01:33AM
1536
November 13, 2014 10:28AM
1479
November 14, 2014 01:46AM
1538
November 15, 2014 12:48AM
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.