IDCFのRDBを簡単に試してみた

[root@rdb-test1 ~]# mysql -h qg-test.local.rdb.idcfcloud.net -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 46
Server version: 5.7.22-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, 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>

# mysqlslap \
>   --no-defaults \
>   --user=root \
>   --password \
>   --host=qg-test.local.rdb.idcfcloud.net \
>   --engine=innodb \
>   --auto-generate-sql \
>   --auto-generate-sql-load-type=read \
>   --auto-generate-sql-add-autoincrement \
>   --number-of-queries=100000 \
>   --concurrency=50 \
>   --iterations=10

mysql> SET GLOBAL max_connections = 257;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 257   |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> SET GLOBAL join_buffer_size = 512 * 1024;
Query OK, 0 rows affected (0.00 sec)

mysql> SET SESSION join_buffer_size = 512 * 1024;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'join_buffer_size';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| join_buffer_size | 524288 |
+------------------+--------+
1 row in set (0.01 sec)

mysql> SET GLOBAL sort_buffer_size = 1 * 1024 * 1024;
Query OK, 0 rows affected (0.00 sec)

mysql> SET SESSION sort_buffer_size = 1 * 1024 * 1024;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'sort_buffer_size';
+------------------+---------+
| Variable_name    | Value   |
+------------------+---------+
| sort_buffer_size | 1048576 |
+------------------+---------+
1 row in set (0.00 sec)

mysql> SET GLOBAL read_rnd_buffer_size = 512 * 1024;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'read_rnd_buffer_size';
+----------------------+--------+
| Variable_name        | Value  |
+----------------------+--------+
| read_rnd_buffer_size | 524288 |
+----------------------+--------+
1 row in set (0.00 sec)