[ic] Table management
emailgrant at gmail.com
Wed Sep 28 10:11:41 UTC 2016
>> How do you guys manage your mysql tables?
> Hi Grant,
> We use the DatabaseAuto directive which I think should solve your issues.
Maybe the key there is the NoImport statement which DatabaseAuto puts
into effect for each table? It sounds like NoImport moves table
management out of IC.
Also Andrew, I took a look at pullingshots.ca:
"I have been successfully running Interchange 5 using a stack of Plack
+ Nginx in production since February, 2016 on a busy site"
Your config is really simple. Has anyone else tried this? Any drawbacks?
>> I dropped a table column via the mysql command line interface
>> recently, but subsequently exporting that table to .txt file in IC
>> showed that the column was still there. Making changes to a
>> dbconf/mysql/*.mysql file or .txt file, deleting the associated .sql
>> file, and restarting IC to import a table can be a very slow process
>> which locks out all IC users in the meantime. I tried using:
>> Database tablename AutoCommit 0
>> to speed that up, and it worked, but then the table didn't work.
>> Is there a best way to do this kind of stuff when you're using IC?
More information about the interchange-users