Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Temp mysql files jamming CPU resources
Top Forums UNIX for Dummies Questions & Answers Temp mysql files jamming CPU resources Post 302438488 by egully on Tuesday 20th of July 2010 01:27:09 AM
Old 07-20-2010
Temp mysql files jamming CPU resources
Hello Friends

I am currently facing high CPU usage problem which is making my site extremely slow.
Currently I am using a 8GB RAM with 8 cores but, the creation of temporary files is eating away a lot of the CPU resource making the site very slow.
The normal CPU load average remains below 2-3 but, suddenly it shoots to double digits in order of 20-30
On investigating the mysql data files, I could see huge files created as listed below :

Code:
/var/tmp/#sql_25dd_0.MYD 
/var/tmp/#sql_25dd_1.MYD 
/var/lib/mysql/egully1_cpdata2009/isc_product_search.MYD 
/var/lib/mysql/egully1_cpdata2009/isc_product_search.MYD 
/var/lib/mysql/egully1_cpdata2009/isc_product_search.MYD 
/var/lib/mysql/egully1_cpdata2009/isc_product_search.MYD 
/var/lib/mysql/egully1_cpdata2009/isc_product_search.MYI

These files are in order of 0.5-2.5GB.
After restarting mysql all the temp files gets deleted and system gets back to normal. But, after some time the problem again resurfaces.

Can anyone suggest how to deal with this problem and how to flush huge temp files from system to keep the site performance smooth.
Last edited by Scott; 07-20-2010 at 02:32 AM.. Reason: Code tags
 

8 More Discussions You Might Find Interesting

1. Programming

Application occupying CPU resources

Dear all, I have a pro c application running in the unix environement. This pro c program actually trigger by a java application from sun workstation. Recently, when we released a new proc c application and notice that the application occupying the CPU resources even through we check that the... (1 Reply)
Discussion started by: ghho
1 Replies

2. Linux

Shared web server resources (CPU&RAM)

Hello, guys ! Long time no seen. I have a question about Linux web servers. I guess it is a more general question, but in my case it is a Linux web server. I want to know how much RAM memory should I put on my servers. Do you have some formula or guidelines on how should I calculate the amount... (1 Reply)
Discussion started by: Sergiu-IT
1 Replies

3. Solaris

CPU resources

Hi, I got a solarsi 10 box with 9 zones and the cpu shares as following ID NAME SHARES 0 global 1 1 FMW1 100 2 FMW2 100 3 OID1 100 4 OID2 100 5 OVD1 100 6 OID0 100 7 FMW5 100 8... (2 Replies)
Discussion started by: fugitive
2 Replies

4. UNIX for Dummies Questions & Answers

Security issue and temp files

Hello, One of the senior network admins at work told me that I should not hard code temp files into my scripts. Rather I should use the mktemp commands in the script to create them on the fly. His argument was that if a malicious user knew the name of my temp files in the script they could... (6 Replies)
Discussion started by: mojoman
6 Replies

5. Shell Programming and Scripting

temp files

Hi there, As a regular unix user I am forever programming on the command line or writing scripts so that I first write a load of data to a file to read from. In the end I am always left with a bundle of .txt, .tmp which is what I usually call them. As a basic programmmer I was wondering is... (6 Replies)
Discussion started by: cyberfrog
6 Replies

6. Shell Programming and Scripting

RMTF (ReMove Temp Files)

Heyas As some applications (sed,grep,vi, etc) create some tempfiles, i'd changed a script to this: (sadly i cant find the original post (code) anymore (which just removed 2 'diffrent kinds'), just similar ones - forgot that as i was new to all this) :) ~ $ cat $(which rmtf) #!/bin/sh #... (1 Reply)
Discussion started by: sea
1 Replies

7. Solaris

Sun Fire V210 CPU Fan Temp too high?

Hey, I have a V210 with a failed CPU fan. The temperature is currently at 84C and I've been asked to wait a few weeks before replacing as its a production system and it cant be shut down yet. Is it too hot? Do I risk killing the CPU at this temp? Its been like this for a few weeks now... (5 Replies)
Discussion started by: magarvo
5 Replies

8. Shell Programming and Scripting

Removing large number of temp files

Hi All, I am having a situation now to delete a huge number of temp files created during run times approx. 16700+ files. We have never imagined that we will get this this much big list of files during run time. It worked fine for lesser no of files in the list. But when list is huge we are... (7 Replies)
Discussion started by: mad man
7 Replies

LEARN ABOUT NETBSD

ug

UG(4)							   BSD Kernel Interfaces Manual 						     UG(4)

NAME

     ug -- Abit uGuru system hardware monitor

SYNOPSIS

     ug* at acpi?
     ug0 at isa? port 0xe0

DESCRIPTION

     The ug driver provides support for the Abit uGuru hardware monitor to be used with the envsys(4) interface.

     The ug driver has 19 sensors:

	   Sensor    Units    Typical Use
	   CPU	     uK       CPU Temp
	   SYS	     uK       System Temp
	   PWN	     uK       PWN Temp
	   VCORE     uV DC    Core voltage
	   DDR0      uV DC    DDRVdd
	   DDR1      uV DC    DDRVtt
	   NB	     uV DC    NBVdd
	   SB	     uV DC    SBVdd
	   HTV	     uV DC    HTVdd
	   AGP	     uV DC    AGPVdd
	   V5V	     uV DC    Vdd5V
	   V33V      uV DC    Vdd3V3
	   V5SB      uV DC    Vdd5VSB
	   V33VD     uV DC    Vdd3VDual
	   CPUF      RPM      CPU Fan
	   NBF	     RPM      NB Fan
	   SYSF      RPM      SYS Fan
	   AUXF      RPM      AUX Fan 1
	   AUXF2     RPM      AUX Fan 2

SEE ALSO

     acpi(4), envsys(4), envstat(8)

HISTORY

     The ug driver first appeared in NetBSD 4.0.

AUTHORS

     The ug driver was written by Mihai Chelaru <kefren@netbsd.ro>.

BUGS

     Interrupt support is unimplemented.

BSD
								    May 8, 2007 							       BSD
All times are GMT -4. The time now is 03:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy