On Thu, 2001-10-18 at 06:47, Roman Serbski wrote: > Good day. > > I'm planning to upgrade Vpopmail 4.9.10 to 5.0 (final beta). I use MySQL > authorization and plan to add --enable-large-site=y while compiling > Vpopmail 5.0. I *didn't* use "--enable-large-site=y" feature in 4.9.10 > before. FAQ says that process of upgrading is approx. similiar to fresh > install - download sources - compile - done :). Is it true for migration > from 4.9.10 to 5.0? > In other words, adding support for large-site will definitely > rebuild/remake vpopmail's DB in MySQL (make it one table per domain). > Right now I have all domains/users in one table (vpopmail), do I have to > change settings of database (vpopmail) manually or everything will be > fixed up by vpopmail? :)
If you have more than 4 domains on the machine don't use the old --enable-large-site=y option. This option was renamed --enable-many-domains. The default is yes, meaning you have more than 4 domains. --enable-many-domains=n is only for sites with less than 4 domains. rebuild/remake of 5.0 won't automatically convert your single table to a table per domain. You would have to do that yourself. warning: if you have more than 4 domains and you want to put each domain in a single table, performance will suffer. Why? because mysql opens a file descriptor per table and has a limited number of file descriptors. Too many tables will cause mysql to open and close file descriptors which is relatively expensive per sql transaction. ken Jones
