A good thought, in fact it's mentioned in my original post. My problem with that is that at the current table size, an index can take more than 24 hours to generate when the table is full, and I can't find any way to measure its progress. So I won't know if I'm waiting for days for something, or for nothing. I'd rather be able to see progress.
If there's some way to generate the indexes with the progress meter on, let me know, please. rc wrote: >also, consider your keys - as you insert records the indexes are rebuild >with each insert. the larger your table gets, and the more keys you have, >the longer each one takes. you may consider adding the keys after >inserting all your data....just a thought. > >On Thu, 20 Dec 2001, Steve Rapaport wrote: > >>VALinux 2-CPU P3, 800 Mhz, using mysql Ver 11.15 Distrib 3.23.37, for >>pc-linux-gnu (i686) >>Tables are MyISAM. >> >>Computer has 1 GB of memory, tuned for large DBs. >> >> >>Philip Molter wrote: >> >>>On Thu, Dec 20, 2001 at 08:32:55PM +0100, Steve Rapaport wrote: >>>: Okay, here's a tuning/opt problem for you experts: >>>: >>>: I have several CD's worth of records that are being converted >>>: and then inserted into our phone listing database. the total >>>: db size will be about 22 million listings. >>> >>>What version of MySQL are you using, what kind of system are you >>>running on, and what kind of table handler (MyISAM, InnoDB, BDB, >>>etc.) are you using for this table? >>> >> >> >>--------------------------------------------------------------------- >>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 >> > > -- Steve Rapaport World Citizen --------------------------------------------------------------------- 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
