November 4, 2014

MySQL table cache的分区方式

今天在跑高压力高并发下只读查询时,发现个比较有意思的小问题 先来看看performance schema root@performance_schema 03:13:45>SELECT COUNT_STAR, SUM_TIMER_WAIT, AVG_TIMER_WAIT, EVENT_NAME FROM events_waits_summary_global_by_event_name where COUNT_STAR > 0 and EVENT_NAME like ‘wait/synch/%’ order by SUM_TIMER_WAIT desc limit 20; +————-+——————+—————-+—————————————————+ | COUNT_STAR | SUM_TIMER_WAIT | AVG_TIMER_WAIT | EVENT_NAME | +————-+——————+—————-+—————————————————+ | 794349716 | 9217250429384944 | 11603268 | wait/synch/mutex/sql/LOCK_table_cache | | 395819330 | 8052052171747844 | 20342452 | wait/synch/rwlock/sql/LOCK_grant | | […]