Здравствуйте!
PJS> kost wrote: >> PJS> kost wrote: >> >>>>Hi All! >>>> >>>>Currently I'm using dbmail 2.0.7 version. In near feature (I hope >>>>after dbmail 2.1.4 release) I'm going to migrate on 2.1.x branch. >>>>But I didn't find any docs about migration from 2.0 to 2.1 >>>> >>>>Shall it enough if I just add new tables from create_tables_innoDB.mysql >>>>file? >>>>Could anybody tell me about what to do? >> >> >> PJS> The simple answer: wait for 2.2.0 :-) >> >> PJS> First add all the new tables. After that, you will need to run >> PJS> dbmail-util -ay to prime the header-tables. >> >> PJS> And if you don't want to trust your data to 2.1 just yet, simply go back >> PJS> to 2.0.7. The database will be perfectly backward compatible. >> >> Good news :) >> But how long 'dbmail-util -ay' gonna do it's work? >> I have more than 40Gb of mail in MySQL database... PJS> mysql is pretty fast here. But 40GB is quite a lot. Depending on your PJS> hardware it will take several hours at the very least. PJS> My own system (dual-xeon, 1GBram, u320 scsi raid-1) needed about 2 hours PJS> for something like 7GB. Is there any sql queries that lock mysql tables in 'dbmail-util -ay' command? For example 'OPTIMIZE TABLE'...
