Hi Joachim, > I ran into performance issues with my OpenXPKI setup, so I've finetuned > some MySQL settings. This is working quite fine so far in my testing > environment, but I'm not sure whether there could develop an incident > with this setting. Could someone recheck these, please? > > I've set innodb_buffer_pool_size from 64MB to 300MB to get more caching > size to have more buffer space when cleaning-up old CRLs so there will > be no errors anymore from MySQL within the cron job. > > innodb_log_buffer_size from 1MB to 30MB to increase the buffer size of the > innodb_log to clean out corresponding MySQL log files due to optimization.
I don't have too much experience with MySQL in production setups (we are using Oracle here), but I would assume that changing the database operation parameters will not influence the database operation itself. We noticed performance problems some time ago, but this was a result of missing indices on the workflow and workflow_context table. After adding the indices the system worked fine. cheers Martin ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ OpenXPKI-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-devel
