Magento 2 disk space utilization very fast

Due to some reason my magento 2 website taking too much space from the server . Yesterday there is 1.2 gb available now only 240mb available . Please help on this .

The size of log folder is less , i am really confused its because of the cache file

performance – CPU utilization spikes from Windows services

A sudden problem occurred recently on a laptop with Windows 10. To sum up, I noticed that fans were speeding up and getting remarkably loud for short periods (about 10 to 15 seconds) and about a frequency of once every 5 minutes or so. After trying to pin down the problem, I checked the processor's performance while it was happening, and CPU utilization would increase from about 10% to 22-25% during these brief periods, especially because of the service. and the controller. App (if services.exe).

After trying to find the problem in Process Manager, I found that the address used was! RtlUserThreadStart, which, as I understand it, is a Windows function involved in thread initialization. Many of these applications are running, but there is still one that uses the processor specifically. Here is a screen shot at one of these spikes

With help from here and here, and using Windows Performance Analyzer, I created a log (screenshot) just when the problem arose, and it's obvious how much the use is simply increasing because of this unique process. But the trace of the pile is also difficult to follow. For example, I will leave a small excerpt here because it is extremely long.

I do not know what could be the cause of that. But if it's useful: I started noticing it after running a Windows unlock script. However, I'm not sure if this is the cause, because before, CPU usage increased much more often due to many other processes (Windows update, other services running in the background, etc.). . I just did not notice it because it was mixed with other processes. Plus, it's the first computer I've seen that had this problem after running the script, which makes me even more skeptical.

I would appreciate any help in trying to pin down the problem, I would also add any additional information that might be needed.

mysql – LOAD DATA maintains high CPU utilization after the end

I'm loading multiple files into the database using the LOAD DATA LOCAL INFILE combined command with Golang database/sql driver like this:

mysql.RegisterLocalFile(fileName)
_, err = dbConnection.Exec(loadDataCommand)

It works as expected once loading is complete, I run some SELECT queries (I reuse dbConnection for these SELECT queries and all other queries) on newly loaded data and this is where the problem occurs. The SELECT queries mentioned above are unusually slow (due to high CPU usage).

When running the LOAD DATA database, CPU usage is expected, but after the end of LOAD DATA, it should decrease, but not unless I close and reopen. dbConnection CPU utilization remains high.

Here's how I "reset" the connection to the database:

_ = dbConnection.Close()
dbConnection, err = sql.Open(databaseDriver, databaseUser+":"+databasePassword+"@tcp("+databaseAddress+":3306)/"+databaseName+"?multiStatements=true")

This is the configuration of the database.

Why does this happen? The code above runs on a development basis, so there are no other connections.

performance – MySQL 500% CPU utilization and server crashes

My dedicated server is a SATA XEON E3 hard drive 1240 V3 DDR3 1GB 8GB DDR3 (4 cores at 3.4 GHz), which I have only for a few days and that I just completed the migration of about 20 wordpress sites (each database of about 50 MB to 150 MB). in size). Mysqld has always used the processor more than 500% of its processor, which caused the blocking of the httpd service and prevented the loading of websites.

I have not yet changed the default my.cnf file, which looks like this:

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
(client-server)

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

(mysqld)
log-error=/var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err
performance-schema=0
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000

I have downloaded MySQLTuner – in the process of running perl mysqltuner.pl --host 127.0.0.1 refers to the following:

(--) Skipped version check for MySQLTuner script
(--) Performing tests on 127.0.0.1:3306
(OK) Currently running supported MySQL version 10.3.18-MariaDB
(OK) Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
(OK) Log file /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err exists
(--) Log file: /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err(32K)
(OK) Log file /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err is readable.
(OK) Log file /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err is not empty
(OK) Log file /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err is smaller than 32 Mb
(!!) /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err contains 57 warning(s).
(!!) /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err contains 12 error(s).
(--) 6 start(s) detected in /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err
(--) 1) 2019-10-11  1:13:04 0 (Note) /usr/sbin/mysqld: ready for connections.
(--) 2) 2019-10-09  6:41:42 0 (Note) /usr/sbin/mysqld: ready for connections.
(--) 3) 2019-10-09  6:41:39 0 (Note) /usr/sbin/mysqld: ready for connections.
(--) 4) 2019-10-09  6:41:34 0 (Note) /usr/sbin/mysqld: ready for connections.
(--) 5) 2019-10-09  6:40:48 140404223039680 (Note) /usr/sbin/mysqld: ready for connections.
(--) 6) 2019-10-09  6:40:39 140607405234368 (Note) /usr/sbin/mysqld: ready for connections.
(--) 5 shutdown(s) detected in /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err
(--) 1) 2019-10-11  1:09:43 0 (Note) /usr/sbin/mysqld: Shutdown complete
(--) 2) 2019-10-09  6:41:41 0 (Note) /usr/sbin/mysqld: Shutdown complete
(--) 3) 2019-10-09  6:41:39 0 (Note) /usr/sbin/mysqld: Shutdown complete
(--) 4) 2019-10-09  6:40:59 140404100704000 (Note) /usr/sbin/mysqld: Shutdown complete
(--) 5) 2019-10-09  6:40:48 140607307523840 (Note) /usr/sbin/mysqld: Shutdown complete

