Hi all, I have a problem with MySQL under Windows NT/2000 where it crashes every time I issue an ALTER TABLE command while the table is being written to under high load. I've tried several versions of MySQL on a few different machines/OS and still the problem remains. I'm hoping someone might be able to tell me what I'm doing wrong.
Server 1 (previous configuration):
Single Pentium 2/266MHz
384MB RAM
Windows NT Server 4.0 w/service pack 6
MySQL 3.23.39
Server 1 (upgraded/current configuration):
Single Pentium 2/266MHz
384MB RAM
Windows 2000 Server
MySQL 3.23.49
Server 2:
Single Pentium 3/500 MHz
256MB RAM
Windows 2000 Server
MySQL 3.23.49
Server 3:
Single Pentium 2/233 MHz
128MB RAM
Windows 2000 Server
MySQL 3.23.39/3.23.49/3.23.50 (pre-release)
(I've included the output from the 'show variables' command at the bottom of the email)
Everything runs fine until I have to make a minor change once in a blue moon to one of
the more heavily used tables. I've been able to reproduce the exact same behavior on
a test database on all of the machines. The test database is defined below:
mysql> CREATE DATABASE stresstest;
mysql> USE stresstest;
mysql> CREATE TABLE InsertTest ( KeyField int not null auto_increment primary key,
KeyValue varchar(255) );
I then run several Perl scripts that simply start inserting rows like crazy into this
new table. Then from a mysql command window I issue a simple ALTER statement like
below:
mysql> ALTER TABLE InsertTest ADD COLUMN DummyField int;
The update works, however the mysql-nt service crashes with an Application Error ( The
instruction at "0x77f83941 referenced memory at 0x00000010". The memory could not be
written) immediately after the update is complete. Under NT 4.0, a Dr. Watson error
similar to that would appear instead. I've tried locking the table using LOCK TABLES
InsertTest WRITE before issuing the update but it still fails.
Please let me know if you need any more information. Any help would be greatly
appreciated!
mysql> show variables;
+---------------------------------+---------------------------------------------
--------------------------------------------------------------------------------
----------------------------------------------------------------------------+
| Variable_name | Value
|
+---------------------------------+---------------------------------------------
--------------------------------------------------------------------------------
----------------------------------------------------------------------------+
| back_log | 50
|
| basedir | d:\mysql\
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis
620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1
251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir | d:\mysql\data\
|
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| flush | OFF
|
| flush_time | 1800
|
| have_bdb | NO
|
| have_gemini | NO
|
| have_innodb | NO
|
| have_isam | YES
|
| have_raid | NO
|
| have_openssl | NO
|
| init_file |
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 16773120
|
| language | d:\mysql\share\english\
|
| large_files_support | ON
|
| log | OFF
|
| log_update | OFF
|
| log_bin | ON
|
| log_slave_updates | OFF
|
| log_long_queries | OFF
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_table_names | 1
|
| 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_max_extra_sort_file_size | 256
|
| myisam_max_sort_file_size | 2047
|
| myisam_recover_options | 0
|
| myisam_sort_buffer_size | 8388608
|
| net_buffer_length | 16384
|
| net_read_timeout | 30
|
| net_retry_count | 10
|
| net_write_timeout | 60
|
| open_files_limit | 0
|
| pid_file | d:\mysql\data\westoma-app01.pid
|
| port | 3306
|
| protocol_version | 10
|
| record_buffer | 131072
|
| record_rnd_buffer | 131072
|
| query_buffer_size | 0
|
| safe_show_database | OFF
|
| server_id | 10
|
| slave_net_timeout | 3600
|
| skip_locking | ON
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slow_launch_time | 2
|
| socket | MySQL
|
| sort_buffer | 2097144
|
| sql_mode | 0
|
| table_cache | 64
|
| table_type | MYISAM
|
| thread_cache_size | 0
|
| thread_stack | 131072
|
| transaction_isolation | READ-COMMITTED
|
| timezone | Central Daylight Time
|
| tmp_table_size | 33554432
|
| tmpdir | C:\WINNT\TEMP\
|
| version | 3.23.49-nt-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
