If I use the transaction isolation level of READ-COMMITTED, I have the problems that I do not see changes to the table made within another connection (and commited) until I call commit in my connection. As of my understanding this behaviour is correct for the REPEATABLE-READ and SERIALIZABLE isolation level, but not for READ-COMMITTED. Beside the fact that this is not the behaviour I expect, this results in performance loss, because lots of version have to be created if multiple users have open connections. I tried this under Windows 2000 [Version 5.00.2195] SP 3. (The variables and status are attached to this mail) Thanks in advance! Best regards Horst Scheruga Show variables: Variable_name Value back_log 50 basedir C:\mysql\ bdb_cache_size 8388600 bdb_log_buffer_size 32768 bdb_home d:\MySqlData\ bdb_max_lock 10000 bdb_logdir bdb_shared_data OFF bdb_tmpdir D:\Temp\ bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (September 27, 2002) binlog_cache_size 32768 bulk_insert_buffer_size 8388608 character_set latin1 character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis 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 ON connect_timeout 5 convert_character_set datadir d:\MySqlData\ delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 1800 ft_min_word_len 4 ft_max_word_len 254 ft_max_word_len_for_sort 20 ft_boolean_syntax + -><()~*:""&| have_bdb YES 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 0 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 8388600 language C:\mysql\share\english\ large_files_support ON local_infile ON log OFF log_update OFF log_bin OFF log_slave_updates OFF log_slow_queries OFF log_warnings OFF long_query_time 10 low_priority_updates OFF lower_case_table_names ON max_allowed_packet 1048576 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 268435456 myisam_max_sort_file_size 2147483647 myisam_recover_options OFF myisam_sort_buffer_size 8388608 named_pipe OFF net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 pid_file d:\MySqlData\scheruga.pid port 3306 protocol_version 10 read_buffer_size 131072 read_rnd_buffer_size 262144 rpl_recovery_rank 0 query_cache_limit 1048576 query_cache_size 0 query_cache_type ON safe_show_database OFF server_id 0 slave_net_timeout 3600 skip_external_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket MySQL sort_buffer_size 2097144 sql_mode 0 table_cache 64 table_type MYISAM thread_cache_size 0 thread_stack 65536 tx_isolation READ-COMMITTED timezone W. Europe Daylight Time tmp_table_size 33554432 tmpdir D:\Temp\ version 4.0.4-beta-max-nt wait_timeout 28800
Show status: Variable_name Value Aborted_clients 336 Aborted_connects 0 Bytes_received 0 Bytes_sent 0 Com_admin_commands 0 Com_alter_table 0 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_change_db 2769 Com_change_master 0 Com_check 0 Com_commit 2276 Com_create_db 0 Com_create_function 0 Com_create_index 0 Com_create_table 1 Com_delete 2463 Com_delete_multi 0 Com_drop_db 0 Com_drop_function 0 Com_drop_index 0 Com_drop_table 1 Com_flush 0 Com_grant 0 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_insert 2465 Com_insert_select 0 Com_kill 0 Com_load 0 Com_load_master_data 0 Com_load_master_table 0 Com_lock_tables 0 Com_optimize 0 Com_purge 0 Com_rename_table 0 Com_repair 0 Com_replace 0 Com_replace_select 0 Com_reset 0 Com_restore_table 0 Com_revoke 0 Com_rollback 226 Com_select 2207 Com_set_option 2889 Com_show_binlog_events 0 Com_show_binlogs 0 Com_show_create 0 Com_show_databases 24 Com_show_fields 212 Com_show_grants 0 Com_show_keys 1 Com_show_logs 0 Com_show_master_status 0 Com_show_new_master 0 Com_show_open_tables 0 Com_show_processlist 1 Com_show_slave_hosts 0 Com_show_slave_status 0 Com_show_status 1587 Com_show_innodb_status 0 Com_show_tables 232 Com_show_variables 2782 Com_slave_start 0 Com_slave_stop 0 Com_truncate 0 Com_unlock_tables 0 Com_update 283 Connections 2779 Created_tmp_disk_tables 0 Created_tmp_tables 0 Created_tmp_files 0 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_commit 1711 Handler_delete 494 Handler_read_first 1837 Handler_read_key 10268 Handler_read_next 7572 Handler_read_prev 0 Handler_read_rnd 2015 Handler_read_rnd_next 3341 Handler_rollback 2207 Handler_update 35 Handler_write 2465 Key_blocks_used 3 Key_read_requests 1558 Key_reads 3 Key_write_requests 1486 Key_writes 992 Max_used_connections 30 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables 0 Open_files 0 Open_streams 0 Opened_tables 18 Questions 22878 Qcache_queries_in_cache 0 Qcache_inserts 0 Qcache_hits 0 Qcache_not_cached 0 Qcache_free_memory 0 Qcache_free_blocks 0 Qcache_total_blocks 0 Rpl_status NULL Select_full_join 0 Select_full_range_join 0 Select_range 0 Select_range_check 0 Select_scan 1836 Slave_open_temp_tables 0 Slave_running OFF Slow_launch_threads 0 Slow_queries 0 Sort_merge_passes 0 Sort_range 0 Sort_rows 2015 Sort_scan 300 Table_locks_immediate 7419 Table_locks_waited 0 Threads_cached 0 Threads_created 2778 Threads_connected 2 Threads_running 1 Uptime 102038 -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! --------------------------------------------------------------------- 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