Re: mysql tables in use 500, locked 500
> mysql tables in use 500, locked 500
> #table schema,T_CALL_LAST_SYNC table is a partitioned table with 500 partitions.
> why all partitions clocked?
The answer is buried deep in the bowels of MySQL code. Maybe someday (5.6.6?) it will be fixed. Meanwhile, do not have so many PARTITIONs in one table. See my comments in
http://mysql.rjweb.org/doc.php/ricksrots#partitioning
If you would like to discuss your table further, please provide SHOW CREATE TABLE (but with only a few, not 500, partitions listed.)
Subject
Views
Written By
Posted
3012
July 16, 2013 03:14AM
Re: mysql tables in use 500, locked 500
1666
July 21, 2013 12:26AM
1533
July 24, 2013 07:12AM
1399
August 13, 2013 05:42AM
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.