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.