innodb_file_per_table set but ibdata still updated
Hi, in /etc/my.cnf I set innodb_file_per_table in order to avoid a centralized set of ibdata* files, but that file (8 MB) is still present and continually updated. What can I do to make it vanish for good? I'd like to have only per-table ibd files. The version of Mysql that I'm using is mysql-max 5.0.24a. Thanks, Nico -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Fai crescere i tuoi sogni. Scegli il prestito fino a 5.000 euro. * Rate da 20 euro Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6331d=28-3 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb_file_per_table set but ibdata still updated
In news:[EMAIL PROTECTED], Nico Sabbi [EMAIL PROTECTED] wrote: in /etc/my.cnf I set innodb_file_per_table in order to avoid a centralized set of ibdata* files, but that file (8 MB) is still present and continually updated. What can I do to make it vanish for good? As it is stated in the documentation, you can't. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb_file_per_table set but ibdata still updated
Hi Friends, This iddata datafile will be used by mysql to store internal data dictionary information. You cannot have a mysql db with only without these files. regards anandkl On 3/28/07, Maciej Dobrzanski [EMAIL PROTECTED] wrote: In news:[EMAIL PROTECTED], Nico Sabbi [EMAIL PROTECTED] wrote: in /etc/my.cnf I set innodb_file_per_table in order to avoid a centralized set of ibdata* files, but that file (8 MB) is still present and continually updated. What can I do to make it vanish for good? As it is stated in the documentation, you can't. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]