mariadb – MySQL High Load CPU

I have problem with MariaDB , when connect analytics ~ 200
mysql started to appear 132% load and pushed the main CPU to about 40%. Making the website extremely slow
I’m using centos 7 ( 8GB ram , 2 core , NVME SSD + Nginx + php-fpm )

(client)
#password   = your_password
port        = 3306
socket      = /var/lib/mysql/mysql.sock

(mysqld)
wait_timeout=300
interactive_timeout = 300
binlog_cache_size = 128K
thread_stack = 256K
join_buffer_size = 2048K
query_cache_type = 1
max_heap_table_size = 512M
port        = 3306
socket      = /var/lib/mysql/mysql.sock
datadir = /var/lib/mysql
default_storage_engine = InnoDB
performance_schema_max_table_instances = 400
table_definition_cache = 400
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 100G
table_open_cache = 384
sort_buffer_size = 1024K
net_buffer_length = 4K
read_buffer_size = 1024K
read_rnd_buffer_size = 768K
myisam_sort_buffer_size = 16M
thread_cache_size = 128
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 8M
tmp_table_size = 512M
#sql-mode=NO_ENGINE_SUBSTITUTION

#skip-name-resolve
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535

log-bin=mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days = 10
slow_query_log=1
slow-query-log-file=/home/abc.com.com/logs/mysql-slow.log
long_query_time=3
#log_queries_not_using_indexes=on


innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
innodb_buffer_pool_size = 1G
innodb_log_file_size = 128M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_max_dirty_pages_pct = 90
innodb_read_io_threads = 2
innodb_write_io_threads = 2
innodb_buffer_pool_instances = 1


(mysqldump)
quick
max_allowed_packet = 500M

(mysql)
no-auto-rehash

(myisamchk)
key_buffer_size = 64M
sort_buffer_size = 1M
read_buffer = 2M
write_buffer = 2M

(mysqlhotcopy)
interactive-timeout

And tunning via mysqltuner

-------- Storage Engine Statistics -----------------------------------------------------------------
(--) Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA
(--) Data in InnoDB tables: 48.8M (Tables: 21)
(OK) Total fragmented tables: 0

-------- Analysis Performance Metrics --------------------------------------------------------------
(--) innodb_stats_on_metadata: OFF
(OK) No stat updates during querying INFORMATION_SCHEMA.

-------- Security Recommendations ------------------------------------------------------------------
(OK) There are no anonymous accounts for any database users
(OK) All database users have passwords assigned
(!!) There is no basic password file list!

-------- CVE Security Recommendations --------------------------------------------------------------
(--) Skipped due to --cvefile option undefined

-------- Performance Metrics -----------------------------------------------------------------------
(--) Up for: 8m 0s (85K q (178.621 qps), 6K conn, TX: 41M, RX: 7M)
(--) Reads / Writes: 98% / 2%
(--) Binary logging is enabled (GTID MODE: ON)
(--) Physical Memory     : 7.6G
(--) Max MySQL memory    : 504.5G
(--) Other process memory: 0B
(--) Total buffers: 2.0G global + 1.0G per thread (500 max threads)
(--) P_S Max memory usage: 0B
(--) Galera GCache Max memory usage: 0B
(!!) Maximum reached memory usage: 95.5G (1250.25% of installed RAM)
(!!) Maximum possible memory usage: 504.5G (6604.94% of installed RAM)
(!!) Overall possible memory usage with other process exceeded memory
(OK) Slow queries: 0% (0/85K)
(OK) Highest usage of available connections: 18% (93/500)
(OK) Aborted connections: 0.04%  (3/6727)
(!!) name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
(OK) Query cache is disabled by default due to mutex contention on multiprocessor machines.
(OK) Sorts requiring temporary tables: 0% (0 temp sorts / 700 sorts)
(OK) No joins without indexes
(!!) Temporary tables created on disk: 88% (5K on disk / 6K total)
(OK) Thread cache hit rate: 98% (93 created / 6K connections)
(OK) Table cache hit rate: 215% (114 open / 53 opened)
(OK) table_definition_cache(400) is upper than number of tables(261)
(OK) Open file limit used: 0% (29/65K)
(OK) Table locks acquired immediately: 100% (65K immediate / 65K locks)
(OK) Binlog cache memory access: 100.00% (1144 Memory / 1144 Total)

