I am currently trying to insert images which are roughly around 140Mb each into my database using the data type longblob. The problem I seem to be having it that I cannot set the max_allowed_packet to go over 67107840. In my /etc/my.cnf I have the following line:
set-variable = max_allowed_packet=256M I have also tried changing this value lower but it seems to make no difference. Are they any other variables which also need to be increased which may affect max_allowed_packet? below is the output from show variables; +---------------------------------+----------------------------------------- ---------------------------------------------------------------------------- --------------------------------------+ | Variable_name | Value | +---------------------------------+----------------------------------------- ---------------------------------------------------------------------------- --------------------------------------+ | back_log | 50 | | basedir | /usr/local/mysql/ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | OFF | | connect_timeout | 5 | | datadir | /usr/local/mysql/var/ | | delay_key_write | OFF | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | ft_min_word_len | 4 | | ft_max_word_len | 254 | | ft_max_word_len_for_sort | 20 | | ft_boolean_syntax | + -><()~*:""&| | | have_bdb | NO | | have_innodb | YES | | have_isam | YES | | have_raid | NO | | have_symlink | YES | | have_openssl | NO | | have_query_cache | YES | | init_file | | | innodb_additional_mem_pool_size | 1048576 | | innodb_buffer_pool_size | 8388608 | | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir | | | innodb_file_io_threads | 4 | | innodb_force_recovery | 0 | | innodb_thread_concurrency | 8 | | innodb_flush_log_at_trx_commit | OFF | | innodb_fast_shutdown | ON | | innodb_flush_method | | | innodb_lock_wait_timeout | 50 | | innodb_log_arch_dir | | | innodb_log_archive | OFF | | innodb_log_buffer_size | 1048576 | | innodb_log_file_size | 5242880 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | ./ | | innodb_mirrored_log_groups | 1 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 268431360 | | language | /usr/local/mysql/share/mysql/english/ | | large_files_support | ON | | locked_in_memory | OFF | | log | OFF | | log_update | OFF | log_bin | ON | | log_slave_updates | OFF | | log_slow_queries | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | lower_case_table_names | 0 | | max_allowed_packet | 67107840 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 100 | | max_connect_errors | 10 | | max_delayed_threads | 20 | | max_heap_table_size | 134216704 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_user_connections | 0 | | max_tmp_tables | 32 | | max_write_lock_count | 4294967295 | | myisam_bulk_insert_tree_size | 8388608 | | myisam_max_extra_sort_file_size | 256 | | myisam_max_sort_file_size | 2047 | | myisam_recover_options | OFF | | myisam_sort_buffer_size | 134217728 | | net_buffer_length | 1047552 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | open_files_limit | 0 | | pid_file | /usr/local/mysql/var/hostname.pid | | port | 3306 | | protocol_version | 10 | | record_buffer | 8384512 | | record_rnd_buffer | 8384512 | | rpl_recovery_rank | 0 | | query_buffer_size | 0 | | query_cache_limit | 1048576 | | query_cache_size | 0 | | query_cache_startup_type | 1 | | safe_show_database | OFF | | server_id | 1 | | slave_net_timeout | 3600 | | skip_locking | ON | | skip_networking | OFF | | skip_show_database | OFF | | slow_launch_time | 2 | | socket | /tmp/mysql.sock | | sort_buffer | 4194296 | | sql_mode | 0 | | table_cache | 256 | | table_type | MYISAM | | thread_cache_size | 8 | | thread_stack | 65536 | | transaction_isolation | READ-COMMITTED | | timezone | CST | | tmp_table_size | 33554432 | | tmpdir | /tmp/ | | version | 4.0.2-alpha-log | | wait_timeout | 28800 | +---------------------------------+----------------------------------------- ---------------------------------------------------------------------------- --------------------------------------+ Any help would be greatly appreciated. Regards, Sam Hutchison, IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the CRIMES ACT 1914. If you have received this email in error, you are requested to contact the sender and delete the email." --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
