Cami Sardinha wrote: > [EMAIL PROTECTED] wrote: > >> He found some MySQL document stating that with MyISAM tables, the complete >> table gets locked during database operations, >> whereas InnoDB type of table would only lock the particular table row (but >> be somewhat slower in use). >> > > Correct. > > >> Could there be some problem, with regards to DB or table locking and policyd >> accessing the tables at same time? >> > > Well, when LOCK's occur, queries from Policyd -> MySQL will (forcefully) > timeout to prevent any delay. The reason we are using MyISAM instead of > InnoDB is because during testing under really high loads, we found that > InnoDB would not only be slower, but it would actually crash. Perhaps > InnoDB needs to be re-evaluated with the latest release. > >
We use a setup with an InnoDB on our cluster (>10'000 domains, >100'000 accounts). We convert MyISAM to InnoDB without problem. The only one chage in Policyd is the INSERT DELAY -> INSERT With a policyd database size of 3.4Go on a dual xenon 2.4Ghz 6Go RAM it perform really nice without any trouble during the last 2 month > Are you able to switch your Policyd database over to InnoDB? > (this will require some work, including a few Policyd changes) > > Cami > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > policyd-users mailing list > policyd-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/policyd-users > ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ policyd-users mailing list policyd-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/policyd-users
