php - MYSQL overload -


i having problems mysql overloading , when busy server stop responding completely. know 1 of databases has loot of trafic how can deal this.do need better server or need different engion database. @ moment using myisam. of tables dealing have 420000 records(82.7 mib) there lot of inserts , selects , speed important much

i message on when @ status on whm

/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.sy2.com.pid --skip-external-locking

the server load 180%-220% of time.

i typed on server

netstat -nat | awk '{print $6}' | sort | uniq -c | sort -n     1 established)    1 foreign   17 syn_recv   28 fin_wait1   30 listen  154 established  188 fin_wait2 1206 time_wait

apache status

current time: saturday, 25-jun-2011 19:00:34 bst restart time: friday, 24-jun-2011 20:41:36 bst parent server generation: 11 server uptime: 22 hours 18 minutes 58 seconds total accesses: 1866618 - total traffic: 12.2 gb cpu usage: u25.92 s20.03 cu1142.19 cs0 - 1.48% cpu load 23.2 requests/sec - 159.5 kb/second - 6.9 kb/request 206 requests being processed, 12 idle workers   server spec linux - dual quad core intel xeon e5620 hard disk: 4x300gb sas 15k rpm ram: 12 gb ddr3 ram raid options: raid 10 (needs 4 identical drives) operating system: centos 5.x control panel: cpanel/whm bandwidth: 5000 gb

there no simple answer question. guidelines on how troubleshoot issue. may running peak load server can handle , may not able optimize much.

start show processlist give idea how many connections open , ones might stuck due locking issues.

enable slow query log, responding queries , use explain see execution plan. may missing indexes or have structural issues causing queries run slow.

you can tweak database server settings allow more data cached in memory. there tools mysqltuner can guide settings should at.

you may want take @ guide: http://www.fromdual.com/mysql-performance-tuning-key


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more