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
