yoku0825

(gdb) bt full
#0  mrn_set_geometry (this=<value optimized out>, field=<value optimized out>, buf=0x7f945c8356c0) at ha_mroonga.cpp:1187
        error = 0
        buffer = {
          <my_aligned_storage<24ul, 8ul>> = {
            {
              data = "3\000\000\000\002\000\000\000\b\b\001H\224\177\000\000\360U\203\\\224\177\000",
              align = {<No data fields>}
            }
          }, <No data fields>}

yoku0825

make[2]: ディレクトリ `/home/yoku0825/git/mroonga/udf' に入ります
depbase=`echo mrn_udf_snippet.lo | sed 's|[^/]*$|.deps/&|;s|\.lo$||'`;\
        /bin/sh ../libtool --tag=CXX   --mode=compile g++ -DHAVE_CONFIG_H -I. -I..  -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/sql -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/regex -I/home/yoku0825/mysql-5.6.15 -I/usr/mysql/5.6.15/include -I/usr/groonga/3.1.2.2014.01.30/include/groonga   -I.. -I../lib   -g -O2 -Wall -Wextra -Wno-unused-parameter -Wno-strict-aliasing -Wno-deprecated -fno-implicit-templates -fno-exceptions -fno-rtti -felide-constructors -MT mrn_udf_snippet.lo -MD -MP -MF $depbase.Tpo -c -o mrn_udf_snippet.lo mrn_udf_snippet.cpp &&\
        mv -f $depbase.Tpo $depbase.Plo
libtool: compile:  g++ -DHAVE_CONFIG_H -I. -I.. -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/sql -I/home/yoku0825/mysql-5.6.15/include -I/home/yoku0825/mysql-5.6.15/regex -I/home/yoku0825/mysql-5.6.15 -I/usr/mysql/5.6.15/include -I/

yoku0825

mysql> DROP DATABASE IF EXISTS mroonga;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE DATABASE mroonga;
Query OK, 1 row affected (0.00 sec)

mysql> use mroonga;
Database changed

mysql> CREATE TABLE mroonga.norm_auto (num int unsigned not null, val varchar(32) not null, PRIMARY KEY(num), FULLTEXT KEY(val) Comment 'normalizer "NormalizerAuto"') Engine= mroonga;

yoku0825

mysql> DROP DATABASE IF EXISTS mroonga;
Query OK, 1 row affected (0.05 sec)

mysql> CREATE DATABASE mroonga;
Query OK, 1 row affected (0.00 sec)

mysql> use mroonga;
Database changed

mysql> CREATE TABLE t1 (num serial, c1 text, c2 text, c3 text, c4 text, c5 text, c6 text, c7 text, c8 text, c9 text, c10 text, FULLTEXT KEY(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10)) Engine= mroonga;

yoku0825

Flat profile:

Each sample counts as 0.01 seconds.
  %   cumulative   self              self     total           
 time   seconds   seconds    calls   s/call   s/call  name    
  9.71      2.64     2.64      974     0.00     0.01  filesort(THD*, TABLE*, Filesort*, bool, unsigned long long*, unsigned long long*)
  9.29      5.17     2.53   809119     0.00     0.00  _downheap
  6.53      6.94     1.78   999935     0.00     0.00  Item_cond_and::val_int()
  3.53      7.90     0.96  3461537     0.00     0.00  Item::val_bool()
  3.53      8.86     0.96  1278293     0.00     0.00  my_datetime_round(st_mysql_time*, unsigned int, int*)

yoku0825

-- 1st_connection

mysql> pager cat >/dev/null
PAGER set to 'cat >/dev/null'

mysql> SELECT * FROM myisam INNER JOIN mroonga USING(val);

-- 2nd_connection
mysql> DELETE FROM mroonga;
Query OK, 10000 rows affected (0.04 sec)

yoku0825

*** plugins/node.d/mysql_.in.orig       2013-12-07 19:55:16.000000000 +0900
--- plugins/node.d/mysql_.in    2014-03-06 13:11:03.384820077 +0900
***************
*** 1082,1087 ****
--- 1082,1088 ----
        'SEMAPHORES'               => \&parse_semaphores,
        'TRANSACTIONS'             => \&parse_transactions,
        'BACKGROUND THREAD'        => \&skip,
+         'INDIVIDUAL BUFFER POOL INFO' => \&skip,
      );

yoku0825

*** client/mysql.cc.orig        2014-01-15 00:38:00.000000000 +0900
--- client/mysql.cc     2014-03-17 12:03:41.322812350 +0900
***************
*** 374,379 ****
--- 374,380 ----
    { "set option",       0, 0, 0, ""},
    { "lock tables",      0, 0, 0, ""},
    { "unlock tables",    0, 0, 0, ""},
+   { "flush privileges", 0, 0, 0, ""},
    /* generated 2006-12-28.  Refresh occasionally from lexer. */

yoku0825

$ perl -e 'use Digest::MD5 qw(md5_hex); for ($n= 1; $n<= 3000000; $n++) {printf("%d\t%s\n", $n, md5_he
x($n));}' > /tmp/test.tsv

mysql> CREATE DATABASE mroonga;
Query OK, 1 row affected (0.02 sec)

mysql> CREATE TABLE mroonga.t1 (num int unsigned not null, val varchar(32) not null, KEY(num, val)) Engine= Mroonga;
Query OK, 0 rows affected (0.09 sec)

mysql> LOAD DATA INFILE '/tmp/test.tsv' INTO TABLE mroonga.t1;

yoku0825

(gdb) bt
#0  0x0000003eb480c69c in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000654562 in handle_fatal_signal (sig=11) at /home/yoku0825/mysql-5.6.17/sql/signal_handler.cc:248
#2  <signal handler called>
#3  mrn_set_bitmap_by_key (map=0x7f82c834d860, key_info=0x1c00) at mrn_table.cpp:1062
#4  0x00007f82d368166f in ha_mroonga::storage_inplace_alter_table (this=0x7f82c8369840, altered_table=0x7f82c8367aa0,
    ha_alter_info=<value optimized out>) at ha_mroonga.cpp:13240
#5  0x000000000072bafd in ha_inplace_alter_table (thd=0x23d5b60, table_list=0x7f82c8005070, table=0x7f82c8368f50,
    altered_table=0x7f82c8367aa0, ha_alter_info=0x7f82dccccfb0, inplace_supported=HA_ALTER_INPLACE_EXCLUSIVE_LOCK,
    target_mdl_request=0x7f82dcccdcd0, alter_ctx=0x7f82dcccbfa0) at /home/yoku0825/mysql-5.6.17/sql/handler.h:2868