-------- Storage Engine Statistics -----------------------------------------------------------------
(--) Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
(--) Data in MyISAM tables: 791.8M (Tables: 738)
(--) Data in InnoDB tables: 672.0K (Tables: 36)
(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 are 620 basic passwords in the list.

-------- CVE Security Recommendations --------------------------------------------------------------
(OK) NO SECURITY CVE FOUND FOR YOUR VERSION

-------- Performance Metrics -----------------------------------------------------------------------
(--) Up for: 34m 29s (169K q (82.103 qps), 7K conn, TX: 1G, RX: 20M)
(--) Reads / Writes: 99% / 1%
(--) Binary logging is disabled
(--) Physical Memory     : 7.6G
(--) Max MySQL memory    : 856.4M
(--) Other process memory: 0B
(--) Total buffers: 417.0M global + 2.9M per thread (151 max threads)
(--) P_S Max memory usage: 0B
(--) Galera GCache Max memory usage: 0B
(OK) Maximum reached memory usage: 472.3M (6.07% of installed RAM)
(OK) Maximum possible memory usage: 856.4M (11.01% of installed RAM)
(OK) Overall possible memory usage with other process is compatible with memory available
(OK) Slow queries: 0% (14/169K)
(OK) Highest usage of available connections: 12% (19/151)
(OK) Aborted connections: 0.11%  (8/7083)
(!!) name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
(!!) Query cache may be disabled by default due to mutex contention.
(!!) Query cache efficiency: 0.0% (0 cached / 139K selects)
(OK) Query cache prunes per day: 0
(OK) Sorts requiring temporary tables: 0% (0 temp sorts / 34K sorts)
(!!) Joins performed without indexes: 4942
(!!) Temporary tables created on disk: 64% (6K on disk / 10K total)
(OK) Thread cache hit rate: 99% (19 created / 7K connections)
(OK) Table cache hit rate: 99% (920 open / 926 opened)
(!!) table_definition_cache(400) is lower than number of tables(1039)
(OK) Open file limit used: 15% (1K/10K)
(OK) Table locks acquired immediately: 100% (156K immediate / 156K locks)

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

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

-------- MyISAM Metrics ----------------------------------------------------------------------------
(!!) Key buffer used: 21.1% (28M used / 134M cache)
(OK) Key buffer size / total MyISAM indexes: 128.0M/34.2M
(OK) Read Key buffer hit rate: 100.0% (31M cached / 3K reads)
(!!) Write Key buffer hit rate: 85.9% (71 cached / 61 writes)

-------- InnoDB Metrics ----------------------------------------------------------------------------
(--) InnoDB is enabled.
(--) InnoDB Thread Concurrency: 0
(OK) InnoDB File per table is activated
(OK) InnoDB buffer pool / data size: 128.0M/672.0K
(!!) Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 48.0M * 2/128.0M should be equal to 25%
(OK) InnoDB buffer pool instances: 1
(--) Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s)
(OK) Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
(!!) InnoDB Read buffer efficiency: 80.51% (2569 hits/ 3191 total)
(!!) InnoDB Write Log efficiency: 0% (1 hits/ 0 total)
(OK) InnoDB log waits: 0.00% (0 waits / 1 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
(--) AriaDB is enabled.
(OK) Aria pagecache size / total Aria indexes: 128.0M/1B
(!!) Aria pagecache hit rate: 87.1% (50K cached / 6K 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: OFF
(--) Semi synchronous replication Slave: OFF
(--) This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err file
    Control error line(s) into /var/lib/mysql/server1.nc-ph-0741-26.web-hosting.com.err file
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
             See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
             (specially the conclusions at the bottom of the page).
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    Performance schema should be activated for better diagnostics
Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 1M, or use smaller result sets)
    join_buffer_size (> 256.0K, or always use indexes with JOINs)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    table_definition_cache(400) > 1039 or -1 (autosizing if supported)
    performance_schema = ON enable PFS
    innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.

What can I do to solve this problem?

Performance Query – How to find resource-hungry SQL operations in Postgresql? High CPU utilization

I frequently receive high usage alerts from the production base server processor. As I want to deepen this question myself, I have collected database queries running for this period of high CPU usage.

SELECT * FROM pg_stat_activity;

According to the data collected, there is a frequently used table with the UPDATE operation. After further research, I learned that the table is the most consulted table in the database and that there is nothing that consumes a lot of resources.

Here are the details I got from EXPLAIN for this query,

                                  QUERY PLAN                                   
-------------------------------------------------------------------------------
 Update on foo_table  (cost=0.00..1271.14 rows=1 width=55)
   ->  Seq Scan on foo_table  (cost=0.00..1271.14 rows=1 width=55)
         Filter: (id = 2::bigint)
(3 rows)

Until now, the only data I have is the amount of time that this CPU-intensive operation occurs. Although unable to know which query takes too much time to process.

I tried to follow the queries, I could not find convincing statistics.

SELECT relname, idx_tup_fetch + seq_tup_read as TotalReads from pg_stat_all_tables WHERE idx_tup_fetch + seq_tup_read != 0 order by TotalReads;

SELECT * FROM pg_stat_all_tables ORDER BY seq_scan DESC;

I'm helpless because there is no way for me to understand what's going on, as if it's normal because the workload or a problem with indexing or optimizing the query would solve it etc.

Spec. DB:
Size: 150+ GB
CPU: 8 core
RAM: 16 GB
Storage: SSD without exchange.

Resource Utilization Report | Talk Web Hosting

Resource Utilization Report

We have received today the email from a customer who asked us the question below …

How can I check the use of my cPanel resources and be notified immediately of the use of memory and processor in my email? Is it possible to use cron jobs?

As far as I know, cPanel sends a direct email for the use of bandwidth and bandwidth if they exceed or nearly exceed the limits, but do not know if it can send alerts processor and memory to a cPanel user … help you please

[[[[ServerClub.In – Server experts – Certified ISO 9001: 2015 and ISO 10002: 2014
[[[[Email: crm [at] virtualworld.co.in | Multiple World Sites – INDIA, SINGAPORE, United Kingdom, Germany, United States
[[[[ALL SSD – Shared Enterprise Hosting – Enterprise Email Specialist – Gsuite – VPS – Dedicated Servers – Cloud Hosting Solutions

measure – What is the standard German version of the System Utilization Scale (SUS)?

I myself looked for a camera some time ago and I found nothing. The fact is that the SUS was published as a "quick and dirty" free scale and that no one "recognizes" it in the same way that the Human Factors Research Group at UCC controls the SUMI.

More importantly, there is now a lot of data published on the English version of the SUS and its features that can help you plan and interpret the usability tests with this version (see references below). To my knowledge, no one has collected or published the same type of data for a German version. Apart from that, we really do not know how it compares to the English version and nothing helps to say that one translation is better than another.

Depending on your needs and the efforts you want to make, you can do one of three things:

  1. Just use a translation that makes you feel good. It should certainly be enough to see some differences between designs or products, which is the most important way to interpret SUS scores (absolute scores do not tell you much without a benchmark to which you can compare them ).
  2. Opt for the SUMI. It is a little older and longer and is not free, but there is an official German translation that will provide more information (it includes several more specific subscales in addition to overall satisfaction / perceived user-friendliness) . The wording of some items may seem awkward for some products, such as websites.
  3. Develop your own translation (and possibly publish it). The best solution for this type of thing is to ask one or more experts to translate the documents from English into German, then to the other experts to do a reverse translation to check if the meaning has not been translated. modified, revising translations if necessary. Then use this translation in a large user test (at least hundreds of participants and preferably different types of products), examine elements such as reliability and factor structure, compare them to publish data on the English version and check if certain elements have specific problems and need to be corrected or replaced.

Important documents on the English version of the SUS (next to the Brooke document already mentioned):

  • Bangor, A., Kortum, P.T., & Miller, J.T. (2008). An empirical evaluation of the scale of use of the system. International Journal of Human-Computer Interaction, 24 (6), 574-594.
  • Borsci, S., Federici, S. and Lauriola, M. (2009). On the dimensionality of the scale of use of the system: test of alternative measurement models. Cognitive treatment, 10 (3), 193-197.
  • Lewis, JR & Sauro, J. (2009). Factorial structure of the system utilization scale. Proceedings of the International Human Computer Interaction Conference (HCII 2009), CA San Diego, USA.
  • Sauro, J. & Lewis J.R. (2011) when designing usability questionnaires, is it painful to be positive ?. Proceedings of the Human Factors in Computer Systems Conference (CHI 2011), Vancouver, BC, Canada.
  • Tullis, T.S., & Stetson, J.N. (2004). Comparison of questionnaires to evaluate the usability of websites. Proceedings of the UPA conference.

Dramatically high CPU utilization

I have a CPU usage problem in Ubuntu 16.04, the process to set the CPU usage unit

And when I kill this process, it regenerates itself with a new PID. I restart the system but still the same problem. At startup, the system is much slower and remains stuck.

graphics card – 70% CPU utilization and 100% CPU usage on the RTX2080ti and 6700K

Recently, I updated the GTX1070 to the RTX2080ti, but there is only 70% use of the graphics processor when I play on Rainbowsix Siege and Assassin's Creed Odyssey. It will be 100% when I will use the GTX1070, so I wonder if there is a problem with my computer?

It is strange that it is 100% GPU uses in the reference of the game, but 70% in the game. I notice that the temperature of the CPU and gpu is around 70 ° C. I suspect that the processor is the bottleneck, so I overclocke a little bit. Regarding the GPU, I use the AORUS engine's automatic scan and it's about 1800 MHz at stake.

I run the game in 2k and 144hz monitor and the fps will fall under 144hz but the GPU uses is only 70%. I think this should be a 100% use when I turn off the vertical sync, just like when I use the GTX1070.

I wonder if the reason the GPU is used is weak and should I update the CPU or PSU?

Here are my specifications:
CPU: Intel i7 6700K @ 4.5G
GPU: GIGABYTE RTX 2080Ti WINDFORCE
Motherboard: GIGABYTE Z170X-UD3
RAM: Kingston Fury DDR4 2400 16G
PSU: SUPER FLOWER GX650

Thank you!

apache 2.4 – High utilization of system resources due to HTTP hacking attempts

I have a WordPress website created in a Linux machine with Apache as a MySQL web service and database.

Recently, hackers are trying to hack the website using POST methods. These requests are refused by the server but the memory is saturated by this type of continuous requests and the service like Apache, MySQL is stopped.

So my question is, how can we prevent such an attack request from not using the server resource? Is there a mod_security rule available to explicitly deny the attack without using a server resource ?. Please advice.

The following is the log entry for the POST attack.

134.175.91.239 – – [30/Nov/2018:15:15:34 +0000] "POST /wp-admins.php HTTP / 1.1" 403 743 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:15:36 +0000] "POST /m.php?pbid=open HTTP / 1.1" 403 743 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; previous version: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:15:38 +0000] "POST /db_dataml.php HTTP / 1.1" 404 30163 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; version: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:15:43 +0000] "POST /mx.php HTTP / 1.1" 404 30168 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:15:47 +0000] "POST /xshell.php HTTP / 1.1" 404 30173 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:15:48 +0000] "POST /qq.php HTTP / 1.1" 404 30158 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:15:58 +0000] "POST /phpstudy.php HTTP / 1.1" 404 30163 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:16:02 +0000] "POST /phpStudy.php HTTP / 1.1" 404 30188 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; version: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:16:06 +0000] "POST /weixiao.php HTTP / 1.1" 404 30173 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:16:07 +0000] "POST /feixiang.php HTTP / 1.1" 404 30173 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:16:10 +0000] "POST /ak47.php HTTP / 1.1" 404 30168 "-" "Mozilla / 5.0 (Windows NT 6.1; Win64; x64; rv: 28.0) Gecko / 20100101 Firefox / 31.0"

134.175.91.239 – – [30/Nov/2018:15:19:26 +0000] "POST / ws / v1 / cluster / apps / new-application HTTP / 1.1" 404 30150 "-" "Mozilla / 5.0 (X11; Linux x86_64; vr: 45.0) Gecko / 20100101 Firefox / 45.0"

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive Proxies-free.com New Proxy Lists Every Day Proxies123