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

yoku0825

[root@ip-172-31-0-92 ~]# ll
total 58144
-rw-r--r-- 1 root root     4782 Mar 20 15:21 amazonConfig-1pm.xml
-rw-r--r-- 1 root root     4782 Mar 20 15:21 amazonConfig.xml
-rwxr-xr-x 1 root root   617853 Mar 20 15:21 amazonInstaller
-rw-r--r-- 1 root root  8973583 Mar 25 20:43 infinidb-libs-4.5.0-1.x86_64.rpm
-rw-r--r-- 1 root root 35544003 Mar 25 20:43 infinidb-mysql-4.5.0-1.x86_64.rpm
-rw-r--r-- 1 root root 13741723 Mar 25 20:43 infinidb-platform-4.5.0-1.x86_64.rpm
-rw-r--r-- 1 root root   626899 Mar 25 20:43 infinidb-storage-engine-4.5.0-1.x86_64.rpm
-rw-r--r-- 1 root root     4975 Mar 20 15:18 README

yoku0825

• SHOW ENGINE NDBの見方を知りたい(そもそも使う?)
• Point In Time Recoveryってやったことあれば感想(?)を聞きたい。
• InnoDBなmysqldと同じ or NOT..
• EXPLAINはMySQL Serverと同じくらい役に立つ？
• 60GBのデータベースを乗っけるのに、48GB(か64GB)のメモリーを積んだデータノードを2つ並べるのと32GB(か48GB)のデータノードを4つ並べるならどちらがよさげ？
• NDB memcached Engineに心惹かれるんですが実績とかあれば。
• CREATE TAMPORARY TABLE Engine= MyISAM AS SELECT .. って邪道ですか？

yoku0825

#!/bin/bash

PATH=/bin:/usr/bin:/usr/local/mysql/bin

which mysqlbinlog > /dev/null || exit 1
which mysql       > /dev/null || exit 1

while getopts h:u:p: OPT; do
  case "$OPT" in
    "h")     host="$OPTARG";;