質問編集履歴
1
試したことを追加しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -193,7 +193,38 @@
|
|
|
193
193
|
- phpの```max_input_time```を600にした
|
|
194
194
|
- phpの```opcache.force_restart_timeout```を120にした
|
|
195
195
|
- 設定をいじる度に```sudo systemctl restart apache2```
|
|
196
|
-
|
|
196
|
+
- MySQLの怪しい設定を変更した
|
|
197
|
+
```
|
|
198
|
+
mysql> show global variables like '%timeout%';
|
|
199
|
+
+-----------------------------------+----------+
|
|
200
|
+
| Variable_name | Value |
|
|
201
|
+
+-----------------------------------+----------+
|
|
202
|
+
| connect_timeout | 180 |
|
|
203
|
+
| delayed_insert_timeout | 300 |
|
|
204
|
+
| have_statement_timeout | YES |
|
|
205
|
+
| innodb_flush_log_at_timeout | 1 |
|
|
206
|
+
| innodb_lock_wait_timeout | 500 |
|
|
207
|
+
| innodb_rollback_on_timeout | OFF |
|
|
208
|
+
| interactive_timeout | 28800 |
|
|
209
|
+
| lock_wait_timeout | 31536000 |
|
|
210
|
+
| mysqlx_connect_timeout | 180 |
|
|
211
|
+
| mysqlx_idle_worker_thread_timeout | 600 |
|
|
212
|
+
| mysqlx_interactive_timeout | 28800 |
|
|
213
|
+
| mysqlx_port_open_timeout | 0 |
|
|
214
|
+
| mysqlx_read_timeout | 300 |
|
|
215
|
+
| mysqlx_wait_timeout | 28800 |
|
|
216
|
+
| mysqlx_write_timeout | 600 |
|
|
217
|
+
| net_read_timeout | 300 |
|
|
218
|
+
| net_write_timeout | 600 |
|
|
219
|
+
| replica_net_timeout | 600 |
|
|
220
|
+
| rpl_stop_replica_timeout | 31536000 |
|
|
221
|
+
| rpl_stop_slave_timeout | 31536000 |
|
|
222
|
+
| slave_net_timeout | 600 |
|
|
223
|
+
| ssl_session_cache_timeout | 300 |
|
|
224
|
+
| wait_timeout | 28800 |
|
|
225
|
+
+-----------------------------------+----------+
|
|
226
|
+
23 rows in set (0.00 sec)
|
|
227
|
+
```
|
|
197
228
|
|
|
198
229
|
### 補足情報（FW/ツールのバージョンなど）
|
|
199
230
|
|