Questions tagged [bottleneck]

A bottleneck is the place where transmission is the slowest.

A bottleneck can best be described as the slowest working component in a machine. Suggest you have a computer with 100 super fast CPUs, a bit of memory and an old IDE drive. When we start a process that needs to do parse something from a giant file, our bottleneck will be the I/O. Our CPUs will be able to handle the parsing, but not all of them will be used on max capacity because the I/O will not be able to provide the file fast enough.

This is called a bottleneck. The analogy comes from whenever you try to empty a bottle. There is only so much liquid that can get through the bottle opening (bottleneck).

56 questions
1
vote
2 answers

What could cause blocked requests in IIS?

I'm using IIS on Windows Server 2016 with MySQL and PHP on two almost identical servers. I've recently noticed a slowdown on one of my two servers but it happens only when my site tries to execute multiple instances of a script at the same time. …
Vincent
  • 808
  • 1
  • 9
  • 12
1
vote
1 answer

Strange behaviour of MySQL on Windows (CPU 100% with simple query)

We run MySQL 8 on Windows 2019 server (Dell R420, 32 cores, 64GB, SSDs on Raid10). Every now and then, our website goes completely offline, as the CPU on the MySQL server is completely bottlenecked (CPU 100%). After a bit of investigation, we found…
Alex K.
  • 41
  • 6
1
vote
1 answer

How do I know if SSD is the bottleneck in Linux?

I have a database server which uses a Samsung 840 pro disk. The load is constantly higher than usual, even if there is not much activity on the website. So I suspect the disk has worn out. But how can I check that the disk i/o is the bottleneck?…
Milkyway
  • 113
  • 3
0
votes
1 answer

Limitations to using many SSDs in computing server

This is a beginner's question: We have a powerful computing server for roughly 10 users which will be increasingly used for data processing. In the past the main bottleneck was I/O. I was wondering if it is possible to have some kind of device to…
0
votes
2 answers

mySQL Database Performing Extremely Poor on INSERT, DESTROY, but fine on FIND and UPDATE

I believe I've encountered a database scaling issue. I have a table with nearly a million rows in it now and our rails application appears to be hanging whenever we try to create a new instance. I notice this also happens when we destroy a record as…
Jim Jeffers
  • 133
  • 3
0
votes
1 answer

How can I predict whether or not memory will bottleneck a CPU

My question is general, though I have a specific example. My question is this: How can I predict whether a powerful CPU will be fully exploited in a scenario with memory that is (relatively) low? My example is this: I'm specing out a Dell Precision…
0
votes
3 answers

find bottleneck of a slow server centos

I have a virtual machine host running Centos 6. It is serving an android application with apache/php/mysql. When online users gets high in number , the server responds very slowly. Even ssh connection to the server becomes slow. So how can I find…
BlackBrain
  • 117
  • 4
0
votes
1 answer

hardisk or network bottleneck?

Im trying to determine which hardware causing the bottleneck of the server, the server is mainly used for serving video files on a heavy traffic site. i have dstat output look like below (will get up to 500+ for send part on peak hour): interface…
Teddybugs
  • 153
  • 10
0
votes
1 answer

What constant throughput and linear respone time tells about the system?

What does it mean when throughput in the system is constant and only response time changes (linearly)? Does it mean that I have to have a bottleneck?
0
votes
2 answers

Is Quality of Service my ISP's responsibility?

One person on my network does a massive download, not caring too much about how long it takes. Someone else on my network doesn't want his incessant video streaming interrupted. My understanding is that this is solved using QoS, to prioritize…
kelario
  • 19
0
votes
0 answers

How to find the bottleneck for slow rsync

I want to find the bottleneck for a slow rsync. I see these parts (on byte flow order): IO on source CPU on source Network CPU on destination IO on destination How can I debug this?
guettli
  • 3,591
  • 17
  • 72
  • 123
0
votes
2 answers

Can a VLAN traffic affect other VLANS?

Consider 2 vlans VLAN-1 VLAN-2 VLAN-1 gets an abnormally large traffic spike from outside world. Will this affect the other VLAN and will the applications in VLAN-2 have packet loss and high latency in this situation?
0
votes
1 answer

Bottleneck PHP/MySQL server

The server is getting slow on peak hours, and I don't really know how to find out the bottleneck. I can upgrade ram and cpu. Currently 2gb and 2x2.4ghz Linux CENTOS Around 60.000 pageviews per day 600 unique users Every page around 5…
Server
  • 11
  • 2
0
votes
4 answers

Does using all cores reduce efficiency?

I have a program (well, php script) which does some pretty heavy text searching - it loads a 2mb and 40mb file and searches through them to find where each word that appears in the first is present in the second. I have a 4 core cpu (personal…
Benubird
  • 523
  • 1
  • 5
  • 11
0
votes
1 answer

Network card capable of capturing a tonne of packets and not dropping them?

Edit: Our server is trying to capture packets at between 500-600Mb/s, but is dropping packets 'due to kernel'. Data is being written to SSDs, and isn't bottleneck there. What things should I look for in a network card when choosing one that would be…
BIGMOOSE
  • 9
  • 2