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 302438494 by malcolmpdx on Tuesday 20th of July 2010 01:45:33 AM
Old 07-20-2010
I suspect that those temporary tables are being used to store large joins and other queries that you get as you use the site.

This indicates that your my.cnf file needs tuning. I would suggest that you let your site run for a while, and then use one of the many fine mysql tuning suggestion scripts that can help you identify what's going on.
 

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 CENTOS

cpu

CPU(8)                                                        System Manager's Manual                                                       CPU(8)

NAME

       cpu - A tool for user and group administration

SYNOPSIS

       cpu [OPTIONS]

DESCRIPTION

       CPU is a tool for user administration, that was initially based on FreeBSD's pw(8). This tool will allow you to administer users and groups
       on several different backends currently including LDAP and flat files. Please see the website http://cpu.sourceforge.net for more  informa-
       tion, or help improve the man page.

OPTIONS

       There are two kinds of options; options for CPU and options for CPU modules.  There are only four options for CPU, they are as follows:

       -C configfile, --config configfile
              The configuration file to be used by CPU. The options in this file are used for CPU modules.

       -h, --help
              Display help for CPU. If specified in conjunction with the -m option the help for that particular module is displayed.

       -M method, --method=method
              This  is  the method of administration. Current options are ldap or passwd (passwd is not yet working). This can be specified in the
              configuration file.

       -V, --version
              Display the version of the software.

SEE ALSO

       cpu.conf(5) cpu-ldap(8)

AUTHORS

       Blake Matheny <bmatheny@purdue.edu>

       The current version of this software is always availabe at http://cpu.sourceforge.net

BUGS

       To report a bug or problem, please e-mail:

       cpu-users@lists.sourceforge.net

TODO

       See TODO file that accompanied software. Please e-mail us with any additional suggestions.

                                                                 17 February 2003                                                           CPU(8)
All times are GMT -4. The time now is 09:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy