When mysql is running with innodb_file_per_table enabled you can use "OPTIMIZE TABLE" free space in the table files. When you have a single ibdata file it does not. I'm not aware of any cleanup scripts or what size you should expect the db to grow to.
-- Later, Darin On Mon, Jan 9, 2012 at 3:43 PM, Jo Rhett <jrh...@netconsonance.com> wrote: > On Jan 9, 2012, at 11:30 AM, Darin Perusich wrote: > > The ibdata1 file only grows and never shrinks so I'd recommend > setting/adding "innodb_file_per_table" in /etc/my.cnf. You'll need to > go through the steps to purge it first, google is your friend, first > but you'll now longer have the ever growing idbata1 file. > > > I'm not tracking this answer. I'm familiar with that option, and it means > that instead of one I will have eighteen ever-growing files, right? How > does this change the total space used? > > I have no problem with the database size never getting smaller on disk, I'm > just curious what size is expected for it to grow to, and are there any > cleanup scripts should should be done to free rows? > > -- > Jo Rhett > Net Consonance : consonant endings by net philanthropy, open source and > other randomness > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
