07-21-2010
Tuning my.cnf settings is not trivial, and is very dependent on the application.
Run that script I linked to. It will suggest a lot of different things you can tune.
Also, most distributions of mysql have sample my.cnf files for various levels of load and use in the docs that come with the distribution, you might look at those to get some ideas.
8 More Discussions You Might Find Interesting
1. Programming
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
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
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
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
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
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
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
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 SUSE
wmsmpmon
WMSMPMON(1) General Commands Manual WMSMPMON(1)
NAME
wmSMPmon - Window Maker System Monitor
SYNOPSIS
wmSMPmon [options]
DESCRIPTION
wmSMPmon is a Window Maker dock application that displays the following information about the system:
- Current CPU utilization of up to two CPUs
- Up to two minutes history of CPU utilization
- Current memory usage
- Current swap usage
On dual CPU systems, wmSMPmon has three different styles for the utilization graph. To toggle between them just click into the graph.
OPTIONS
All options start with one dash.
-h Show summary of options.
-r REFRESH_RATE
Set the refresh rate of the graph in microseconds. The default is 250000 (a quarter of a second).
-g GRAPH_STYLE
Start using graph style #[1-3] (only on dual CPU systems). Style 1 shows the utiliziation in one graph, while 2 and 3 are split in
two little graphs. Style 2 shows the two graphs on top of each other. Style 3 uses a mirror like type. The default style is 1, which
is also the style used on single CPU systems.
-c1 IDX, -c2 IDX
On systems with more than 2 CPUs, select the CPUs to show. Per default CPU number 1 and 2 are shown. On a quad CPU systems you may
launch second wmSMPmon showing CPUs number 3 and 4.
-no-swap
Do not monitor swap.
SEE ALSO
wmaker(1x)
AUTHOR
This manual page was originally written by Alain Schroeder <alain@debian.org> and adapted for wmSMPmon 3 by Thomas Ribbrock
<emgaron@gmx.net>
WMSMPMON(1)