Performance drops when concurrent select by secondary key with 16 sessions on 16 CPU
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona patches |
Fix Released
|
Medium
|
Unassigned | ||
Percona-XtraDB |
Fix Released
|
High
|
Unassigned |
Bug Description
The chart: https:/
SELECT name FROM sbtest WHERE country_id = ? and state_id between ? and ?
CREATE TABLE IF NOT EXISTS sbtest (
)
db_query("CREATE INDEX email_idx on sbtest(email)")
db_query("CREATE INDEX country_id_idx on sbtest(
Mutex:
<Vadim> --Thread 1094527296 has waited at buf/buf0buf.c line 1911 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 0
<Vadim> waiters flag 0
<Vadim> wait has ended
<Vadim> --Thread 1195309376 has waited at btr/btr0sea.c line 818 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 0
<Vadim> waiters flag 0
<Vadim> --Thread 1192700224 has waited at buf/buf0buf.c line 1911 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 0
<Vadim> waiters flag 0
<Vadim> --Thread 1188886848 has waited at buf/buf0buf.c line 1911 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 0
<Vadim> waiters flag 0
<Vadim> --Thread 1200126272 has waited at btr/btr0sea.c line 818 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 0
<Vadim> waiters flag 0
<Vadim> --Thread 1196714304 has waited at buf/buf0buf.c line 1911 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 0
<Vadim> waiters flag 0
<Vadim> --Thread 1197717824 has waited at buf/buf0buf.c line 1911 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 1
<Vadim> waiters flag 1
<Vadim> --Thread 1191295296 has waited at btr/btr0sea.c line 818 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 1
<Vadim> waiters flag 1
<Vadim> --Thread 1188284736 has waited at btr/btr0sea.c line 818 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 1
<Vadim> waiters flag 1
<Vadim> --Thread 1192900928 has waited at btr/btr0sea.c line 818 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 1
<Vadim> waiters flag 1
<Vadim> --Thread 1082542400 has waited at buf/buf0buf.c line 1911 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 1
<Vadim> waiters flag 1
<Vadim> --Thread 1084750144 has waited at buf/buf0buf.c line 1911 for 0.00 seconds the semaphore:
<Vadim> Mutex at 0xc346a0 created file buf/buf0buf.c line 940, lock var 1
Path:
<Vadim> #0 0x00000037a42099d5 in __pthread_
<Vadim> #1 0x00000000007bb156 in mutex_spin_wait ()
<Vadim> #2 0x0000000000726222 in buf_page_get_gen ()
<Vadim> #3 0x000000000070fe3f in btr_cur_
<Vadim> #4 0x00000000007a9e79 in row_search_
<Vadim> #5 0x0000000000701329 in ha_innobase:
<Vadim> #6 0x0000000000674ba1 in handler:
<Vadim> #7 0x0000000000671979 in handler:
<Vadim> #8 0x000000000065afd2 in QUICK_RANGE_
<Vadim> #9 0x000000000066e60d in rr_quick ()
<Vadim> #10 0x00000000005f6146 in sub_select ()
<Vadim> #11 0x00000000005f6bdd in do_select ()
<Vadim> #12 0x0000000000607058 in JOIN::exec ()
<Vadim> #13 0x0000000000608c48 in mysql_select ()
<Vadim> #14 0x0000000000609579 in handle_select ()
<Vadim> #15 0x00000000005927bc in execute_
<Vadim> #16 0x0000000000597ad7 in mysql_execute_
<Vadim> #17 0x0000000000614188 in Prepared_
<Vadim> #18 0x00000000006166b0 in Prepared_
<Vadim> #19 0x000000000061738d in mysql_stmt_execute ()
<Vadim> #20 0x000000000059ed51 in dispatch_command ()
<Vadim> #21 0x000000000059f334 in do_command ()
<Vadim> #22 0x000000000058ffd7 in handle_
<Vadim> #23 0x00000037a42062f7 in start_thread () from /lib64/
<Vadim> #24 0x00000037a3ad1e3d in clone () from /lib64/libc.so.6
<Vadim> Yasufumi: and Thread 9 (Thread 1187080512 (LWP 633)):
<Vadim> #0 0x00000037a420c888 in __lll_mutex_
<Vadim> #1 0x00000037a4208911 in _L_mutex_lock_1133 () from /lib64/
<Vadim> #2 0x00000037a420886a in pthread_mutex_lock () from /lib64/
<Vadim> #3 0x000000000077988d in os_mutex_enter ()
<Vadim> #4 0x00000000007b9548 in sync_array_
<Vadim> ---Type <return> to continue, or q <return> to quit---
<Vadim> #5 0x00000000007bb0e0 in mutex_spin_wait ()
<Vadim> #6 0x0000000000726222 in buf_page_get_gen ()
<Vadim> #7 0x000000000070fe3f in btr_cur_
<Vadim> #8 0x000000000071091a in btr_estimate_
<Vadim> #9 0x00000000007045d7 in ha_innobase:
<Vadim> #10 0x000000000065f513 in check_quick_keys ()
<Vadim> #11 0x000000000065fc45 in check_quick_keys ()
<Vadim> #12 0x000000000065fe20 in check_quick_select ()
<Vadim> #13 0x00000000006600be in get_key_
<Vadim> #14 0x000000000066951b in SQL_SELECT:
<Vadim> #15 0x00000000005fed76 in make_join_
<Vadim> #16 0x00000000005ff8e6 in JOIN::optimize ()
<Vadim> #17 0x0000000000608b5b in mysql_select ()
<Vadim> #18 0x0000000000609579 in handle_select ()
<Vadim> #19 0x00000000005927bc in execute_
<Vadim> #20 0x0000000000597ad7 in mysql_execute_
<Vadim> #21 0x0000000000614188 in Prepared_
<Vadim> #22 0x00000000006166b0 in Prepared_
<Vadim> #23 0x000000000061738d in mysql_stmt_execute ()
<Vadim> #24 0x000000000059ed51 in dispatch_command ()
<Vadim> #25 0x000000000059f334 in do_command ()
<Vadim> #26 0x000000000058ffd7 in handle_
<Vadim> #27 0x00000037a42062f7 in start_thread () from /lib64/
<Vadim> #28 0x00000037a3ad1e3d in clone () from /lib64/libc.so.6
Related branches
Changed in percona-xtradb: | |
assignee: | nobody → yasufumi-kinoshita |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in percona-xtradb: | |
importance: | Medium → High |
Changed in percona-xtradb: | |
status: | Confirmed → Fix Committed |
Changed in percona-xtradb: | |
status: | Fix Committed → Fix Released |
Changed in percona-patches: | |
assignee: | nobody → yasufumi-kinoshita |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in percona-patches: | |
status: | Confirmed → Fix Committed |
Changed in percona-patches: | |
status: | Fix Committed → Fix Released |
Consider porting fix for the percona patches