uamuzibora / nafasi

Uamuzi Bora on OpenMRS 1.9.
1 stars 0 forks source link

Performance tune MySQL #53

Closed andrewlkho closed 11 years ago

andrewlkho commented 12 years ago

From Kenrick:

Further, in our deployment checklist, I need something about MySQL InnoDB tuning, including setting a sensible innodb_buffer_pool_size in /etc/my.cnf to optimise our db queries.

kenners commented 12 years ago

Not done during July 2012 visit.

This needs to be rescheduled for Autumn 2012 visit (maybe by @Gulfa?), and will likely be better once OpenMRS has actually been used for a bit so we have some analytics on db load/performance.

Also: mysqltuner.pl looks promising.

andrewlkho commented 11 years ago

This issue has been split into multiple issues in the kasha repository with the mysql tag.