On Wed, Feb 12, 2003 at 08:06:03AM +0100, Nico Rehmann wrote: > Hi, > > I have a big problem. > I NEED to do a full table scan every month on a table. > I really need all of the data in this table > This table has about 1,2 GB of data. > It takes mysql about 45 minutes to send the data. > > I configured mysql with the my-huge.cnf and > I also tried "record_buffer=50M" > but nothing really changed > > Server: > 2 GB RAM, > 4 IDE Harddisks and IBM RAID Controller > only mysql is running on this server > > What do i have to configure to get these huge amount of data faster? > Or is mysql not the right database for such things?
Is the scanning disk or I/O bound? Does it max out the CPU? Or is there idle time yet? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 8 days, processed 283,232,781 queries (371/sec. avg) --------------------------------------------------------------------- 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
