質問編集履歴
3
MySQLのバージョンを5.7に変更することにしました。
title
CHANGED
@@ -1,1 +1,1 @@
|
|
1
|
-
CircleCI
|
1
|
+
CircleCI/MySQLに任意create databaseされない!?
|
body
CHANGED
@@ -11,7 +11,7 @@
|
|
11
11
|
|:--|:--:|
|
12
12
|
|Java ver| Java 8|
|
13
13
|
|FW|Spring Boot 2.1.6|
|
14
|
-
|DB|MySQL
|
14
|
+
|DB|MySQL 5.7|
|
15
15
|
|DB ドライバ | JDBC |
|
16
16
|
|マイグレーションツール|Flyway|
|
17
17
|
|ライブラリツール|maven 3.6.1 |
|
@@ -79,92 +79,35 @@
|
|
79
79
|
key: v1-dependencies-{{ checksum "pom.xml" }}
|
80
80
|
|
81
81
|
- run:
|
82
|
-
name: Migrate DB
|
83
|
-
command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
|
84
|
-
|
85
|
-
- run:
|
86
82
|
name: Show Database
|
87
83
|
command: |
|
88
84
|
sudo apt-get install default-mysql-client
|
89
85
|
mysql -h 127.0.0.1 -u root -e 'show databases;'
|
90
86
|
|
87
|
+
- run:
|
88
|
+
name: Migrate DB
|
89
|
+
command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
|
90
|
+
|
91
91
|
# run tests!
|
92
92
|
- run: mvn integration-test
|
93
93
|
```
|
94
94
|
|
95
|
-
##
|
95
|
+
## 課題
|
96
|
-
|
96
|
+
`Show Database`のステップでデータベース一覧を表示したところ、
|
97
|
-
ログを見る限りだとMySQLコンテナにデータベースを発見できないor使用できない状況のようです。
|
98
97
|
```
|
99
|
-
[INFO]
|
100
|
-
[INFO] ----------------------< com.uruk:chicago-spring >-----------------------
|
101
|
-
[INFO] Building chicago-spring 0.0.1-SNAPSHOT
|
102
|
-
[INFO] --------------------------------[ jar ]---------------------------------
|
103
|
-
[INFO]
|
104
|
-
[INFO] --- flyway-maven-plugin:5.2.4:migrate (default-cli) @ chicago-spring ---
|
105
|
-
[INFO] Flyway Community Edition 5.2.4 by Boxfuse
|
106
|
-
[INFO] ------------------------------------------------------------------------
|
107
|
-
|
98
|
+
+--------------------+
|
108
|
-
[INFO] ------------------------------------------------------------------------
|
109
|
-
|
99
|
+
| Database |
|
110
|
-
[INFO] Finished at: 2019-07-24T13:53:04Z
|
111
|
-
[INFO] ------------------------------------------------------------------------
|
112
|
-
[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:5.2.4:migrate (default-cli) on project chicago-spring: org.flywaydb.core.internal.exception.FlywaySqlException:
|
113
|
-
[ERROR] Unable to obtain connection from database (jdbc:mysql://127.0.0.1:3306/chicago) for user 'root': Unknown database 'chicago'
|
114
|
-
[ERROR] ---------------------------------------------------------------------------------------------------------------------------
|
115
|
-
|
100
|
+
+--------------------+
|
116
|
-
|
101
|
+
| information_schema |
|
117
|
-
[ERROR] Message : Unknown database 'chicago'
|
118
|
-
[ERROR]
|
119
|
-
[ERROR] -> [Help 1]
|
120
|
-
[ERROR]
|
121
|
-
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
|
122
|
-
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
|
123
|
-
[ERROR]
|
124
|
-
[ERROR] For more information about the errors and possible solutions, please read the following articles:
|
125
|
-
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
|
126
|
-
|
102
|
+
| circle_test |
|
103
|
+
| mysql |
|
104
|
+
| performance_schema |
|
105
|
+
| sys |
|
106
|
+
+--------------------+
|
127
107
|
```
|
108
|
+
と表示されました。
|
109
|
+
想定ではこの中に`config.yml`で指定した`chicago`というデータベースが存在するはずですが、存在しません。
|
110
|
+
どのように設定すれば`chicago`を生成できるでしょうか?
|
128
111
|
|
129
|
-
また、エラーなのかわからないのですがContainer circleci/mysql:8.0-ramのステップは以下のログを出力して灰色になっています。
|
130
|
-
|
131
|
-
```Initializing database
|
132
|
-
2019-07-24T13:52:52.757914Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
|
133
|
-
2019-07-24T13:52:52.758005Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 40
|
134
|
-
2019-07-24T13:52:52.759501Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
135
|
-
2019-07-24T13:52:52.759519Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
136
|
-
2019-07-24T13:52:54.250203Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
|
137
|
-
2019-07-24T13:52:54.882324Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
|
138
|
-
Database initialized
|
139
|
-
MySQL init process in progress...
|
140
|
-
2019-07-24T13:52:55.462248Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
|
141
|
-
2019-07-24T13:52:55.462338Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 161
|
142
|
-
2019-07-24T13:52:55.464725Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
143
|
-
2019-07-24T13:52:55.464745Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
144
|
-
2019-07-24T13:52:55.841740Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
|
145
|
-
2019-07-24T13:52:55.849451Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
|
146
|
-
2019-07-24T13:52:55.867016Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
|
147
|
-
2019-07-24T13:52:55.949226Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
|
148
|
-
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
|
149
|
-
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
|
150
|
-
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
|
151
|
-
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
|
152
|
-
|
153
|
-
2019-07-24T13:52:58.710605Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
|
154
|
-
|
155
|
-
MySQL init process done. Ready for start up.
|
156
|
-
|
157
|
-
2019-07-24T13:52:59.054386Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
|
158
|
-
2019-07-24T13:52:59.054501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 7
|
159
|
-
2019-07-24T13:52:59.057659Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
160
|
-
2019-07-24T13:52:59.057686Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
161
|
-
2019-07-24T13:52:59.441213Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
|
162
|
-
2019-07-24T13:52:59.446079Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
|
163
|
-
2019-07-24T13:52:59.465685Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
|
164
|
-
2019-07-24T13:52:59.557754Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
|
165
|
-
|
166
|
-
Job was canceled
|
167
|
-
```
|
168
|
-
|
169
112
|
うまくお伝えできたか不安ですが、ご教示をお願いします。
|
170
113
|
不足等あれば何なりとお申し付けください。
|
2
より正確な情報へ修正しました。
title
CHANGED
File without changes
|
body
CHANGED
@@ -19,27 +19,30 @@
|
|
19
19
|
また、CIでのMySQLの設定は以下の通りにしたいと思っています。
|
20
20
|
|||
|
21
21
|
|:--|:--:|
|
22
|
-
|DB名|
|
22
|
+
|DB名|chicago|
|
23
23
|
|ユーザー名|user|
|
24
24
|
|パスワード|password|
|
25
25
|
|URL|127.0.0.1|
|
26
26
|
|
27
27
|
## CircleCIの設定ファイル
|
28
28
|
```yml
|
29
|
+
# Java Maven CircleCI 2.0 configuration file
|
30
|
+
#
|
31
|
+
# Check https://circleci.com/docs/2.0/language-java/ for more details
|
32
|
+
#
|
29
33
|
version: 2
|
30
34
|
jobs:
|
31
35
|
build:
|
32
36
|
docker:
|
33
37
|
# specify the version you desire here
|
34
38
|
- image: circleci/openjdk:8-jdk
|
35
|
-
# CI用の環境設定
|
36
39
|
environment:
|
37
|
-
MYSQL_HOST: 127.0.0.1
|
40
|
+
MYSQL_HOST: jdbc:mysql://127.0.0.1:3306
|
38
41
|
MYSQL_ROOT_PASSWORD: password
|
39
42
|
MYSQL_ALLOW_EMPTY_PASSWORD: true
|
40
|
-
MYSQL_DATABASE:
|
43
|
+
MYSQL_DATABASE: chicago
|
41
|
-
MYSQL_USER:
|
44
|
+
MYSQL_USER: root
|
42
|
-
MYSQL_PASSWORD:
|
45
|
+
MYSQL_PASSWORD:
|
43
46
|
|
44
47
|
- image: circleci/mysql:8.0-ram
|
45
48
|
|
@@ -70,81 +73,95 @@
|
|
70
73
|
name: Wait for DB
|
71
74
|
command: dockerize -wait tcp://127.0.0.1:3306 -timeout 120s
|
72
75
|
|
73
|
-
# Flywayでマイグレーションを実施
|
74
|
-
- run:
|
75
|
-
name: Migrate DB
|
76
|
-
command: mvn flyway:migrate -Dflyway.url=127.0.0.1:3306 -Dflyway.user=user -Dflyway.password=password
|
77
|
-
|
78
76
|
- save_cache:
|
79
77
|
paths:
|
80
78
|
- ~/.m2
|
81
79
|
key: v1-dependencies-{{ checksum "pom.xml" }}
|
82
80
|
|
81
|
+
- run:
|
82
|
+
name: Migrate DB
|
83
|
+
command: mvn flyway:migrate -Dflyway.url=jdbc:mysql://127.0.0.1:3306/chicago -Dflyway.user=root -Dflyway.password=
|
84
|
+
|
85
|
+
- run:
|
86
|
+
name: Show Database
|
87
|
+
command: |
|
88
|
+
sudo apt-get install default-mysql-client
|
89
|
+
mysql -h 127.0.0.1 -u root -e 'show databases;'
|
90
|
+
|
83
91
|
# run tests!
|
84
92
|
- run: mvn integration-test
|
85
93
|
```
|
86
94
|
|
87
95
|
## 発生しているエラー
|
88
96
|
Migrate DBのステップで次のエラーが生じているようです。
|
89
|
-
|
97
|
+
ログを見る限りだとMySQLコンテナにデータベースを発見できないor使用できない状況のようです。
|
90
98
|
```
|
91
|
-
|
99
|
+
[INFO]
|
92
|
-
|
100
|
+
[INFO] ----------------------< com.uruk:chicago-spring >-----------------------
|
93
|
-
[INFO]
|
101
|
+
[INFO] Building chicago-spring 0.0.1-SNAPSHOT
|
102
|
+
[INFO] --------------------------------[ jar ]---------------------------------
|
103
|
+
[INFO]
|
94
|
-
|
104
|
+
[INFO] --- flyway-maven-plugin:5.2.4:migrate (default-cli) @ chicago-spring ---
|
105
|
+
[INFO] Flyway Community Edition 5.2.4 by Boxfuse
|
95
106
|
[INFO] ------------------------------------------------------------------------
|
96
107
|
[INFO] BUILD FAILURE
|
97
108
|
[INFO] ------------------------------------------------------------------------
|
98
|
-
[INFO] Total time:
|
109
|
+
[INFO] Total time: 2.752 s
|
99
|
-
[INFO] Finished at: 2019-07-
|
110
|
+
[INFO] Finished at: 2019-07-24T13:53:04Z
|
100
111
|
[INFO] ------------------------------------------------------------------------
|
101
|
-
[ERROR]
|
112
|
+
[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:5.2.4:migrate (default-cli) on project chicago-spring: org.flywaydb.core.internal.exception.FlywaySqlException:
|
113
|
+
[ERROR] Unable to obtain connection from database (jdbc:mysql://127.0.0.1:3306/chicago) for user 'root': Unknown database 'chicago'
|
114
|
+
[ERROR] ---------------------------------------------------------------------------------------------------------------------------
|
115
|
+
[ERROR] SQL State : 42000
|
116
|
+
[ERROR] Error Code : 1049
|
117
|
+
[ERROR] Message : Unknown database 'chicago'
|
102
118
|
[ERROR]
|
119
|
+
[ERROR] -> [Help 1]
|
120
|
+
[ERROR]
|
103
121
|
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
|
104
122
|
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
|
105
123
|
[ERROR]
|
106
124
|
[ERROR] For more information about the errors and possible solutions, please read the following articles:
|
107
|
-
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/
|
125
|
+
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
|
108
126
|
Exited with code 1
|
109
127
|
```
|
110
128
|
|
111
129
|
また、エラーなのかわからないのですがContainer circleci/mysql:8.0-ramのステップは以下のログを出力して灰色になっています。
|
112
130
|
|
113
|
-
```
|
114
|
-
|
115
|
-
2019-07-
|
116
|
-
2019-07-
|
117
|
-
2019-07-
|
118
|
-
2019-07-
|
119
|
-
2019-07-
|
120
|
-
2019-07-23T14:15:29.177705Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
|
131
|
+
```Initializing database
|
132
|
+
2019-07-24T13:52:52.757914Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
|
133
|
+
2019-07-24T13:52:52.758005Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 40
|
134
|
+
2019-07-24T13:52:52.759501Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
135
|
+
2019-07-24T13:52:52.759519Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
136
|
+
2019-07-24T13:52:54.250203Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
|
137
|
+
2019-07-24T13:52:54.882324Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server has completed
|
121
138
|
Database initialized
|
122
139
|
MySQL init process in progress...
|
123
|
-
2019-07-
|
124
|
-
2019-07-
|
125
|
-
2019-07-
|
126
|
-
2019-07-
|
127
|
-
2019-07-
|
128
|
-
2019-07-
|
129
|
-
2019-07-
|
130
|
-
2019-07-
|
140
|
+
2019-07-24T13:52:55.462248Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
|
141
|
+
2019-07-24T13:52:55.462338Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 161
|
142
|
+
2019-07-24T13:52:55.464725Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
143
|
+
2019-07-24T13:52:55.464745Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
144
|
+
2019-07-24T13:52:55.841740Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
|
145
|
+
2019-07-24T13:52:55.849451Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
|
146
|
+
2019-07-24T13:52:55.867016Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
|
147
|
+
2019-07-24T13:52:55.949226Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
|
131
148
|
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
|
132
149
|
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
|
133
150
|
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
|
134
151
|
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
|
135
152
|
|
136
|
-
2019-07-
|
153
|
+
2019-07-24T13:52:58.710605Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
|
137
154
|
|
138
155
|
MySQL init process done. Ready for start up.
|
139
156
|
|
140
|
-
2019-07-
|
141
|
-
2019-07-
|
142
|
-
2019-07-
|
143
|
-
2019-07-
|
144
|
-
2019-07-
|
145
|
-
2019-07-
|
146
|
-
2019-07-
|
147
|
-
2019-07-
|
157
|
+
2019-07-24T13:52:59.054386Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
|
158
|
+
2019-07-24T13:52:59.054501Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17) starting as process 7
|
159
|
+
2019-07-24T13:52:59.057659Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
|
160
|
+
2019-07-24T13:52:59.057686Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
|
161
|
+
2019-07-24T13:52:59.441213Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
|
162
|
+
2019-07-24T13:52:59.446079Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
|
163
|
+
2019-07-24T13:52:59.465685Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
|
164
|
+
2019-07-24T13:52:59.557754Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
|
148
165
|
|
149
166
|
Job was canceled
|
150
167
|
```
|
1
mavenのバージョンを記載しました。
title
CHANGED
File without changes
|
body
CHANGED
@@ -14,7 +14,7 @@
|
|
14
14
|
|DB|MySQL 8.0|
|
15
15
|
|DB ドライバ | JDBC |
|
16
16
|
|マイグレーションツール|Flyway|
|
17
|
-
|ライブラリツール|maven|
|
17
|
+
|ライブラリツール|maven 3.6.1 |
|
18
18
|
|
19
19
|
また、CIでのMySQLの設定は以下の通りにしたいと思っています。
|
20
20
|
|||
|