Hi Albert, We're just checking this in our Labs as we might have faced similar behaviour with XEN virtual machine.
One comment from our thread: "Our testing has shown that using storage with high I/O bandwith is mandatory, setting Linux kernel boot parameter "notsc" seems to be required for Sles10." Perhaps this is already a hint. Best regards Jörg Jörg Hoffmeister Development Manager MaxDB & liveCache SAP AG Rosenthaler Str. 30 10178 Berlin T +49 30 41092-356 F +49 30 41092-419 mailto:[EMAIL PROTECTED] www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher / Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. www.sdn.sap.com/irj/sdn/maxdb -----Original Message----- From: Beermann, Albert [mailto:[EMAIL PROTECTED] Sent: Dienstag, 10. April 2007 10:32 To: maxdb@lists.mysql.com Subject: MAXDB on a virtuell server under VWWARE 3.01 ??? Hello Everybody! We have a hp server with 2 dual core cpus and 16 giga memory We use VMWARE ESX server 3.01 on this server We use a maxdb 7.6.0034 database on an virtuell SLES-10 64 bit Linux server(2 cpus, 8 giga memory). The linux system is the only virtuell server on the maschine ! Our database parameters: 8 giga data, 4.5 giga cache, maxusertasks 500, maxcpu 2 Our application connects to the database via ODBC. During testing and training with 50 users everything works. We started the produktion database on 1.4.2007 with about 300 users and run into a performance disaster. We found, that load balancing seems not to work on the virtuell server. CPU one 100 percent most of the time, cpu two between 3 and 8 percent ???? Data cache hit rate 100 % !! 400 users go crazy and forced us to build a new server. Same hardware, same database, same database parameters, same linux , no vwware ! Now load balancing seems to work. The linux system shows 4 cpus with a load between 4 and 30 percent. Performance is OK ! Has anyone experiences with using a maxdb database on a virtuell server ??? Is there a known problem with load balancing? Is there a reason, why cpu one is always 100 percent and cpu two does nearly nothing? Any help welcomed Best regards Albert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
