High CPU-load caused by two sqlite3-processes

[vpx23]

Is there a reason you set the KVM CPU model to "SandyBridge" and not "IvyBridge", "kvm64" or "host"?

Sandy Bridge would be the E3-1240 v1. E3-1240 v2 is Ivy Bridge.

https://ark.intel.com/content/www/us/en/ark/products/52273/intel-xeon-processor-e3-1240-8m-cache-3-30-ghz.html
https://ark.intel.com/content/www/us/en/ark/products/65730/intel-xeon-processor-e3-1240-v2-8m-cache-3-40-ghz.html

[s4rs]

Both the bad and good systems are set to host. Pictures attached

[vpx23]

Oh, I didn't see that this thread was that old and was talking to the OP.

But did you try to turn off NUMA on the first machine?

A member in the Proxmox forum said this could actually cost performance on a single socket board.

https://forum.proxmox.com/threads/numa-1-on-single-socket-systems.136935/

[s4rs]

I've tried it off and on, no difference. I can turn it off.

[vpx23]

Is "Intel Virtualization Technology" (VT-x) activated in the X99 BIOS?

[s4rs]

Yes, CPUINFO flages

Code Select Expand


flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf pni pclmulqdq dtes64 ds_cpl vmx smx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm cpuid_fault epb invpcid_single pti intel_ppin ssbd ibrs ibpb stibp tpr_shadow flexpriority ept vpid ept_ad fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid cqm xsaveopt cqm_llc cqm_occup_llc dtherm ida arat pln pts vnmi md_clear flush_l1d
vmx flags       : vnmi preemption_timer posted_intr invvpid ept_x_only ept_ad ept_1gb flexpriority apicv tsc_offset vtpr mtf vapic ept vpid unrestricted_guest vapic_reg vid ple shadow_vmcs