Re: practical MySQL database size limits

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 set myisam_repair_threads

. 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]

myisam_max_extra_sort_file_size

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]

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

Can't force Repair by sort

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 archives: http://lists.mysql.com/mysql To unsubscribe

Re: LOAD DATA hangs

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: 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.com/mysql To unsubscribe:http

Re: LOAD DATA hangs

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

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

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 Jain