| Variable Name | Value Type | Type |
autocommit |
boolean | SESSION |
big_tables |
boolean | SESSION |
binlog_cache_size |
numeric | GLOBAL |
bulk_insert_buffer_size |
numeric | GLOBAL | SESSION |
character_set_client |
string | GLOBAL | SESSION |
character_set_connection |
string | GLOBAL | SESSION |
character_set_results |
string | GLOBAL | SESSION |
character_set_server |
string | GLOBAL | SESSION |
collation_connection |
string | GLOBAL | SESSION |
collation_server |
string | GLOBAL | SESSION |
concurrent_insert |
boolean | GLOBAL |
connect_timeout |
numeric | GLOBAL |
convert_character_set |
string | GLOBAL | SESSION |
default_week_format |
numeric | GLOBAL | SESSION |
delay_key_write |
OFF | ON | ALL |
GLOBAL |
delayed_insert_limit |
numeric | GLOBAL |
delayed_insert_timeout |
numeric | GLOBAL |
delayed_queue_size |
numeric | GLOBAL |
error_count |
numeric | SESSION |
expire_logs_days |
numeric | GLOBAL |
flush |
boolean | GLOBAL |
flush_time |
numeric | GLOBAL |
foreign_key_checks |
boolean | SESSION |
ft_boolean_syntax |
numeric | GLOBAL |
group_concat_max_len |
numeric | GLOBAL | SESSION |
identity |
numeric | SESSION |
insert_id |
boolean | SESSION |
interactive_timeout |
numeric | GLOBAL | SESSION |
join_buffer_size |
numeric | GLOBAL | SESSION |
key_buffer_size |
numeric | GLOBAL |
last_insert_id |
numeric | SESSION |
local_infile |
boolean | GLOBAL |
log_warnings |
boolean | GLOBAL |
long_query_time |
numeric | GLOBAL | SESSION |
low_priority_updates |
boolean | GLOBAL | SESSION |
max_allowed_packet |
numeric | GLOBAL | SESSION |
max_binlog_cache_size |
numeric | GLOBAL |
max_binlog_size |
numeric | GLOBAL |
max_connect_errors |
numeric | GLOBAL |
max_connections |
numeric | GLOBAL |
max_delayed_threads |
numeric | GLOBAL |
max_error_count |
numeric | GLOBAL | SESSION |
max_heap_table_size |
numeric | GLOBAL | SESSION |
max_insert_delayed_threads |
numeric | GLOBAL |
max_join_size |
numeric | GLOBAL | SESSION |
max_relay_log_size |
numeric | GLOBAL |
max_seeks_for_key |
numeric | GLOBAL | SESSION |
max_sort_length |
numeric | GLOBAL | SESSION |
max_tmp_tables |
numeric | GLOBAL |
max_user_connections |
numeric | GLOBAL |
max_write_lock_count |
numeric | GLOBAL |
myisam_max_extra_sort_file_size |
numeric | GLOBAL | SESSION |
myisam_max_sort_file_size |
numeric | GLOBAL | SESSION |
myisam_repair_threads |
numeric | GLOBAL | SESSION |
myisam_sort_buffer_size |
numeric | GLOBAL | SESSION |
net_buffer_length |
numeric | GLOBAL | SESSION |
net_read_timeout |
numeric | GLOBAL | SESSION |
net_retry_count |
numeric | GLOBAL | SESSION |
net_write_timeout |
numeric | GLOBAL | SESSION |
optimizer_prune_level |
numeric | GLOBAL | SESSION |
optimizer_search_depth |
numeric | GLOBAL | SESSION |
query_alloc_block_size |
numeric | GLOBAL | SESSION |
query_cache_limit |
numeric | GLOBAL |
query_cache_size |
numeric | GLOBAL |
query_cache_type |
enumeration | GLOBAL | SESSION |
query_cache_wlock_invalidate |
boolean | GLOBAL | SESSION |
query_prealloc_size |
numeric | GLOBAL | SESSION |
range_alloc_block_size |
numeric | GLOBAL | SESSION |
read_buffer_size |
numeric | GLOBAL | SESSION |
read_only |
numeric | GLOBAL |
read_rnd_buffer_size |
numeric | GLOBAL | SESSION |
rpl_recovery_rank |
numeric | GLOBAL |
safe_show_database |
boolean | GLOBAL |
server_id |
numeric | GLOBAL |
slave_compressed_protocol |
boolean | GLOBAL |
slave_net_timeout |
numeric | GLOBAL |
slow_launch_time |
numeric | GLOBAL |
sort_buffer_size |
numeric | GLOBAL | SESSION |
sql_auto_is_null |
boolean | SESSION |
sql_big_selects |
boolean | SESSION |
sql_big_tables |
boolean | SESSION |
sql_buffer_result |
boolean | SESSION |
sql_log_bin |
boolean | SESSION |
sql_log_off |
boolean | SESSION |
sql_log_update |
boolean | SESSION |
sql_low_priority_updates |
boolean | GLOBAL | SESSION |
sql_max_join_size |
numeric | GLOBAL | SESSION |
sql_quote_show_create |
boolean | SESSION |
sql_safe_updates |
boolean | SESSION |
sql_select_limit |
numeric | SESSION |
sql_slave_skip_counter |
numeric | GLOBAL |
sql_warnings |
boolean | SESSION |
storage_engine |
enumeration | GLOBAL | SESSION |
table_cache |
numeric | GLOBAL |
table_type |
enumeration | GLOBAL | SESSION |
thread_cache_size |
numeric | GLOBAL |
time_zone |
string | GLOBAL | SESSION |
timestamp |
boolean | SESSION |
tmp_table_size |
enumeration | GLOBAL | SESSION |
transaction_alloc_block_size |
numeric | GLOBAL | SESSION |
transaction_prealloc_size |
numeric | GLOBAL | SESSION |
tx_isolation |
enumeration | GLOBAL | SESSION |
unique_checks |
boolean | SESSION |
wait_timeout |
numeric | GLOBAL | SESSION |
warning_count |
numeric | SESSION |
mysql>show variables; // 서버 변수보기
mysql>SET GLOBAL max_allowed_packet = 1024 * 1024 * 32; // 기본값은 16메가 인데... 32메가로 변경
mysql>SET SESSION max_allowed_packet = 1024 * 1024 * 5; // 기본값은 1메가 인데... 5메가로 변경
위의 두개는 넉넉하게 사용하자..
백업받은 자료를 살릴때 17메가라면 에러난다... 넉넉하게 32메가로..
직접 쿼리로 데이터를 넣을때 1메가라면 좀 게시판에 무거운 내용들은 올라가지 않는다..넉넉하게 5메가로...
http://cafe.naver.com/okjsp.cafe?iframe_url=/ArticleRead.nhn%3Farticleid=135
동일한 제목으로 네이버 검색하면 나옴
max_allowed_packet 발생시 대처법