Sameh, your innodb_buffer_pool_size seems a bit small. In the manual it says:
"Set buffer pool size to 50 - 80 % of your computer's memory, but make sure on Linux x86 total memory usage is < 2 GB". Your setting means that you have no more than 256MB RAM and that's not much for operations on really big files. Best regards, Thomas Spahni On Mon, 6 Jan 2003, Sameh Attia wrote: > I have a system running MySQL 3.23.41. I read many times about InnoDB > performance and that it is superior to the MyISAM one. I have a table > 'sessions' in a MyISAM format with about 20 milion records. Its size is > 2.5 GB; the index file is 1.1 GB. In mysql client I entered the > following command 'alter table sessions type=innodb' while these > settings were in my.cnf > innodb_data_home_dir=/path/to/the/database/dir > innodb_data_file_path=backup/ibdata:3072M:autoextend > set-variable = innodb_buffer_pool_size=128M > set-variable = innodb_additional_mem_pool_size=64M > set-variable = innodb_log_file_size=32M > set-variable = innodb_log_buffer_size=16M > > The command took about 10 hours to complete. Is this normal? > Also when it finished I issued the follwoing statement on another copy > of the table in MyISAM format; it took about 5 mins > SELECT ip,no,count(*) AS term,SUM(CEILING(session_time/60)*60) AS > total,AVG(CEILING(session_time/60)*60) AS average FROM sessions GROUP BY > ip; > > while when it was issued on the InnoDB one it took me 30 mins to give up > and shutdown the server with no luck. > Also the ibdata file is now 9.1 GB???? > Whats wrong? could anyone help? Im sure that InnoDB is good so it seems > I missed something could anyone point me? > > Regards --------------------------------------------------------------------- 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
