MySQL causes a BSOD on my Windows XP when the table files are "toobig"

All,

I have a dedicated Windows desktop for downloading several million
records into about 15 tables. I'm getting a BSOD crash when MySQL is
trying to run insert or delete queries, repair table, and mysqlcheck
utility.

What I have determined is that when one of the .MYD files is bigger than
1.7 GB, the BSOD almost always happens when I try to delete some of the
records, repair table, etc. "truncate" seems to be about the only SQL
that will work on this table.

Any suggestions??

*Desktop specs*
- Dell Precision 370
- Pentium 4 3.60 GHz
- 2.00 GB Ram
- MS Windows XP Version 2002 sp 2

- MySQL version 4.1.13a-nt

*MySQL config:*
query_cache_size=8M
table_cache=256
tmp_table_size=103M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=205M
key_buffer_size=349M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: MySQL causes a BSOD on my Windows XP when the table files are "too big"

The sort buffers look woefully small for a table that size... No specifics
just a quick direction for exploration.

Leif

-----Original Message-----
From: Philip Daggett [mailto:Philip.Daggett@jpl.nasa.gov]
Sent: Thursday, September 08, 2005 1:50 PM
To: win32@lists.mysql.com
Subject: MySQL causes a BSOD on my Windows XP when the table files are "too
big"

All,

I have a dedicated Windows desktop for downloading several million records
into about 15 tables. I'm getting a BSOD crash when MySQL is trying to run
insert or delete queries, repair table, and mysqlcheck utility.

What I have determined is that when one of the .MYD files is bigger than
1.7 GB, the BSOD almost always happens when I try to delete some of the
records, repair table, etc. "truncate" seems to be about the only SQL that
will work on this table.

Any suggestions??

*Desktop specs*
- Dell Precision 370
- Pentium 4 3.60 GHz
- 2.00 GB Ram
- MS Windows XP Version 2002 sp 2

- MySQL version 4.1.13a-nt

*MySQL config:*
query_cache_size=8M
table_cache=256
tmp_table_size=103M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=205M
key_buffer_size=349M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=leif@technologycatalyst.c om



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org