// Not sure whethe this is the right way to confirm rm -rf 77863 scripts/mysql_install_db --basedir=/export/umesh/server/source/mysql-5.6.26 --datadir=/export/umesh/server/source/mysql-5.6.26/77863 bin/mysqld --skip-grant-tables --skip-name-resolve --basedir=/export/umesh/server/source/mysql-5.6.26 --datadir=/export/umesh/server/source/mysql-5.6.26/77863 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/source/mysql-5.6.26/77863/log.err & [1] 30634 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26: gdb --pid=30634 GNU gdb (GDB) Red Hat Enterprise Linux 7.6.1-51.el7 Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: . Attaching to process 30634 Reading symbols from /export/umesh/server/source/mysql-5.6.26/bin/mysqld...done. Reading symbols from /lib64/libpthread.so.0...(no debugging symbols found)...done. [New LWP 30658] [New LWP 30655] [New LWP 30654] [New LWP 30653] [New LWP 30652] [New LWP 30651] [New LWP 30650] [New LWP 30649] [New LWP 30648] [New LWP 30647] [New LWP 30646] [New LWP 30644] [New LWP 30643] [New LWP 30642] [New LWP 30641] [New LWP 30640] [New LWP 30639] [New LWP 30638] [New LWP 30637] [New LWP 30636] [New LWP 30635] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Loaded symbols for /lib64/libpthread.so.0 Reading symbols from /lib64/libaio.so.1...Reading symbols from /lib64/libaio.so.1...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/libaio.so.1 Reading symbols from /lib64/libcrypt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libcrypt.so.1 Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libstdc++.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libstdc++.so.6 Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libm.so.6 Reading symbols from /lib64/libgcc_s.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libgcc_s.so.1 Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib64/libfreebl3.so...Reading symbols from /lib64/libfreebl3.so...(no debugging symbols found)...done. (no debugging symbols found)...done. Loaded symbols for /lib64/libfreebl3.so 0x00007f78e1c3bedd in poll () from /lib64/libc.so.6 Missing separate debuginfos, use: debuginfo-install glibc-2.17-55.0.4.el7_0.1.x86_64 libaio-0.3.109-12.el7.x86_64 libgcc-4.8.2-16.2.el7_0.x86_64 libstdc++-4.8.2-16.2.el7_0.x86_64 nss-softokn-freebl-3.16.2-1.el7_0.x86_64 (gdb) b table_events_statements.cc:721 Breakpoint 1 at 0xd3eee6: file /export/umesh/server/source/mysql-5.6.26/storage/perfschema/table_events_statements.cc, line 721. (gdb) c Continuing. [Switching to Thread 0x7f78b881a700 (LWP 30658)] Breakpoint 1, table_events_statements_current::make_row (this=0x7f7884015ff0, pfs_thread=0x7f78ce2d1b40, statement=0x7f78cd353838) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/table_events_statements.cc:721 721 digest.reset(m_token_array, MAX_DIGEST_STORAGE_SIZE); (gdb) b sql_digest.h:70 Breakpoint 2 at 0x7829f5: file /export/umesh/server/source/mysql-5.6.26/sql/sql_digest.h, line 70. (gdb) bt #0 table_events_statements_current::make_row (this=0x7f7884015ff0, pfs_thread=0x7f78ce2d1b40, statement=0x7f78cd353838) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/table_events_statements.cc:721 #1 0x0000000000d3ecf3 in table_events_statements_current::rnd_next (this=0x7f7884015ff0) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/table_events_statements.cc:668 #2 0x0000000000d24c40 in ha_perfschema::rnd_next (this=0x2c02040, buf=0x2c02430 "\377\377\377") at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/ha_perfschema.cc:332 #3 0x0000000000634e3b in handler::ha_rnd_next (this=0x2c02040, buf=0x2c02430 "\377\377\377") at /export/umesh/server/source/mysql-5.6.26/sql/handler.cc:2687 #4 0x000000000095d45a in rr_sequential (info=0x7f78840153a8) at /export/umesh/server/source/mysql-5.6.26/sql/records.cc:480 #5 0x0000000000795dc5 in join_init_read_record (tab=0x7f7884015318) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:2395 #6 0x0000000000793640 in sub_select (join=0x7f7884005468, join_tab=0x7f7884015318, end_of_records=false) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:1256 #7 0x0000000000793056 in do_select (join=0x7f7884005468) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:933 #8 0x0000000000791062 in JOIN::exec (this=0x7f7884005468) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:194 #9 0x00000000007ee4bc in mysql_execute_select (thd=0x24ae320, select_lex=0x24b07f0, free_join=true) at /export/umesh/server/source/mysql-5.6.26/sql/sql_select.cc:1100 #10 0x00000000007ee7a0 in mysql_select (thd=0x24ae320, tables=0x7f7884004e18, wild_num=1, fields=..., conds=0x0, order=0x24b09b8, group=0x24b08f0, having=0x0, select_options=2147748608, result=0x7f7884005440, unit=0x24b01a8, select_lex=0x24b07f0) at /export/umesh/server/source/mysql-5.6.26/sql/sql_select.cc:1221 #11 0x00000000007ec8ae in handle_select (thd=0x24ae320, result=0x7f7884005440, setup_tables_done_option=0) at /export/umesh/server/source/mysql-5.6.26/sql/sql_select.cc:110 #12 0x00000000007c7568 in execute_sqlcom_select (thd=0x24ae320, all_tables=0x7f7884004e18) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:5134 #13 0x00000000007c0433 in mysql_execute_command (thd=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:2656 #14 0x00000000007c9ffb in mysql_parse (thd=0x24ae320, rawbuf=0x7f7884004bc0 "SELECT * FROM events_statements_current", length=39, parser_state=0x7f78b8819010) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:6386 #15 0x00000000007bd4c7 in dispatch_command (command=COM_QUERY, thd=0x24ae320, packet=0x2c49331 "", packet_length=39) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:1340 #16 0x00000000007bc542 in do_command (thd=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:1037 #17 0x0000000000786257 in do_handle_one_connection (thd_arg=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_connect.cc:982 #18 0x0000000000785d57 in handle_one_connection (arg=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_connect.cc:898 #19 0x0000000000d54020 in pfs_spawn_thread (arg=0x2b0cce0) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/pfs.cc:1860 #20 0x00007f78e2d72df3 in start_thread () from /lib64/libpthread.so.0 #21 0x00007f78e1c4647d in clone () from /lib64/libc.so.6 (gdb) c Continuing. Breakpoint 2, sql_digest_storage::reset (this=0x7f78b8817720) at /export/umesh/server/source/mysql-5.6.26/sql/sql_digest.h:70 70 memset(m_token_array, 0, m_token_array_length); (gdb) bt #0 sql_digest_storage::reset (this=0x7f78b8817720) at /export/umesh/server/source/mysql-5.6.26/sql/sql_digest.h:70 #1 0x00000000007829bd in sql_digest_storage::reset (this=0x7f78b8817720, token_array=0x7f7884016941 '\217' ..., length=1048576) at /export/umesh/server/source/mysql-5.6.26/sql/sql_digest.h:60 #2 0x0000000000d3ef05 in table_events_statements_current::make_row (this=0x7f7884015ff0, pfs_thread=0x7f78ce2d1b40, statement=0x7f78cd353838) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/table_events_statements.cc:721 #3 0x0000000000d3ecf3 in table_events_statements_current::rnd_next (this=0x7f7884015ff0) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/table_events_statements.cc:668 #4 0x0000000000d24c40 in ha_perfschema::rnd_next (this=0x2c02040, buf=0x2c02430 "\377\377\377") at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/ha_perfschema.cc:332 #5 0x0000000000634e3b in handler::ha_rnd_next (this=0x2c02040, buf=0x2c02430 "\377\377\377") at /export/umesh/server/source/mysql-5.6.26/sql/handler.cc:2687 #6 0x000000000095d45a in rr_sequential (info=0x7f78840153a8) at /export/umesh/server/source/mysql-5.6.26/sql/records.cc:480 #7 0x0000000000795dc5 in join_init_read_record (tab=0x7f7884015318) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:2395 #8 0x0000000000793640 in sub_select (join=0x7f7884005468, join_tab=0x7f7884015318, end_of_records=false) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:1256 #9 0x0000000000793056 in do_select (join=0x7f7884005468) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:933 #10 0x0000000000791062 in JOIN::exec (this=0x7f7884005468) at /export/umesh/server/source/mysql-5.6.26/sql/sql_executor.cc:194 #11 0x00000000007ee4bc in mysql_execute_select (thd=0x24ae320, select_lex=0x24b07f0, free_join=true) at /export/umesh/server/source/mysql-5.6.26/sql/sql_select.cc:1100 #12 0x00000000007ee7a0 in mysql_select (thd=0x24ae320, tables=0x7f7884004e18, wild_num=1, fields=..., conds=0x0, order=0x24b09b8, group=0x24b08f0, having=0x0, select_options=2147748608, result=0x7f7884005440, unit=0x24b01a8, select_lex=0x24b07f0) at /export/umesh/server/source/mysql-5.6.26/sql/sql_select.cc:1221 #13 0x00000000007ec8ae in handle_select (thd=0x24ae320, result=0x7f7884005440, setup_tables_done_option=0) at /export/umesh/server/source/mysql-5.6.26/sql/sql_select.cc:110 #14 0x00000000007c7568 in execute_sqlcom_select (thd=0x24ae320, all_tables=0x7f7884004e18) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:5134 #15 0x00000000007c0433 in mysql_execute_command (thd=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:2656 #16 0x00000000007c9ffb in mysql_parse (thd=0x24ae320, rawbuf=0x7f7884004bc0 "SELECT * FROM events_statements_current", length=39, parser_state=0x7f78b8819010) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:6386 #17 0x00000000007bd4c7 in dispatch_command (command=COM_QUERY, thd=0x24ae320, packet=0x2c49331 "", packet_length=39) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:1340 #18 0x00000000007bc542 in do_command (thd=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_parse.cc:1037 #19 0x0000000000786257 in do_handle_one_connection (thd_arg=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_connect.cc:982 #20 0x0000000000785d57 in handle_one_connection (arg=0x24ae320) at /export/umesh/server/source/mysql-5.6.26/sql/sql_connect.cc:898 #21 0x0000000000d54020 in pfs_spawn_thread (arg=0x2b0cce0) at /export/umesh/server/source/mysql-5.6.26/storage/perfschema/pfs.cc:1860 #22 0x00007f78e2d72df3 in start_thread () from /lib64/libpthread.so.0 #23 0x00007f78e1c4647d in clone () from /lib64/libc.so.6 (gdb) f 1 #1 0x00000000007829bd in sql_digest_storage::reset (this=0x7f78b8817720, token_array=0x7f7884016941 '\217' ..., length=1048576) at /export/umesh/server/source/mysql-5.6.26/sql/sql_digest.h:60 60 reset(); (gdb) print m_token_array_length $1 = 1048576 (gdb) ####### CLI session [umshastr@hod03]/export/umesh/server/source/mysql-5.6.26: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.26-debug Source distribution Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> mysql> use performance_schema; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> use performance_schema; Database changed mysql> SELECT * FROM events_statements_current;