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). At the start of the creating, it's fast (because my buffer pool is free), but when the buffer pool reaches at the end, the system slow down, and the swap in/out begins :/ I have 512MB of RAM. My configuration is: buffer pool size 256MB innobd_log_file 128MB innodb_log_buffer_size 8MB I tried innodb_flush_log_at_trx_commit with 1/0, innodb_flush_method with fdatasync/O_SYNC, innodb_log_buffer_size to 32MB, but nothing happens! I don't know if i have to re-build my tables... but i think that it would take a lot of time too (16 million rows...). What can i do? Thanks Alexis P.S.:i have only innodb tables on my DB. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
