too many mysql processes
Posted by: chamal de silva
Date: February 22, 2005 12:07PM

Hi,

I have a problem with mysql. The problem is that I see too many mysql processes when I run the linux ps -ax command. Those processes are not dying. The number keeps on increasing.

I am using red hat 8.0. Mysql 3.0.

A php web site running on apache is also accessing Mysql server.
A java program running on java 1.4 is also accessing Mysql server using connectorJ driver.
But the java program can't connect to mysql using localhost as the host. It has to use localhost.localdomain as the host.

I can't think of a way to stop these mysql processes.

Is it a problem with mysql locks.

Can you please help me to solve this problem.


I have also copied a small section from my mysqlerror.log file.

=========================================================

050211 11:16:00 mysqld started
/usr/libexec/mysqld: File '/var/log/mysqllog.log' not found (Errcode: 13)
050211 11:16:00 Could not use /var/log/mysqllog.log for logging (error 13)
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

Status information:

Current dir: /var/lib/mysql/
Current locks:
lock: 83fb654:

lock: 83f94d4:

lock: 83f72ec:

lock: 83f58fc:

lock: 83f3c44:

lock: 83f1074:

lock: 83ef254:

lock: 83e45e4:

lock: 83ebc24:

lock: 83e56c4:

key_cache status:
blocks used: 4
not flushed: 0
w_requests: 16
writes: 14
r_requests: 113
reads: 4

handler status:
read_key: 55
read_next: 22
read_rnd 1627
read_first: 5
write: 5
delete 2
update: 6

Table status:
Opened tables: 16
Open tables: 10
Open files: 20
Open streams: 0

Status information:

Current dir: /var/lib/mysql/
Current locks:
lock: 83fb654:

lock: 83f94d4:

lock: 83f72ec:

lock: 83f58fc:

lock: 83f3c44:

lock: 83f1074:

lock: 83ef254:

lock: 83e45e4:

lock: 83ebc24:

lock: 83e56c4:

key_cache status:
blocks used: 4
not flushed: 0
w_requests: 16
writes: 14
r_requests: 113
reads: 4

=======================================

Best regards,
Chamal.

Options: ReplyQuote


Subject
Written By
Posted
too many mysql processes
February 22, 2005 12:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.