On Tue, Jun 12, 2001 at 04:47:47PM -0500, Paul DuBois wrote:
>
> Try using:
>
> $dbh->do ("UPDATE ... WHERE k = ?", undef, "xxx")
> and then access $dbh->{mysql_insertid} to see if you get a different
> result. I suspect perhaps not, but it's something to try.
Unfortunately I get the same result.
Interestingly, the problem only seems to manifest itself when more than 4
processes are hitting the database with this query. The test I am running
is the following:
spawn N programs each of which makes a connection to the
remote database and performs the above query M times.
For N <= 4, I can't make things fail, even for M >= 10000. But with N=5,
I can get failure for M as low as 500.
Btw... I'm using 3.23.35. fwiw, here's my show variables output.
Variable_name Value
ansi_mode OFF
back_log 50
basedir /
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk 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
datadir /var/lib/mysql/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb NO
have_gemini NO
have_innobase NO
have_isam YES
have_raid NO
have_ssl NO
init_file
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 12288
language /usr/share/mysql/english/
large_files_support ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin ON
log_slave_updates OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1047552
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_recover_options OFF
myisam_sort_buffer_size 8388608
net_buffer_length 1024
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file /var/lib/mysql/sandbox.dev.fanbuzz.com.pid
port 3306
protocol_version 10
record_buffer 131072
query_buffer_size 0
safe_show_database OFF
server_id 1
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer 65528
table_cache 4
table_type MYISAM
thread_cache_size 0
thread_stack 65536
timezone CDT
tmp_table_size 1048576
tmpdir /tmp/
version 3.23.35-log
wait_timeout 28800
---------------------------------------------------------------------
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