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_simon78@stripped]
> Sent: Thursday, September 20, 2012 10:15 AM
> To: mysql@stripped
> 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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.