MySQL numfiles problem [message #33813] |
Wed, 12 November 2008 12:24 ![Go to next message Go to next message](/theme/ovz3/images/down.png) |
ukexi
Messages: 4 Registered: November 2008
|
Junior Member |
|
|
Hallo,
I've got an very annoying problem with my MySQL-database. After accessing some tables, the system doesn't close the filehandles. This causes numfile to ascend (every table = two open files).
On a physical server (Debian 4.0 - fresh install) the filehandles are closed within two or three minutes. On the virtual server (Debian 4.0 - freh install) the filehandles stay open.
The configs /etc/mysql/my.cnf are the same on both systems. I shutdown the webserver for exclude this as a problem.
Actually, I have 1000 opened files on an unused MySQL-Database!
Quote: |
lsof | grep web0
mysqld 24115 mysql 100u REG 0,222 1024 286408764 /var/lib/mysql/usr_web0_1/asdfasdf.MYI
mysqld 24115 mysql 101u REG 0,222 40 286408766 /var/lib/mysql/usr_web0_1/asdfasdf.MYD
|
Testscript (php5 -f test.php):
Quote: |
<?php
error_reporting(E_ALL);
$c = mysql_connect("localhost","root","PASSWORD");
mysql_selectdb("usr_web0_1");
$d = mysql_query("select * from asdfasdf");
echo mysql_num_rows($d);
mysql_close($c);
?>
|
|
|
|
|
|
|
|
|
|
Re: MySQL numfiles problem [message #49132 is a reply to message #49080] |
Thu, 28 March 2013 19:38 ![Go to previous message Go to previous message](/theme/ovz3/images/up.png) |
Paparaciz
Messages: 302 Registered: August 2009
|
Senior Member |
|
|
The problem was 4 years ago. if you have some problems I would recommend to create new topic with detailed information what exactly prolem you have.
Also write kernel version, HN OS, CT OS, CT config.
please keep in mind that if you use old software and kernel version it would be recommended to update at least HN.
if you use Debian in HN I recommend to use RHEL based latest stable kernel. information how to do this is in the wiki.
|
|
|