-------- Performance schema ------------------------------------------------------------------------
(--) Performance schema is disabled.
(--) Memory used by P_S: 0B

-------- ThreadPool Metrics ------------------------------------------------------------------------
(--) ThreadPool stat is enabled.
(--) Thread Pool Size: 2 thread(s).
(--) Using default value is good enough for your version (10.0.38-MariaDB)

-------- MyISAM Metrics ----------------------------------------------------------------------------
(!!) Key buffer used: 18.7% (75M used / 402M cache)
(OK) Key buffer size / total MyISAM indexes: 384.0M/123.0K
(OK) Read Key buffer hit rate: 99.7% (355 cached / 1 reads)
(OK) Write Key buffer hit rate: 100.0% (96 cached / 96 writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
(--) InnoDB is enabled.
(--) InnoDB Thread Concurrency: 0
(OK) InnoDB File per table is activated
(OK) InnoDB buffer pool / data size: 1.0G/48.8M
(OK) Ratio InnoDB log file size / InnoDB Buffer pool size: 128.0M * 2/1.0G should be equal to 25%
(OK) InnoDB buffer pool instances: 1
(--) InnoDB Buffer Pool Chunk Size not used or defined in your version
(OK) InnoDB Read buffer efficiency: 100.00% (422760044 hits/ 422761190 total)
(!!) InnoDB Write Log efficiency: 46.23% (484 hits/ 1047 total)
(OK) InnoDB log waits: 0.00% (0 waits / 1531 writes)

-------- Aria Metrics ------------------------------------------------------------------------------
(--) Aria Storage Engine is enabled.
(OK) Aria pagecache size / total Aria indexes: 128.0M/0B
(OK) Aria pagecache hit rate: 98.6% (146 cached / 2 reads)

-------- TokuDB Metrics ----------------------------------------------------------------------------
(--) TokuDB is disabled.

-------- XtraDB Metrics ----------------------------------------------------------------------------
(--) XtraDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
(--) Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
(--) Galera Synchronous replication: NO
(--) No replication slave(s) for this server.
(--) Binlog format: MIXED
(--) XA support enabled: ON
(--) Semi synchronous replication Master: Not Activated
(--) Semi synchronous replication Slave: Not Activated
(--) This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /var/lib/mysql/dichvu.err file
    Control error line(s) into /var/lib/mysql/dichvu.err file
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Reduce your overall MySQL memory footprint for system stability
    Dedicate this server to your database for highest performance.
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    Temporary table size is already large - reduce result set size
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Performance schema should be activated for better diagnostics
    Performance schema shouldn't be activated for MariaDB 10.0 for performance issue
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    performance_schema = ON enable PFS
    performance_schema = OFF disable PFS

Please give me advice in this case

Free -m when cpu load high

              total        used        free      shared  buff/cache   available
Mem:           7821        1421        4755         431        1644        5715
Swap:          1023           0        1023

rendering – Why do games run slow on CPU

Maybe my question sounds naive because I’m not a game developer but I dont see objective reasons for this.
An average cpu is in times more powerful than an average gpu like a few graphics cards in one.

The most repeated reasons in internet:

the GPU isn’t as busy as the CPU

If the gpu renders the screen how it can not be busy
The modern cpus are powerful enough. They are not busy most of time. For example my cpu’s usage is 3%.

many GPU’s are designed to process graphics commands in parallel, CPU single threads them

What bothers the games to run a few parallel processes even on one cpu core?
In my opinion its not correct to tell that the gpu is better if games never use 100% of the cpu’s capacity. To be specific they dont use even 50%.

How to know how much RAM & CPU my script reqire?

as the title, how to know? is task manager the best way as my friend told me?
I code in python..

I’m new here sorry if my question was in the wrong place.

SERVER DEALS @40% OFF 4 LIFE 16GB+ RAM – 4/8 Cores+ CPU – SSD/SATA 3, 100TB B/W @1GBit | NewProxyLists

SPECIAL DEDICATED SERVER DEALS 2021!!! 40% DISCOUNTS ON ALL DEDICATED SERVERS VALID TILL STOCKS LAST!!

SSD Cloud announces the SPECIAL DEDICATED SERVER DEALS 2021! on our Self Managed Dedicated Servers and Managed Dedicated Server Hosting. Are you looking for high performance business-ready server? Need big RAM for your or customer’s hungry applications? Require a network with actual real working performance? Need high storage server for offsite backup services? Your search would be stop here with the below given High Performance Dedicated Servers at very affordable price and quality support.

About SSD CLOUD!
SSD CLOUD is a US Based leader in Hosting industry, having been in this industry since 2013. SSD CLOUD is a full-service technology solutions provider, providing you with Web Hosting, Reseller Hosting, SSD Cloud Server, Self-Managed VPS, Managed cPanel VPS and High-Performance Dedicated Servers. We offer affordable, flexible and reliable services! It’s a name that you will grow with and learn to trust for all of your hosting solutions.

Why to Choose Us?
We provide affordable, reliable and high-performance hosting services to the people around the world. We offer high quality services at very reasonable rate which help to lead your business for online success. We maintain a stable hosting environment, serving clients with dedicated team for technical and sales/billing support.

HURRY UP! Right Now Grab this offer for your Personal or Business use, Before the EXCLUSIVE SALES OFFER Expires!
Our Special Promotions are only for the very limited time and stocks. So, place your order right now and grab the high-quality hosting at the very reasonable price.

Our Features:
• 24×7 Security and Multi-level Access Control
• Power Protection by UPS (N+4) and 2MW Backup Generator
• Bandwidth provided by major Tier 1 carriers
• Connectivity provided by 7 diverse fiber operators
• Strict Climate Control with Liebert CRAH Units & Chilled Water Cooling
• Fire Detection & Suppression Systems

Use Below Given Coupon Codes to Receive Up To 40% Recurring Discounts on All Dedicated Server Plans!

40% RECURRING DISCOUNTS ON ANNUAL BILLING TERM with Coupon Code “SSDCLOUD40

15% RECURRING DISCOUNTS ON ANY BILLING TERM with Coupon Code “SSDCLOUD15

♥ ♥ ♥ ♥ ♥ SPECIAL DEDICATED SERVER DEALS 2021 VALID TILL STOCKS LAST WITH THE ABOVE GIVEN COUPON CODES. ♥ ♥ ♥ ♥ ♥

▐▌▐▌ Dual Intel Xeon 5420

* CPU: 2.5 Ghz x 2 CPU: 8 Cores + 8 Threads
* Port Speed: 1 Gbps Dedicated Port
* Premium Bandwidth: 100TB Monthly Transfer
* Memory: 16GB DDR3 ECC RAM
* Primary Hard Drive: 2 TB SATA or 240GB SSD
* Operating System: Linux/Windows*
* Free IPs: 5 Usable IPv4 (/29) / IPv6: /64
* 24×7 (5 minute interval) Server Monitoring
* Server Management: Included (Silver Managed: $49/m value)
* Control Panel: Included (Free cPanel/WHM: $45/m value)
* 100% Up-Time: Network, Power and Cooling
* DC Location : MO, US
Monthly Price: $199/m Now Only $119/m | OR | Self Managed Server @ $63/m only | Setup Fee ($49): Waived!

ORDER NOW – Dual Intel Xeon 5420

▐▌▐▌ Dual Intel Xeon 5520

* CPU: 2.26 Ghz x 2 CPU : (8 Cores + 16 Threads)
* Port Speed: 1 Gbit Dedicated Port
* Premium Bandwidth: 100TB Monthly Transfer
* Memory: 24GB DDR3 ECC RAM
* Primary Hard Drive: 3TB SATA or 240GB SSD
* Operating System: Linux/Windows*
* Free IPs: 5 Usable IPv4 (/29) / IPv6: /64
* 24×7 (5 minute interval) Server Monitoring
* Server Management: Included (Silver Managed: $49/m value)
* Control Panel: Included (Free cPanel/WHM: $45/m value)
* 100% Up-Time: Network, Power and Cooling
* DC Location : MO, US
Monthly Price: $249.95/m Now Only $149/m | OR | Self Managed Server @ $93/m only | Setup Fee ($49): Waived!

ORDER NOW – Dual Intel Xeon 5520

▐▌▐▌ Intel Xeon E3-1230v2

* CPU: 2 Processors – 3.2Ghz (4 Cores + 8 Threads)
* Port Speed: 1Gbit Dedicated Port
* Premium Bandwidth: 100TB Monthly Transfer
* Memory: 32GB DDR3 ECC RAM
* Primary Hard Drive: 2 x 2TB SATA3 or 2 x 240GB SSD
* Operating System: Linux/Windows*
* Free IPs: 5 Usable IPv4 (/29) / IPv6: /64
* 24×7 (5 minute interval) Server Monitoring
* Server Management: Included (Silver Managed: $49/m value)
* Control Panel: Included (Free cPanel/WHM: $45/m value)
* 100% Up-Time: Network, Power and Cooling
* DC Location : MO, US
Monthly Price: $299.9/m Now Only $179/m | OR | Self Managed Server @ $123/m only Setup Fee ($49): Waived!

ORDER NOW – Intel Xeon E3-1230v2

▐▌▐▌ Dual Intel Xeon 5639

* CPU: 2.13Ghz – 2 Processors (12 Cores + 24 Threads)
* Port Speed: 1Gbit Dedicated Port
* Premium Bandwidth: 100TB Monthly Transfer
* Memory: 32GB DDR3 ECC RAM
* Primary Hard Drive: 4TB SATA or 480GB SSD
* Operating System: Linux/Windows*
* Free IPs: 5 Usable IPv4 (/29) / IPv6: /64
* 24×7 (5 minute interval) Server Monitoring
* Server Management: Included (Silver Managed: $49/m value)
* Control Panel: Included (Free cPanel/WHM: $45/m value)
* 100% Up-Time: Network, Power and Cooling
* DC Location : MO, US
Monthly Price: $339.9/m Now Only $204/m | OR | Self Managed Server @ $147/m only | Setup Fee ($49): Waived!

ORDER NOW – Dual Intel Xeon 5650

▐▌▐▌ Dual Intel Xeon E5-2670v2

* CPU: 2 Processors – 2.5Ghz / 3.3Ghz Turbo: 20 cores / 40 Threads
* Port Speed: 1Gbit Dedicated Port
* Premium Bandwidth: 100TB Monthly Transfer
* Memory: 96GB DDR3 ECC RAM
* Primary Hard Drive: 2 x 480GB SSD
* Operating System: Linux/Windows*
* Free IPs: 5 Usable IPv4 (/29) / IPv6: /64
* 24×7 (5 minute interval) Server Monitoring
* Server Management: Included (Silver Managed: $49/m value)
* Control Panel: Included (Free cPanel/WHM: $45/m value)
* 100% Up-Time: Network, Power and Cooling
* DC Location : MO, US
Monthly Price: $399.98/m Now Only $240/m | OR | Self Managed Server @ $183/m only | Setup Fee ($49): Waived!

ORDER NOW – Dual Intel Xeon E5-2670v2

Frequently Asked Questions:

1. Where are your DC located?
Our DC is located at MO, US.

2. Which payment method you are accepting?
We are accepting payment via PayPal, PayZa, Skrill, Bitcoin, Debit/Credit Cards.

3. How long it will take to setup a server?
All custom server will be setup in 1-2 Business Days.

P.S:* Above reflected offer price is showing after discount with annual billing term by using coupon code “SSDCLOUD40”.
If you have any questions please feel free to contact us. Visit our website for more information about DEDICATED SERVER HOSTING

linux – Ubuntu does not boot without -cpu host, but boots fine with it

qemu-6.0.0

I’m running some experiments with QEMU/KVM and faced some strange behavior. My Ubuntu 20.04 system installed on a VM does not boot if it is used as follows:

$ sudo qemu-system-x86_64 -enable-kvm -boot d -m 8192 ubuntu.img

It simply hangs with a black screen:

enter image description here

But if try to start the VM with -cpu host option it works perfectly fine:

$ sudo qemu-system-x86_64 -cpu host -enable-kvm -boot d -m 8192 ubuntu.img

Any ideas why such behavior might happen? May it happen due to the fact that I installed Ubuntu when the VM was ran with -cpu host option?

windows – Using only 50% of CPU in Acer one 14 Z422

enter image description here

The above image did not take while running CPU-hungry applications.

I am using Acer one 14 Z422. I installed Windows 10 pro. Updated to 21H1 update and installed all optional updates. The base frequency of the processor is 2Ghz. But it only utilizes 50% of cpu eve if I running CPU hungry applications. Overall system performance is too low. How can I fix it?

I tried most of the google result advice.

mac pro – trustd process v high CPU usage and slooow boot up – OSX 10.13.6

My machine used to fly through booting up but since last week it’s very sluggish and once I finally log in, three instances of trustd are operating at a very high capacity for 5 minutes or so. After that everything is fine and runs smoothly and quietly.

I can’t recall of anything I did that caused the sudden change.

I have tried deleting and resetting the default keychain
Repairing disk permissions using the terminal.
First aid on the startup disk using disk utility
Booting in recovery mode and using first aid on startup disk using disk utility (this made the problem significantly worse. It would take 2/3 minutes to boot before, now 5+)
Deleting valid.sqlite3 file from library/keychains/crls
Removing nsurlsessiond (scraping the barrel here)

Is there a way to see the log of what trustd is doing during startup (and more importantly what it’s having problems with ) that’s making it run so hot?

Mac Pro early 2008
10.13.6 (running on unsupported hardware)
22GB RAM
2x 2.8 GHz intel xeon

Activity Monitor Screenshot

trustd Open Files And Ports

kubernetes – Can I have multiple threads running in parallel in a pod with a CPU limit set to 500 millicores?

I have a multi cores Kubernetes cluster, inside it I have a pod configured with a CPU limit of 500 millicores:

        resources:
          limits:
            cpu: "500m"

It is possible to have more than one threads running in parallel (simultaneously, at the same exact moment)?

From my understanding when the limit is less than 1000 millicores the pod can never have multiple threads running in parallel. Is it correct?

Is it normal for my CPU to appear locked at 4.68 GHz when its base speed shows 3.6 GHz?

No games or anything significant is running on my PC. I noticed this and it just seems really weird, it seems to be locked a 4.68GHz:

enter image description here

I’m wondering if maybe I overclocked it and forgot. I’m pretty naïve as far as far as hardware goes. Does this really mean its running at 4.68GHz constantly, or am I misunderstanding the UI?

Bulk Cheap Dedicated Servers CPU Mining (E5 V2 & above)

I think the title is pretty much clear.

Need Bulk & Cheap Dedicated Servers for CPU mining. Looking for Dual E5 v2, v3 or above (Yes, old… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1847739&goto=newpost