質問編集履歴
1
書式の改善
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -18,7 +18,7 @@
|
|
|
18
18
|
|
|
19
19
|
|
|
20
20
|
|
|
21
|
-
```
|
|
21
|
+
```MySQL
|
|
22
22
|
|
|
23
23
|
ALTER TABLE table_name MODIFY target_column INT;
|
|
24
24
|
|
|
@@ -36,9 +36,9 @@
|
|
|
36
36
|
|
|
37
37
|
|
|
38
38
|
|
|
39
|
-
```
|
|
39
|
+
```MySQL
|
|
40
40
|
|
|
41
|
-
The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.
|
|
41
|
+
Error Code: 1118. The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.
|
|
42
42
|
|
|
43
43
|
```
|
|
44
44
|
|
|
@@ -74,15 +74,19 @@
|
|
|
74
74
|
|
|
75
75
|
一度下記コマンドを実施してみました。
|
|
76
76
|
|
|
77
|
-
```
|
|
77
|
+
```MySQL
|
|
78
78
|
|
|
79
|
-
SET @@innodb_log_file_size = 536870912;
|
|
79
|
+
SET @@innodb_log_file_size = 536870912;
|
|
80
80
|
|
|
81
81
|
```
|
|
82
82
|
|
|
83
83
|
しかしエラーメッセージが表示され読み込み専用とのことでできませんでした。
|
|
84
84
|
|
|
85
|
+
```MySQL
|
|
86
|
+
|
|
85
|
-
|
|
87
|
+
Error Code: 1238. Variable 'innodb_log_file_size' is a read only variable
|
|
88
|
+
|
|
89
|
+
```
|
|
86
90
|
|
|
87
91
|
|
|
88
92
|
|