Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created January 11, 2023 00:07
Embed
What would you like to do?
#0 __libc_pread64 (fd=fd@entry=73, buf=buf@entry=0x7f7f09044000, count=count@entry=16384, offset=offset@entry=41667002368) at ../sysdeps/unix/sysv/linux/pread64.c:24
#1 0x00005593a8661f69 in pread64 (__offset=41667002368, __nbytes=16384, __buf=0x7f7f09044000, __fd=73) at /usr/include/x86_64-linux-gnu/bits/unistd.h:82
#2 os_file_pread (offset=41667002368, n=16384, buf=0x7f7f09044000, file=73) at /home/mdcallag/b/mysql-5.6.51/storage/innobase/os/os0file.cc:2406
#3 os_file_read_func (file=73, buf=0x7f7f09044000, offset=41667002368, n=16384) at /home/mdcallag/b/mysql-5.6.51/storage/innobase/os/os0file.cc:2666
#4 0x00005593a8747120 in fil_io (type=type@entry=10, sync=<optimized out>, space_id=space_id@entry=6, zip_size=zip_size@entry=0, block_offset=block_offset@entry=2543152,
byte_offset=byte_offset@entry=0, len=<optimized out>, buf=<optimized out>, message=<optimized out>) at /home/mdcallag/b/mysql-5.6.51/storage/innobase/fil/fil0fil.cc:5771
#5 0x00005593a8717770 in buf_read_page_low (err=0x7f8115e91704, sync=<optimized out>, mode=132, space=6, zip_size=<optimized out>, unzip=<optimized out>, tablespace_version=8,
offset=2543152) at /home/mdcallag/b/mysql-5.6.51/storage/innobase/buf/buf0rea.cc:199
#6 0x00005593a871805d in buf_read_page (space=space@entry=6, zip_size=zip_size@entry=0, offset=offset@entry=2543152)
at /home/mdcallag/b/mysql-5.6.51/storage/innobase/buf/buf0rea.cc:417
#7 0x00005593a87076ff in buf_page_get_gen (space=6, zip_size=zip_size@entry=0, offset=offset@entry=2543152, rw_latch=rw_latch@entry=1, guess=<optimized out>, guess@entry=0x0,
mode=mode@entry=16, file=<optimized out>, line=<optimized out>, mtr=<optimized out>) at /home/mdcallag/b/mysql-5.6.51/storage/innobase/buf/buf0buf.cc:2720
#8 0x00005593a86f8e67 in btr_estimate_n_rows_in_range_on_level (is_n_rows_exact=<synthetic pointer>, n_rows_on_prev_level=<optimized out>, slot2=<optimized out>,
slot1=<optimized out>, index=<optimized out>) at /home/mdcallag/b/mysql-5.6.51/storage/innobase/btr/btr0cur.cc:3598
#9 btr_estimate_n_rows_in_range (index=index@entry=0x7f7e33c43e68, tuple1=<optimized out>, mode1=<optimized out>, tuple2=tuple2@entry=0x7f7e33c9e560, mode2=<optimized out>)
at /home/mdcallag/b/mysql-5.6.51/storage/innobase/btr/btr0cur.cc:3829
#10 0x00005593a8620c61 in ha_innobase::records_in_range (this=0x7f7e73517010, keynr=<optimized out>, min_key=0x7f8115e961a0, max_key=0x0)
at /home/mdcallag/b/mysql-5.6.51/storage/innobase/handler/ha_innodb.cc:10718
#11 0x00005593a8298f21 in handler::multi_range_read_info_const (this=0x7f7e73517010, keyno=keyno@entry=1, seq=0x7f8115e962f0, seq_init_param=<optimized out>,
n_ranges_arg=<optimized out>, bufsz=bufsz@entry=0x7f8115e96264, flags=0x7f8115e96260, cost=0x7f8115e966e0) at /home/mdcallag/b/mysql-5.6.51/sql/handler.cc:5699
#12 0x00005593a82a0672 in DsMrr_impl::dsmrr_info_const (this=0x7f7e73517298, keyno=1, seq=<optimized out>, seq_init_param=<optimized out>, n_ranges=<optimized out>,
bufsz=0x7f8115e9667c, flags=0x7f8115e96678, cost=0x7f8115e966e0) at /home/mdcallag/b/mysql-5.6.51/sql/handler.cc:6342
#13 0x00005593a84f7157 in check_quick_select (param=param@entry=0x7f8115e96a10, idx=idx@entry=0, index_only=index_only@entry=true, tree=<optimized out>,
update_tbl_stats=update_tbl_stats@entry=true, mrr_flags=mrr_flags@entry=0x7f8115e96678, bufsize=0x7f8115e9667c, cost=0x7f8115e966e0)
at /home/mdcallag/b/mysql-5.6.51/sql/opt_range.cc:9531
#14 0x00005593a84f776f in get_key_scans_params (param=0x7f8115e96a10, tree=0x7f7e33c04198, index_read_must_be_used=false, update_tbl_stats=true, read_time=102655693.66237818)
at /home/mdcallag/b/mysql-5.6.51/sql/opt_range.cc:5625
#15 0x00005593a85063dd in SQL_SELECT::test_quick_select (this=this@entry=0x7f7e33d040a0, thd=thd@entry=0x7f7e73a20000, keys_to_use=..., prev_tables=prev_tables@entry=0,
limit=limit@entry=18446744073709551615, force_quick_range=force_quick_range@entry=false, interesting_order=st_order::ORDER_NOT_RELEVANT)
at /home/mdcallag/b/mysql-5.6.51/sql/opt_range.cc:2918
#16 0x00005593a854df8d in get_quick_record_count (limit=<optimized out>, keys=0x7f7e33c0f970, table=0x7f7e33437000, select=0x7f7e33d040a0, thd=0x7f7e73a20000)
at /home/mdcallag/b/mysql-5.6.51/sql/sql_optimizer.cc:3994
#17 make_join_statistics (join=<optimized out>, tables_arg=<optimized out>, conds=<optimized out>, keyuse_array=<optimized out>, first_optimization=<optimized out>)
at /home/mdcallag/b/mysql-5.6.51/sql/sql_optimizer.cc:3709
#18 0x00005593a854f6a4 in JOIN::optimize (this=this@entry=0x7f7e33c0f100) at /home/mdcallag/b/mysql-5.6.51/sql/sql_optimizer.cc:373
#19 0x00005593a840008e in mysql_execute_select (free_join=true, select_lex=0x7f7e73a22308, thd=0x7f7e73a20000) at /home/mdcallag/b/mysql-5.6.51/sql/sql_select.cc:1094
#20 mysql_select (thd=0x7f7e73a20000, tables=0x7f7e33c0e468, wild_num=0, fields=..., conds=0x7f7e33c0ebd8, order=<optimized out>, group=<optimized out>, having=0x0,
select_options=2147748608, result=0x7f7e33c0f0d8, unit=0x7f7e73a21cc0, select_lex=0x7f7e73a22308) at /home/mdcallag/b/mysql-5.6.51/sql/sql_select.cc:1229
#21 0x00005593a84008f7 in handle_select (thd=thd@entry=0x7f7e73a20000, result=result@entry=0x7f7e33c0f0d8, setup_tables_done_option=setup_tables_done_option@entry=0)
at /home/mdcallag/b/mysql-5.6.51/sql/sql_select.cc:108
#22 0x00005593a83d853d in execute_sqlcom_select (thd=0x7f7e73a20000, all_tables=0x7f7e33c0e468) at /home/mdcallag/b/mysql-5.6.51/sql/sql_parse.cc:5162
#23 0x00005593a83e2f40 in mysql_execute_command (thd=0x7f7e73a20000) at /home/mdcallag/b/mysql-5.6.51/sql/sql_parse.cc:2717
#24 0x00005593a83e45c8 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x7f7e73a20000)
at /home/mdcallag/b/mysql-5.6.51/sql/sql_parse.cc:6538
#25 mysql_parse (thd=0x7f7e73a20000, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /home/mdcallag/b/mysql-5.6.51/sql/sql_parse.cc:6402
#26 0x00005593a83e5d70 in dispatch_command (command=<optimized out>, thd=0x7f7e73a20000, packet=<optimized out>, packet_length=129)
at /home/mdcallag/b/mysql-5.6.51/sql/sql_class.h:193
#27 0x00005593a83b1326 in do_handle_one_connection (thd_arg=<optimized out>) at /home/mdcallag/b/mysql-5.6.51/sql/sql_connect.cc:989
#28 0x00005593a83b146d in handle_one_connection (arg=<optimized out>) at /home/mdcallag/b/mysql-5.6.51/sql/sql_connect.cc:906
#29 0x00007f8115faab43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#30 0x00007f811603ca00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment