Hello, I have a few questions about InnoDB. I am new to InnoDB, and just converted my MyISAM tables into InnoDB a few days ago. I notice that it generates these files
-rw-rw---- 1 mysql mysql 2560 Nov 2 13:07 ib_arch_log_0000000000 -rw-rw---- 1 mysql mysql 790626304 Nov 4 20:44 ibdata1 -rw-rw---- 1 mysql mysql 10485760 Nov 4 20:44 ib_logfile0 -rw-rw---- 1 mysql mysql 10485760 Nov 4 20:44 ib_logfile1 -rw-rw---- 1 mysql mysql 10485760 Nov 3 00:02 ib_logfile2 But how can those files work together? In InnoDB documentation, it suggests to add another file ibdata2 to get higher performance. Can I do that now, after I have created the ibdata1 and used it for a while? The most important thing is I deleted a 300M database, but the ibdata1 remains the same size. MyPHPAdmin says 330,000KB free. How can I make the data file smaller? I will be really appreciated if someone can briefly describe what's happening to those files or point me to some articles. Thanks a lot, Leo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
