https://community.developer.cybersource.com/t5/Integration-and-Testing/Is-it-possible-to-handle-1000-concurrent-while-having-low-cpu/m-p/69473#M42483 <P class="_1qeIAgB0cPwnLhDF9XSiJM">We're running Centos 7, we're in the process Mariadb 5.5, upgrading to 10.3 today. PHP 5.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The queries are bad, and there are far too many of them to optimize, but I'm trying what I can, the database structure is bad.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The client doesn't care about query optimization, he just wants to lower CPU usage, he runs<SPAN>&nbsp;</SPAN><A href="https://locust.io/" target="_blank" rel="noopener noreferrer">locust</A>, a load testing tool, give it 1500 users and 1000 concurrent, sees the CPU at in the 90s % and says this is bad. The search functionality is the problem he said.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Again I'm telling you, the queries are bad, I just got hired and doing what I can, but is he looking at the right metrics?</P> Tue, 22 Oct 2019 09:47:15 GMT JenrasGomes 2019-10-22T09:47:15Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Is-it-possible-to-handle-1000-concurrent-while-having-low-cpu/m-p/69473#M42483 <P class="_1qeIAgB0cPwnLhDF9XSiJM">We're running Centos 7, we're in the process Mariadb 5.5, upgrading to 10.3 today. PHP 5.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The queries are bad, and there are far too many of them to optimize, but I'm trying what I can, the database structure is bad.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">The client doesn't care about query optimization, he just wants to lower CPU usage, he runs<SPAN>&nbsp;</SPAN><A href="https://locust.io/" target="_blank" rel="noopener noreferrer">locust</A>, a load testing tool, give it 1500 users and 1000 concurrent, sees the CPU at in the 90s % and says this is bad. The search functionality is the problem he said.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Again I'm telling you, the queries are bad, I just got hired and doing what I can, but is he looking at the right metrics?</P> Tue, 22 Oct 2019 09:47:15 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Is-it-possible-to-handle-1000-concurrent-while-having-low-cpu/m-p/69473#M42483 JenrasGomes 2019-10-22T09:47:15Z