This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Transparent huge pages are enabled, according to /sys/kernel/mm/redhat_transparent_hugepage/enabled | |
************************************************************ | |
@@@@@@@@@@@ | |
@@' '@@ | |
@@ _ _ @@ | |
| (.) (.) | | |
| ` | | |
| > ' | | |
| .----. | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
mysql56> SELECT @@version; | |
+------------+ | |
| @@version | | |
+------------+ | |
| 5.6.19-log | | |
+------------+ | |
1 row in set (0.00 sec) | |
mysql56> SELECT @@sql_mode; | |
+------------+ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
(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>, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
*** /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" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ pwd | |
/home/yoku0825/mariadb-10.0.14 | |
$ find -name "pcre.h*" | |
./pcre/pcre.h.in | |
./pcre/doc/html/pcre.html | |
$ cmake . | |
.. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/perl | |
use strict; | |
use warnings; | |
use Encode qw/encode/; | |
use XML::Simple; | |
use Data::Dumper; | |
my $buffer; | |
my $init= 0; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | | |
+---------+------+---------------------------------------------+ |