07-20-2010
Mysql my.cnf settings help required
Dear Friends
I run my website "www.egully.com" on a dedicated server with a config of memory 8GB and 8GB RAM
the CPU load average often shoots from 2-3 to 20-30 and the site becomes extremely slow. On investigation we found a lot of temporary mysql tables are been created which is taking up lot of CPU resource. The temp tables are like :
/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.
I doubt if there is some problem with my.cnf file setting. Our current settings are
[mysqld]
set-variable = max_connections=200
socket = /var/lib/mysql/mysql.sock
key_buffer =512M
table_cache = 1024
open_files_limit = 16344
join_buffer_size = 32M
read_buffer_size = 32M
sort_buffer_size = 32M
tmp_table_size=256M
read_rnd_buffer_size=16M
max_heap_table_size=256M
myisam_sort_buffer_size=256M
thread_cache_size=8
thread_cache=8192
query_cache_type=1
query_cache_limit=256M
query_cache_size=256M
thread_concurrency=8
wait_timeout = 30
connect_timeout = 30
interactive_timeout = 60
long_query_time=1
log-slow-queries = /var/log/slowqueries.log
max_allowed_packet=128M
Can some one suggest what I need to do for improving the speed and avoid creation of the temp files
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
My data is something like shown below.
date1 date2 aaa bbbb ccccc
date3 date4 dddd eeeeeee ffffffffff ggggg hh
I want the output like this
date1date2 aaa eeeeee
I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies
2. Solaris
Hi
i have created a solaris zone but have not yet connected any network cables for this new zone,
can i set the zone up without running the command 'add net' and not adding an ip or physical interface?
i tried to add dummy internet settings and get this
zonecfg:coddr> add net... (4 Replies)
Discussion started by: newbiesolaris10
4 Replies
3. Shell Programming and Scripting
Hi All,
I want to login to CVS using terminal. I am executing the following command in the terminal :-
export CVSROOT=: pserver:ags_rd@istcvs.corp.apple.com:/istcvs/CVSHOME
cvs login
But i get the following error :
Afreens-iMac:buildTest Afreen$ export CVSROOT=:... (3 Replies)
Discussion started by: Afreen
3 Replies
4. OS X (Apple)
Hi All,
I want to login to CVS using terminal. I am executing the following command in the terminal :-
export CVSROOT=: pserver:ags_rd@istcvs.corp.apple.com:/istcvs/CVSHOME
cvs login
But i get the following error :
Afreens-iMac:buildTest Afreen$ export CVSROOT=:... (1 Reply)
Discussion started by: Afreen
1 Replies
5. UNIX for Dummies Questions & Answers
I am using putty to conect various unix/solais/hp boxes...
The font size appear in the putty are very small and the black background and white text is very usual ...
I want to change the size of the text appear to som ewhat bigger and text color to change green and cursor appearence to... (2 Replies)
Discussion started by: girija
2 Replies
6. UNIX and Linux Applications
Hi,
SLES11 : I've installed the following MySQL Package:
MySQL-client-community-5.1.54-1.sles11.x86_64
MySQL-devel-community-5.1.54-1.sles11.x86_64
MySQL-server-community-5.1.54-1.sles11.x86_64
MySQL-shared-community-5.1.54-1.sles11.x86_64Problem: I don't see any my.cnf file (find / -name... (1 Reply)
Discussion started by: hiddenshadow
1 Replies
7. Solaris
Hi Guys,
I need to reboot one Server as the newly inserted disk is not getting detected in system , I have also confirmed with Sun Support and finally it was the reboot which was required after doing all troubleshooting stuff.
So I have disassembled the mirror and kept working disk's single... (3 Replies)
Discussion started by: manalisharmabe
3 Replies
8. Shell Programming and Scripting
Hi
i am new to unix shell scripting i have the below requirement
connect to server B and then connect to mysql in the server B and query for a particular record and capture that value
but when i perform this i am facing an error
can u guys help me on this:confused::confused:
... (2 Replies)
Discussion started by: Hamdul
2 Replies
9. Red Hat
hi
i started in the apache userdirectory and virtual host
now iwant installtion wordpress in home one of the useres
But this error is
Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
And the configuration files and other items I was enter... (0 Replies)
Discussion started by: mnnn
0 Replies
UPTIME(1) User Commands UPTIME(1)
NAME
uptime - Tell how long the system has been running.
SYNOPSIS
uptime [options]
DESCRIPTION
uptime gives a one line display of the following information. The current time, how long the system has been running, how many users are
currently logged on, and the system load averages for the past 1, 5, and 15 minutes.
This is the same information contained in the header line displayed by w(1).
System load averages is the average number of processes that are either in a runnable or uninterruptable state. A process in a runnable
state is either using the CPU or waiting to use the CPU. A process in uninterruptable state is waiting for some I/O access, eg waiting for
disk. The averages are taken over the three time intervals. Load averages are not normalized for the number of CPUs in a system, so a
load average of 1 means a single CPU system is loaded all the time while on a 4 CPU system it means it was idle 75% of the time.
OPTIONS
-p, --pretty
show uptime in pretty format
-h, --help
display this help text
-s, --since
system up since, in yyyy-mm-dd HH:MM:SS format
-V, --version
display version information and exit
FILES
/var/run/utmp
information about who is currently logged on
/proc process information
AUTHORS
uptime was written by Larry Greenfield <greenfie@gauss.rutgers.edu> and Michael K. Johnson <johnsonm@sunsite.unc.edu>
SEE ALSO
ps(1), top(1), utmp(5), w(1)
REPORTING BUGS
Please send bug reports to <procps@freelists.org>
procps-ng December 2012 UPTIME(1)