'2018/11'에 해당되는 글 1건
오류처리 Exception 'yii\db\Exception' with message 'Error while sending QUERY packet.
| Web_Program/MySQL 2018. 11. 5. 16:461 [mysqld]
2 max_allowed_packet=524288000
3
4 skip-external-locking
5 key_buffer_size = 512M
6 max_allowed_packet = 16M
7 table_open_cache = 512
8 sort_buffer_size = 2M
9 read_buffer_size = 2M
10 read_rnd_buffer_size = 8M
11 myisam_sort_buffer_size = 64M
12 thread_cache_size = 8
13 query_cache_size = 64M
14 thread_concurrency = 8
15 server-id = 1162
16 binlog_format=mixed
17 expire_logs_days = 5
18 user = mysql
19 skip_name_resolve
20 log-warnings = 2
21 slow_query_log
22 long_query_time = 1
23 open_files_limit = 2048
24 skip_slave_start
25 slave-skip-errors = all
26 max_heap_table_size = 1G
27 wait_timeout = 28800
max_allowed_packet=524288000
wait_timeout = 28800
2가지 옵션을 줘본다.
