Skip to content

Instantly share code, notes, and snippets.

Transparent huge pages are enabled, according to /sys/kernel/mm/redhat_transparent_hugepage/enabled
************************************************************
@@@@@@@@@@@
@@' '@@
@@ _ _ @@
| (.) (.) |
| ` |
| > ' |
| .----. |
$ ll -d /dev/shm
drwxrwxrwt 4 root root 180 6月 13 11:01 2014 /dev/shm
$ ./scripts/mysql_install_db --datadir=/dev/shm
Installing MySQL system tables...2014-06-13 11:01:44 0 [Warning] The syntax 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead.
$ ll /dev/shm
合計 510408
-rw-rw---- 1 you0825 you0825 0 6月 13 11:01 2014 bin.index
-rw-rw---- 1 you0825 you0825 2210 6月 13 11:01 2014 error.log
mysql56> SELECT @@version;
+------------+
| @@version |
+------------+
| 5.6.19-log |
+------------+
1 row in set (0.00 sec)
mysql56> SELECT @@sql_mode;
+------------+
@yoku0825
yoku0825 / bt
Created July 29, 2014 03:26
groonga-normalizer-mysql 1.0.6 crash
(gdb) bt
#0 grn_nfkc_char_type (str=0x7f7a87ffcba6 <Address 0x7f7a87ffcba6 out of bounds>) at nfkc.c:31
#1 0x00007f7a8e9e4943 in normalize () from /usr/groonga/4.0.2/lib/groonga/plugins/normalizers/mysql.so
#2 0x00007f7a8e9e50a0 in mysql_unicode_ci_except_kana_ci_kana_with_voiced_sound_mark_next ()
from /usr/groonga/4.0.2/lib/groonga/plugins/normalizers/mysql.so
#3 0x00007f7ad0e0f826 in grn_proc_call (ctx=0x7f7a8802fa68, proc=0x7f7a88346010, nargs=1, caller=<value optimized out>)
at expr.c:1808
#4 0x00007f7ad0f2c3fe in grn_normalizer_normalize (ctx=0x7f7a8802fa68, normalizer=0x7f7a88346010,
string=<value optimized out>) at normalizer.c:1168
#5 0x00007f7ad0f73cd3 in grn_string_open_ (ctx=0x7f7a8802fa68, str=0x7f7aa4150a88 "???'", str_len=<value optimized out>,
mysql56> SHOW CREATE TABLE t1\G
*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`num` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`val` varchar(32) DEFAULT NULL,
UNIQUE KEY `num` (`num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
1 row in set (0.00 sec)
@yoku0825
yoku0825 / grndump.patch
Created September 4, 2014 06:17
rroonga-4.0.4/bin/grndumpに--lock-all-tablesオプション追加
*** /usr/local/lib/ruby/gems/2.1.0/gems/rroonga-4.0.4/bin/grndump.orig 2014-09-02 17:43:14.239617704 +0900
--- /usr/local/lib/ruby/gems/2.1.0/gems/rroonga-4.0.4/bin/grndump.lock 2014-09-04 15:06:39.795523494 +0900
***************
*** 28,33 ****
--- 28,34 ----
options.dump_schema = true
options.dump_indexes = true
options.dump_tables = true
+ options.lock_tables = false
options.order_by = "id"
$ pwd
/home/yoku0825/mariadb-10.0.14
$ find -name "pcre.h*"
./pcre/pcre.h.in
./pcre/doc/html/pcre.html
$ cmake .
..
#!/usr/bin/perl
use strict;
use warnings;
use Encode qw/encode/;
use XML::Simple;
use Data::Dumper;
my $buffer;
my $init= 0;
$ mysqlfabric manage start
[INFO] 1416274019.555394 - MainThread - Initializing persister: user (fabric), server (127.0.0.1:5621), database (fabric).
[INFO] 1416274019.814032 - MainThread - Loading Services.
[INFO] 1416274019.825344 - MainThread - MySQL-RPC protocol server started, listening on localhost:32275
[INFO] 1416274019.835285 - MainThread - Fabric node starting.
[INFO] 1416274019.838146 - MainThread - Starting Executor.
[INFO] 1416274019.838242 - MainThread - Setting 5 executor(s).
[INFO] 1416274019.838700 - Executor-0 - Started.
[INFO] 1416274019.839441 - Executor-1 - Started.
[INFO] 1416274019.840022 - Executor-2 - Started.
mysql56> SET sql_mode= '';
Query OK, 0 rows affected (0.00 sec)
mysql56> INSERT INTO t1 VALUES ('2012-02-30');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql56> SHOW WARNINGS;
+---------+------+---------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------+