Re: Server 8.0 is extremaly slow

[Eric Gendron]

Hi Peter, thanks for helping, here are my results

0.875 sec for the first query

MyISAM 3.89 GB 0.13 GB 4.02 GB
InnoDB 1.98 GB 0.18 GB 2.16 GB
CSV 0.00 GB 0.00 GB 0.00 GB
TOTALS 5.87 GB 0.31 GB 6.18 GB

total_allocated
342.33 MiB

memory/performance_schema 277.98 MiB
memory/innodb 44.53 MiB
memory/mysys 8.85 MiB
memory/sql 6.64 MiB
memory/temptable 4.00 MiB
memory/myisam 182.31 KiB
memory/mysqld_openssl 156.54 KiB
memory/csv 10.04 KiB
memory/mysqlx 2.87 KiB
memory/vio 1.20 KiB
memory/blackhole 312 bytes


bufferpoolfullpct
55.27%

Sorry I'm not sure what to do for the runaway memory

OS Name: Microsoft Windows 10 Enterprise
OS Version: 10.0.17763 N/A Build 17763
OS Manufacturer: Microsoft Corporation
OS Configuration: Member Workstation
OS Build Type: Multiprocessor Free
Registered Owner:
Registered Organization:
Product ID: 0039-0000-0003-AA24
Original Install Date: 2019/12/04, 15:49:19
System Boot Time: 2019/12/12, 08:54:33
System Manufacturer: Dell Inc.
System Model: OptiPlex 5070
System Type: x64-based PC
Processor(s): 1 Processor(s) Installed.
[01]: Intel64 Family 6 Model 158 Stepping 13 GenuineIntel ~1992 Mhz
BIOS Version: Dell Inc. 1.0.3, 2019/05/30
Windows Directory: C:\WINDOWS
System Directory: C:\WINDOWS\system32
Boot Device: \Device\HarddiskVolume2
System Locale: en-us;English (United States)
Input Locale: en-us;English (United States)
Time Zone: (UTC-05:00) Eastern Time (US & Canada)
Total Physical Memory: 16,162 MB
Available Physical Memory: 10,776 MB
Virtual Memory: Max Size: 18,594 MB
Virtual Memory: Available: 12,925 MB
Virtual Memory: In Use: 5,669 MB
Page File Location(s): C:\pagefile.sys
Domain:
Logon Server: N/A
Hotfix(s): 6 Hotfix(s) Installed.
[01]: KB4519565
[02]: KB4465065
[03]: KB4486153
[04]: KB4516115
[05]: KB4523204
[06]: KB4523205
Network Card(s): 1 NIC(s) Installed.
[01]: Intel(R) Ethernet Connection (7) I219-V
Connection Name: Ethernet
DHCP Enabled: Yes
DHCP Server:
IP address(es)
[01]:
[02]:
Hyper-V Requirements: A hypervisor has been detected. Features required for Hyper-V will not be displayed.


Let me know if you need more

Thank you so much
Eric