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.
