[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Help needed: MySQL performance in DomU


  • To: xen-users <xen-users@xxxxxxxxxxxxxxxxxxxx>
  • From: Jan Kellermann <jan.kellermann@xxxxxxxxx>
  • Date: Wed, 15 May 2024 14:02:01 +0200
  • Authentication-results: mx.werk21system.de (amavisd-new); dkim=pass (1024-bit key) header.d=werk21.de
  • Autocrypt: addr=jan.kellermann@xxxxxxxxx; keydata= xsDiBEb1xVcRBACYk9W3MXo1Na9ghYrBd7dqayiGILhyowQXLd3N5+fMm8h25OSZ4kqfwHPA m8KL+Tk5YUQmQ5C1ozye2RUxi9THLvIQ4+4U7LBfI8bjmyBilZ/rw5R0oTJte6qEDhjpCpjl yKAQhfv4FA6E42JMS0PoxW5aJaZawo8e6cR4NoIStwCg22RWWqOYg4ijokbzl8xT0/RKUQUD /Rg60qgt49dvGkDMweS87XtyZc3Lt0UKimAmP+VDOqgHmvtKrz859yXNwN2jqU5tvQjtlihm ViSrQKOvsZl5k7AsCpp0dW3sFZ66JNZRATxGIFTIm8OC7dKB86pFiUsqPCyHDPKeW74htlSR pXvtHbQPpnxnv/NIpQEOQw/CCt5gA/9VsT2G1jPevwuV+g2Dvm8RsHGdzwd/GQi34KHLoeqQ V3eb0Kr9dH9akjOWaXkwISopI8FH4HESFT9xnIbfkAGXdAfC+IA93fUOjiSzHkc6QyAjWCkT t4r3mhpMW/MF/du568Oq36PwXHzqXIFRt/yzpnnIyPo/loMEcciNT8PRO80pSmFuIEtlbGxl cm1hbm4gPGphbi5rZWxsZXJtYW5uQHdlcmsyMS5kZT7CXwQTEQIAHwIbIwYLCQgHAwIEFQII AwMWAgECHgECF4AFAk2Zs9oACgkQ2wzRfLYwaZ2p2ACeNIvearGv7vsbcb5ZU4JKwtVX2AcA n2CCDi5DTIqz2mJ993ESkaGlNbKuzsBNBEb1xVcQBACK6hVh/KMgN2EGVU44JKia3jeYV16v zAL2wn8ZUlBjW/R+ACm4kvqjDMCLZcl7edXtLJDELSpYe7GWhnj6uQx6+5ebT2OVZOPvoahn zHhhs4XCQTHvj3OUW1JQwI5YJJiEywl8LUrLrgJzgVi2Zk1791BeVG2hI2III1jrGvlD8wAD BgQAgaHxn11LmF0Jt21/a+R8i+GPaeYBjnzZ6J80+1h8nlQgb0LPg0y4HWT3PXksoIt0CAoT b4iZ1XJncu7FPwjyC2akGqzD0SvHawuvXbZZE7Jtz+zgjUYT0bRNGSYgEuFUMY6fAbyF/tM1 TcXtBLSHHwhmWgBMU07yAAJPm/UWgwDCSQQYEQIACQUCRvXFVwIbDAAKCRDbDNF8tjBpnV40 AJ4tvhqBXoo7jr8h/lsxTFnYZdD85gCgi6limeJh6OULVDJKvWDNVeooZyc=
  • Delivery-date: Wed, 15 May 2024 12:02:29 +0000
  • List-id: Xen user discussion <xen-users.lists.xenproject.org>

Dear colleagues,

we are using Xen since many years and run dozens of stable systems with it. We use Ubuntu LTS and a self-compiled version, currently 4.18.

Now we have new servers with Xeon Gold 5412U and the speed in DomU is very slow, especially noticeable with MySQL queries. Compared to other DomUs (with older CPUs) or the same barebone server, the SQL queries take 7x longer - this is not acceptable. We use Ubuntu 22.04 with the HWE kernel 6.5. We work with PVH.

We have already tried a few things (CPU scheduler, various MySQL settings or PV). It's not IO (database completely in memory, no IO visible). sysbench delivers significantly slower values for memory than on the Dom0: 202.99 MiB/sec (DomU PV) vs. 1962.36 MiB/sec (DomU PVH) vs. 7379.87 MiB/sec (Dom0).

Do you have similar experiences with MySQL or ideas for further adjustments?

Best regards & thank you very much,
Jan Kellerman



 


Rackspace

Lists.xenproject.org is hosted with RackSpace, monitoring our
servers 24x7x365 and backed by RackSpace's Fanatical Support®.