Re: mysql is eating up lot of CPU and memory
Hey Simon, You just performed the classic, I have an issue, but I won't provide any info. Please elaborate on the issue. Provide hardware spec, config information. Tell us why you suspect the mysqld is consuming too much resource? We can attempt to assist with more info as there are no silver bullets here except using the blackhole storage engine for all tables (joke) . Andrew On 20 Sep 2012 18:15, Simon K k_simo...@yahoo.com wrote: 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
RE: mysql is eating up lot of CPU and memory
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