Solved

CA monitoring reported mySql pid hit instance & thread max limit : Linux instance & thread limits

Posted on 2010-09-06
3
565 Views
Last Modified: 2012-05-10

The CA Unicentre support can only tell me that the alerts I'm receiving are triggered by
the monitored mySql pid (process id)'s instance & thread max limits being hit.

There's not a clue in the Unix /var/log/messages & mySql's error log as the time stamps
in these logs do not match with the timings the alerts were received.

I've posted a question in another EE thread on how to tune the mySql .cnf file but I'm
wondering if this could be some sort of Unix process' limit being reached.

I know in HP-UX when Oracle hits certain OS limits, "sar -v 3 5" would give me clues
that the Unix OS parameters nproc, nfile  limits have been reached.

What's the equivalent command in RHES 5.4 that can check for a process' instance
& thread max limits?  "sysctl -a" only give the current setting not the utilized values.

When I looked at "top -H", I'm clueless
0
Comment
Question by:sunhux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 62

Assisted Solution

by:gheist
gheist earned 200 total points
ID: 33627022
i think it uses 64 threads by default and there is no limit or benefit of increasing those.....
0
 
LVL 3

Accepted Solution

by:
T1750 earned 300 total points
ID: 33639521
cat /proc/<mysql's pid>/status
0
 

Author Closing Comment

by:sunhux
ID: 33764444

Accepted
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question