Yes, i did that. It's given me something like si 200/300 so 300/500
It's a lot, doing my system going down. But i think that the problem is that i'm reserving too much memory for mysql... Or could exists another reason? Thx Alexis Quoting Per Andreas Buer <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] writes: > > > 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). > > If you run "vmstat 2" while the index is created you will see if swap is > beeing used or not (see the si and so columns and "man vmstat" for > futher information). > > > -- > Per Andreas Buer > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]