We are using in our product - SA 12.0.1.3873 on Linux (RedHat, CentOS). Recently move from OS version 5.8 to OS version 6.4. During DB start appears follow warning -
There are ways to make transparent hugepage support(THP) disable and prevent this warning ( change files /sys/kernel/mm/redhat_transparent_hugepage/enabled and /sys/kernel/mm/transparent_hugepage/defrag). Question - Should be this warning handled to prevent DB performance problem or this warning don't have influence on DB perfomance? Thanks, HBrener |
There is a bug in the Linux support for THP that causes Direct I/Os to be dropped and we have seen that this (obviously) leads to database corruption. Hence SQL Anywhere detects the situation, disables the use of Direct I/O, and issues the warning. When SQL Anywhere is not using Direct I/O it must issue an fsync call each time that it must guarantee that the written data (in a previous write request) has hit the disk and not just buffered by the OS in memory. Using Direct I/O is generally faster and performs better than using fsync but the exact performance impact on your application will depend on the update frequency of your application. |