Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Number of processes in mysql
Old 03-28-2006, 02:53 AM Number of processes in mysql
Novice Talker

Posts: 14
Location: Sweden
Trades: 0
Anybody knows what determines the number of running mysqld processes !?

I haven't been able to understand why I have inbetween 50-80 of the all the time (I mean OS processes seen in top/ps etc)

I run version 5.0.16 on Linux
__________________
quiz4fun.com - Knowledge and Quiz for Fun and Education
Conth is offline
Reply With Quote
View Public Profile Visit Conth's homepage!
 
 
Register now for full access!
Old 04-02-2006, 04:32 AM Re: Number of processes in mysql
codecrunch's Avatar
Average Talker

Posts: 22
Trades: 0
How busy is your server , and what is it used for?

MySQL is meant to handle multiple requests. If you have a very busy db, and it's not eating up all of your memory, then it may be normal. Without knowing exactly what your configuration is used for - it's hard to analyze.
__________________

Please login or register to view this content. Registration is FREE
- Webmaster tutorials and forums. Brand spanking new. Semper Fi!
codecrunch is offline
Reply With Quote
View Public Profile
 
Old 04-14-2006, 04:04 AM Re: Number of processes in mysql
sacx13's Avatar
Experienced Talker

Posts: 32
Location: Here
Trades: 0
If you want to see the processlist just run in mysql console:
show processlist;

if you want to see the number of processes on system try:
ps axuwwww | grep mysqld | wc -l

If you wan to see the number of connection on your database try:
netstat -tn | grep ":3306" | wc -l

Regards
Adrian
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
sacx13 is offline
Reply With Quote
View Public Profile
 
Old 05-24-2006, 08:14 AM Re: Number of processes in mysql
Novice Talker

Posts: 14
Location: Sweden
Trades: 0
The server is very busy and I am trying to figure out what the actual problem is...
__________________
quiz4fun.com - Knowledge and Quiz for Fun and Education
Conth is offline
Reply With Quote
View Public Profile Visit Conth's homepage!
 
Reply     « Reply to Number of processes in mysql
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.16751 seconds with 12 queries