High CPU --> Find the worst query and let's optimize it. SHOW CREATE TABLE SHOW TABLE STATUS EXPLAIN SELECT ... It may be as simple as adding a 'compound' index. Or rewriting a WHERE clause. There are literally hundreds of possible issues and answers. The 3 things above are probably enough for me to make a concrete recommendation.
High Memory --> High is good, Swapping is _terrible_. Tuning: http://mysql.rjweb.org/doc.php/memory > -----Original Message----- > From: Simon K [mailto:k_simo...@yahoo.com] > Sent: Thursday, September 20, 2012 10:15 AM > To: mysql@lists.mysql.com > Subject: mysql is eating up lot of CPU and memory > > Hi All, > > I am using HP-UX box. > > I am having problem with mysqld daemon , it is eating too much of > processor and memory . Are there any kernel tweaks for memory and > processor i need to do to get mysql to run ? And it is taking too much > time to run the queries on HP-UX box . > > Did anyone faced this kind of problem ? Please help me to sort this > out. > > > Thanks & Regards, > Simon
