Calem uses MySQL as its database. For customers using Calem Cloud Services the database tuning is handled by the Calem Support Team. Using MySQLTuner to set optimal settings of MySQL helps handle larger data sets and prevents Calem from slowdown.
For customers with on-premise deployment of Calem the database turning may be performed every six month or every year when the one of the following condition is observed:
- Data screens operations take long time. The operations include screen opening, data search, and data editing.
- There are warnings of database operations in the Calem log (Calem_Home/logs/calem.log) that take too long. For instance, the following warnings indicate that database tuning may be necessary.
- You have a larger data set such as tens of thousands of assets, tens of thousands of inventory items, and many years of work order history using Calem.
MySQLTuner for Linux
Customers with Calem on-premise in Linux may use the guide from Linode to do MySQL tuning: https://www.linode.com/docs/databases/mysql/how-to-optimize-mysql-performance-using-mysqltuner/
MySQLTuner for Windows
Customers with Calem on-premise in Windows may use the GitHub site below to do MySQL tuning: https://github.com/pmachapman/mysqltuner/
Additional resources
- User Guide and Admin Guide (customer account required)
- Calem Enterprise Training Site
- Calem Enterprise Blogs
- Calem Enterprise demo