Does large amout of idle connections hurt performance of Mysql

We have applications that keep large amounts of idle connections (thoudsands). Does that hurt performance of the database? Is it worth it to lower the number idle connetions for performances sake?

python idle 3.9.4 autocomplete not working?

according to the python 3.9.4 documentation (https://docs.python.org/3/library/idle.html) there is the ability for autocomplete without any external/third-party extensions for python IDLE (the default/official python programming that you download when installing python). I am new to programming. How do I enable the autocomplete that is mentioned in the documentation.

Task Scheduler in Windows 7 always treats computer as idle

I have a weird issue with one of the default Windows tasks, namely Microsoft/Windows/AppID/VerifiedPublisherCertStoreCheck

Here are its default settings:

Triggers

At startup
Delay task for 30 minutes, repeat task every 1 day indefinitely.

Conditions

Start task if computer is idle for 3 minutes
Wait for idle for 23 hours
Stop if the computer ceases to be idle
Restart if the idle state resumes
Start the task only if the computer is on AC power
Stop if the computer switches to battery power

Settings

Allow task to be run on demand
Run task as soon as possible after a scheduled start is missed
Stop the task if it runs longer than 3 days
If the running task does not end when requested, force it to stop
If the task is already running then queue a new instance.

Actions

Start %windir%system32appidcertstorecheck.exe

As can be seen, it’s supposed to auto-restart every 1 day and also start if computer is idle for 3 minutes. However, for me, this task keeps starting every 3 minutes indefinitely despite the fact that I keep my activity for many hours straight. I specifically tested it: I kept moving the mouse, pressing buttons and doing something, and the task kept restarting every 3 minutes no matter what.

What can be the cause of this? How can I fix it? I’ve never changed the factory settings of this task, but it’s kind of obvious that it’s not the normal behavior.

kvm virtualization – Reducing idle CPU usage of Windows Server 2019 Datacenter Core VM

I’m moving a few installations to Windows Server Datacenter Core 2019 running in KVM VMs on Linux hosts.

My first Windows VM has, when it’s idle, a bit more than 32000 VM exits per second, half of them are MSR writes and the other half HLT instructions. For comparison, an idle Linux VM has around 20 per second each.

As the VM has 16 threads, I get some nice round numbers here: each CPU sets a timer and goes to sleep exactly 1000 times per second, so my suspicion (which may be wrong) is that there is a 1kHz timer on every CPU. That causes somewhere around 1-5% of load across all CPUs, and I’d like to reduce that.

Does that timer always exist on Windows, and if so, is there a setting to adjust it? If not, is there a tool to find out why Windows believes such a timer is needed?

Virtual hardware is virtio-net and viostor, an EHCI USB controller with a HID tablet for the mouse interface, PS/2 keyboard and mouse and a QXL graphics card. I have exposed only HPET and Hyper-V timers, but it seems to make no difference if I also offer RTC and PIT:

<domain type='kvm'>
  <name>test-win2019</name>
  <uuid>56f23fbd-9173-4f8e-b63a-59b7eb667fc0</uuid>
  <memory unit='KiB'>16777216</memory>
  <currentMemory unit='KiB'>16777216</currentMemory>
  <memoryBacking>
    <hugepages/>
  </memoryBacking>
  <vcpu placement='static' cpuset='8-15,24-31'>16</vcpu>
  <numatune>
    <memory mode='strict' nodeset='1'/>
  </numatune>
  <os>
    <type arch='x86_64' machine='pc-q35-2.8'>hvm</type>
    <loader readonly='yes' secure='no' type='pflash'>/usr/share/OVMF/OVMF_CODE.fd</loader>
    <nvram template='/usr/share/OVMF/OVMF_VARS.fd'>/var/lib/libvirt/nvram/test-win2019_VARS.fd</nvram>
  </os>
  <features>
    <acpi/>
    <apic/>
    <hyperv>
      <relaxed state='on'/>
      <vapic state='on'/>
      <spinlocks state='on' retries='8191'/>
    </hyperv>
  </features>
  <cpu mode='custom' match='exact' check='full'>
    <model fallback='forbid'>Skylake-Client-IBRS</model>
    <vendor>Intel</vendor>
    <topology sockets='1' cores='8' threads='2'/>
    <feature policy='require' name='ss'/>
    <feature policy='require' name='hypervisor'/>
    <feature policy='require' name='tsc_adjust'/>
    <feature policy='require' name='umip'/>
    <feature policy='require' name='md-clear'/>
    <feature policy='require' name='ssbd'/>
    <feature policy='require' name='pdpe1gb'/>
    <feature policy='disable' name='mpx'/>
    <feature policy='disable' name='xsavec'/>
    <feature policy='disable' name='xgetbv1'/>
    <numa>
      <cell id='0' cpus='0-15' memory='16777216' unit='KiB'/>
    </numa>
  </cpu>
  <clock offset='localtime'>
    <timer name='hpet' present='yes'/>
    <timer name='hypervclock' present='yes'/>
  </clock>
  <on_poweroff>destroy</on_poweroff>
  <on_reboot>restart</on_reboot>
  <on_crash>restart</on_crash>
  <pm>
    <suspend-to-mem enabled='no'/>
    <suspend-to-disk enabled='no'/>
  </pm>
  <devices>
    <emulator>/usr/bin/kvm</emulator>
    <disk type='block' device='disk'>
      <driver name='qemu' type='raw' cache='none' io='native'/>
      <source dev='/dev/darine/test-win2019'/>
      <backingStore/>
      <target dev='vda' bus='virtio'/>
      <boot order='1'/>
      <alias name='virtio-disk0'/>
      <address type='pci' domain='0x0000' bus='0x00' slot='0x06' function='0x0'/>
    </disk>
    <disk type='file' device='cdrom'>
      <driver name='qemu' type='raw'/>
      <source file='/srv/WindowsServer2019.iso'/>
      <backingStore/>
      <target dev='sda' bus='sata'/>
      <readonly/>
      <boot order='2'/>
      <alias name='sata0-0-0'/>
      <address type='drive' controller='0' bus='0' target='0' unit='0'/>
    </disk>
    <disk type='file' device='cdrom'>
      <driver name='qemu' type='raw'/>
      <source file='/srv/virtio-win_amd64.iso'/>
      <backingStore/>
      <target dev='sdb' bus='sata'/>
      <readonly/>
      <alias name='sata0-0-1'/>
      <address type='drive' controller='0' bus='0' target='0' unit='1'/>
    </disk>
    <controller type='usb' index='0' model='ich9-ehci1'>
      <alias name='usb'/>
      <address type='pci' domain='0x0000' bus='0x02' slot='0x00' function='0x0'/>
    </controller>
    <controller type='pci' index='0' model='pcie-root'>
      <alias name='pcie.0'/>
    </controller>
    <controller type='pci' index='1' model='pcie-root-port'>
      <model name='pcie-root-port'/>
      <target chassis='1' port='0x8'/>
      <alias name='pci.1'/>
      <address type='pci' domain='0x0000' bus='0x00' slot='0x01' function='0x0' multifunction='on'/>
    </controller>
    <controller type='pci' index='2' model='pcie-root-port'>
      <model name='pcie-root-port'/>
      <target chassis='2' port='0x9'/>
      <alias name='pci.2'/>
      <address type='pci' domain='0x0000' bus='0x00' slot='0x01' function='0x1'/>
    </controller>
    <controller type='pci' index='3' model='pcie-root-port'>
      <model name='pcie-root-port'/>
      <target chassis='3' port='0xa'/>
      <alias name='pci.3'/>
      <address type='pci' domain='0x0000' bus='0x00' slot='0x01' function='0x2'/>
    </controller>
    <controller type='sata' index='0'>
      <alias name='ide'/>
      <address type='pci' domain='0x0000' bus='0x00' slot='0x1f' function='0x2'/>
    </controller>
    <interface type='network'>
      <mac address='52:54:00:1e:46:45'/>
      <source network='default' bridge='virbr0'/>
      <target dev='vnet3'/>
      <model type='virtio'/>
      <alias name='net0'/>
      <address type='pci' domain='0x0000' bus='0x01' slot='0x00' function='0x0'/>
    </interface>
    <input type='tablet' bus='usb'>
      <alias name='input0'/>
      <address type='usb' bus='0' port='1'/>
    </input>
    <input type='mouse' bus='ps2'>
      <alias name='input1'/>
    </input>
    <input type='keyboard' bus='ps2'>
      <alias name='input2'/>
    </input>
    <graphics type='vnc' port='5909' autoport='no' listen='127.0.0.1'>
      <listen type='address' address='127.0.0.1'/>
    </graphics>
    <video>
      <model type='qxl' ram='65536' vram='16384' vgamem='16384' heads='1' primary='yes'/>
      <alias name='video0'/>
      <address type='pci' domain='0x0000' bus='0x00' slot='0x02' function='0x0'/>
    </video>
    <memballoon model='none'/>
  </devices>
  <seclabel type='dynamic' model='apparmor' relabel='yes'>
    <label>libvirt-56f23fbd-9173-4f8e-b63a-59b7eb667fc0</label>
    <imagelabel>libvirt-56f23fbd-9173-4f8e-b63a-59b7eb667fc0</imagelabel>
  </seclabel>
  <seclabel type='dynamic' model='dac' relabel='yes'>
    <label>+64055:+64055</label>
    <imagelabel>+64055:+64055</imagelabel>
  </seclabel>
</domain>

programming languages – Python Intepreter and IDLE

I am learning Python and using the IDLE to write code (it comes preloaded with the Python installation).

Is the IDLE both a code editor AND the interactive interpreter (translating source into machine code)? We could write the source code with ANY editor so I believe the IDLE may be “connected” to the interpreter but is not the interpreter itself.

It is also possible to run Python code directly into the Windows command line console after typing “python” at the prompt. Does typing “python” launch the interpreter program from within the Windows cmd line? Is the interpreter using the Windows console as interface? Other programs don’t seem to do that…

Thank you for any clarification.

wordpress – Website seems idle before loading content

Well, your hosting company is partly correct. It’s important to understand that all text in WordPress is stored in a database. When you make a request, WP loads each active plugin and queries the database for both your content, and plugin properties/values. This requires multiple queries of your database, before WordPress then processes and assembles your webpage for delivery to the client. Each plugin has it’s own database queries, so unloading unnecessary plugins can significantly help.

Each plugin adds to the delay. A CDN helps alleviate this delay, by off loading image and static files to multiple servers, optimized and distributed for faster loading. A caching server, will take the requests after they are assembled from the database and store the “final” assembled content in memory so that the next time the page is called, it’s pulled directly from memory, rather than making a database query.

Now, what tools can you use to help?

I would highly suggest you look at the WP plugin Asset Cleanup and their tutorial. You can use the free version and probably speed your site up substantially.

They have several videos of how to optimize your site using their plugin and other free tools that will help you optimize your site, and find javascript and CSS that is being downloaded, but not actually used.

They also have several excellent video tutorials, you can see an example here: https://youtu.be/ATXACFtcyKs and https://youtu.be/B8_QLVAgQiU.

Lenovo T490 shutdown at idle

I have a Lenovo T490 with Windows 10 (20H2 Build: 19042.685). I notice that if I leave it on for a while and when it tries to go into sleep mode, it will force shutdown by itself. Below is the event log.

Windows Event Log

I have tried updating all the Windows 10 updates, drivers (graphics, power etc) but still having the issue.

The only workaround is to disable the sleep setting.

Also, I noticed that if I shut the lid, it will go into sleep without shutting down.

AppleScript: Press "Q" every 1 second after idle for X amount of time in application "Roblox" [duplicate]

I am looking for a script that would press "Q" every second when idle for a certain amount of time in an application.

AppleScript: How do I have "q" Pressed in the Application "Roblox" when Idle

I want to have a script running that presses "q" when I’m idle in "Roblox" so I can watch anime and grind at the same time.

Is there non human risk related to idle sessions?

Let’s say the OS is Windows or Linux

As a System Admin, I think the answer to this question is : NO

I always configure end users machine for auto lockout for a given idle session time. Because I’m think, if the user leaves the machine without locking it, I should try something to at least protect my network

What if I did not do that ? Do you think there could be reasonable risk not related to a malicious person taking advantage of an idle session ?