<HTML><BODY><p class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">Please help increase performance of OpenCMS site.</span></p><p class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">After production we have problems with performance of the site. The problem is that it takes about 7 seconds to load the page. Most time (about 6 seconds) it takes to load html. Less than 1 second it takes to load other resources (images…).</span></p><p class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">Parameters of our system:<br> Database: 350 Gb<br> RAM: 40 Gb<br> CPU: 8 cores 2,4 GHz<br> File system: ZFS<br> MySQL: 5.7.22<br> Java Oracle JDK 8<br> Ubuntu 16.0.4<br> Tomcat 9<br> Apache 2</span></p><p class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">For monitoring we use MySQL Workbench and Atop. Load of CPUs is about 50%, JVM takes 19Gb of RAM, 20Gb of RAM takes MySQL. Traffic of inner interfa</span><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif;" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif;">с</span><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">e is about 250Mbs.</span></p><p class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">Amount of queries to database is about 17000 per second!!!</span></p><p class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">We use static export for images and some pages. It takes about 0.5 second to load exported page. But we use static export not for all pages. We don’t use it for dynamic content and detail pages. We also use flex-cache. But still pages with detailed pages load about 7 seconds.</span></p><p class="MsoNormal"><span style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;" lang="EN-US" data-mce-style="font-size: 12.0pt; line-height: 107%; font-family: 'Times New Roman',serif; mso-ansi-language: EN-US;">What’s wrong with our system? Why the amount of queries to database is so large? How can we increase performance of the site?</span><br><br><br></p></BODY></HTML>