Re: practical MySQL database size limits

y. From my own experience MySQL (MyISAM) scales very well up to 20M rows, but 100M rows turned out to be too much... -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't force "Repair by sort"

sam_max_sort_file_size=1MB myisam_max_extra_sort_file_size=0 bulk_insert_buffer_size=64MB but this doesn't help. I am running somewhat low on diskspace with only a few gigabytes free, could this have any influence here? Any other ideas? -- Eric Jain -- MySQL General Mailing List For list archiv

myisam_max_sort_file_size not set

smaller than 4GB, or manually execute set global myisam_max_sort_file_size=100; does the variable get updated. Is there any reasoning behind this behavior, or is this simply a bug? -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

myisam_max_extra_sort_file_size

e_size is set large enough, this variable must be set to 0? -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't set myisam_repair_threads

threads' I'm using 4.1.0-alpha-standard. Am I doing something wrong, or was this variable dropped? If so, perhaps the documentation should be updated... -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: This is confusing..?

> mysql> explain SELECT * FROM campaign_t WHERE datestamp < 20041105\g Try surrounding the value with quotes, i.e.: explain SELECT * FROM campaign_t WHERE datestamp < '20041105' -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: LOAD DATA hangs

AM? Hmm. I just checked, and it seems it doesn't do anything. (For InnoDB tables, the query plan still shows type=ref rather than type=ALL after DISABLE KEYS.) -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD DATA hangs

n order to get MySQL to scale? Any important options I overlooked? Might InnoDB be faster? -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD DATA hangs

n a gigabyte of data into a table with a few indexes :-) -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

LOAD DATA hangs

size remained constant while the index size still increased, but now nothing seems to be happing any more, while the CPU is 100% busy. I would have expected the index to reach a final size of something around 4 GB. Any idea what has gone wrong here? Yet another limitation I have run into? -- Eric