在資料庫管理平臺Archery上定時任務執行DDL操作,第二天發現報錯,報錯資訊如下:
Error copying rows from `DB`.`TABLE_NAME` to `DB`.`_TABLE_NAME_new`: Threads_connected=1358 exceeds its critical threshold 1300
登入檢視Threads_connected資訊,Threads_connected 一直處於大於1300個連線:
mysql> show status like '%thread%';
+------------------------------------------+----------+
| Variable_name | Value |
+------------------------------------------+----------+
| Com_show_thread_statistics | 0 |
| Delayed_insert_threads | 0 |
| Innodb_master_thread_active_loops | 30810790 |
| Innodb_master_thread_idle_loops | 45 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Slow_launch_threads | 0 |
| Threadpool_idle_threads | 92 |
| Threadpool_threads | 99 |
| Threads_cached | 0 |
| Threads_connected | 1368 |
| Threads_created | 2283216 |
| Threads_running | 8 |
+------------------------------------------+----------+
檢視inception中變數值設定:
[root@hankyoon ~]# mysql -h127.0.0.1 -uroot -P6669
mysql> inception get variables ;
...
...
...
| inception_osc_critical_thread_connected | 1300 |
...
...
...
修改inception_osc_critical_thread_connected值,為1800
mysql> inception set inception_osc_max_thread_connected = 1800;
在Archery平臺重新提交DDL SQL即可.