• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 599
  • Last Modified:

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


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
sunhux
Asked:
sunhux
2 Solutions
 
gheistCommented:
i think it uses 64 threads by default and there is no limit or benefit of increasing those.....
0
 
T1750Commented:
cat /proc/<mysql's pid>/status
0
 
sunhuxAuthor Commented:

Accepted
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now