On Wed, Sep 24, 2003 at 06:15:19PM +0100, [EMAIL PROTECTED] wrote: > > Hi, > > I'm working in MySQL with innodb tables, in Linux (Red Hat 9). > I'm creating indexes in a table with 16 million rows (it's a fact table), and it > takes a lot of time (2/3/4 hours), because my system is always swapping in/out > (i think).
You should first verify if swap really is a problem or not. That could have a big impact on how you solve this problem... -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 10 days, processed 389,349,141 queries (418/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]