Re: How to enable index fast in MyISAM table
Posted by:
Rick James
Date: March 20, 2014 06:33PM
> I do have thousands of queries during busy hour.
So, only a few per second? MyISAM can usually handle hundreds, maybe thousands, of _simple_ queries per second.
MyISAM locks the entire table whenever a write happens. InnoDB does not.
> I do see table lock issue in the slow log and want to fix that.
That implies finding ways to speed up the slow queries.
> I tried adding date to it to prune partition. However, it is slower than no pruning. Hence I removed the "date=xx" criteria.
Strange. Could you show us the exact SELECTs you tried, together with EXPLAIN PARTITIONS SELECT... for each.
Subject
Views
Written By
Posted
4254
March 04, 2014 07:26PM
2309
March 08, 2014 12:42PM
2555
March 13, 2014 10:49PM
1996
March 14, 2014 06:32PM
1981
March 17, 2014 01:38AM
Re: How to enable index fast in MyISAM table
1907
March 20, 2014 06:33PM
2128
March 22, 2014 07:23PM
1881
March 23, 2014 02:36PM
1866
March 24, 2014 12:16AM
1931
March 24, 2014 10:49PM
1966
March 25, 2014 08:39PM
2157
March 26, 2014 11:55AM
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.