Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

database question - Thrashing - What Is?

Tags:

terminology

Whats Thrashing? Ive heard it mentioned a few times at work and dont want to ask... Probably a stupid question - any ideas?

like image 647
Donal.Lynch.Msc Avatar asked Jan 19 '10 00:01

Donal.Lynch.Msc


People also ask

What thrashing means?

Thrashing is computer activity that makes little or no progress, usually because memory or other resources have become exhausted or too limited to perform needed operations.

What causes thrashing?

As we saw in the above example, there can be three main causes of thrashing. High degree of Multiprogramming. Less number of frames compared to the processes required. The process scheduling scheme which swaps in more processes when CPU utilization is low.

What is thrashing and how it can be handled?

Thrashing is a condition or a situation when the system is spending a major portion of its time servicing the page faults, but the actual processing done is very negligible. Thrashing's Causes. Thrashing has an impact on the operating system's execution performance.

How do you solve thrashing?

To resolve thrashing you can do any of the suggestions below : *Increase the amount of RAM in the computer. *Decrease the number of programs being run on the computer. *Adjust the size of the swap file. Save this answer.


2 Answers

Reading through those pages :

  • MySQL + LARGE innodb = thrashing HDD
  • Reduce thrashing or poor system performance


I arrived to that one : Disk Thrashing, which states (quoting)

On a system with Virtual Memory, pages of memory are read from and written to the swap file as necessary.
Disk Thrashing is when there is excessive paging, specifically when the I/O system is busy paging memory but the CPU is not fully utilized - generally if the system is unresponsive (i.e. slow) and there is lots of disk activity then the system is likely to be thrashing.


And, of course, you might want to take a look on the Thrash (computer science) page on wikipedia ;-)

like image 117
Pascal MARTIN Avatar answered Sep 17 '22 02:09

Pascal MARTIN


Thraching is where a process consumes all available resources without achieving anything useful. Examples are endless loops or code that retries a failed command endlessly.

like image 34
Phil Wallach Avatar answered Sep 17 '22 02:09

Phil Wallach