List:General Discussion« Previous MessageNext Message »
From:Ken Menzel Date:March 19 2002 10:14pm
Subject:Re: MySQL, FreeBSD problem
View as plain text  
Hi Brad,
  You are running out of file descriptors,  type this:
kes# sysctl -a | grep files
kern.maxfiles: 20000
kern.maxfilesperproc: 18000
kern.openfiles: 5230
kes# limit -h
cputime         unlimited
filesize        unlimited
datasize        1048576 kbytes
stacksize       262144 kbytes
coredumpsize    unlimited
memoryuse       unlimited
descriptors     18000
memorylocked    unlimited
maxproc         4115

You probably increased the number of tables in my.cnf and did not
allocate enough descriptors for the process.

use sysctl to increase the number of available descriptors.

----- Original Message -----
From: "Brad Phinney" <phinney@stripped>
To: <mysql@stripped>
Sent: Tuesday, March 19, 2002 3:47 PM
Subject: MySQL, FreeBSD problem

> Hello all.
> I have an application that does a lot of table creation and writing
> a FreeBSD 4.4 SMP machine.  Over time, I begin to see the following
> errors.
> DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/'
(Errcode: 2) at /var/SAMT/code/SAMTlib/ line 2552, <FILE>
chunk 138.
> DBD::mysql::db do failed: Table 'p3_samt_trans.p3_int_sender_2_12_0'
doesn't exist at /var/SAMT/code/SAMTlib/ line 2301, <FILE>
chunk 138.
> These errors seem to happen for no reason.  If I issue a select, do
> anything else 2 seconds later, I get no errors.  The table in
> above does in fact exist, although MySQL claims that it does not.
> The machine (or mysql for that matter) is not under particularly
> load.  It simply occassionally just cant read a database directory
> some reason or another.  A fraction of a second later, the same
> will work fine.
> Now, I am using the 3.23.47 Free BSD binary from the MySQL site on
> machine.
> I notice that the problem continues to get worse as time goes on.
If I
> restart mysqld however, the problem seems to go away for  a bit.
> after 2-3 days, the problem comes back.
> Any ideas? thoughts?
> Any assistance with this problem would be welcomed.
> Thanks.
> --------------------------------------------------------------------
> Before posting, please check:
>   (the manual)
>           (the list archive)
> To request this thread, e-mail <mysql-thread103495@stripped>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try:

MySQL, FreeBSD problemBrad Phinney19 Mar
  • Re: MySQL, FreeBSD problemColin Faber19 Mar
  • Re: MySQL, FreeBSD problemKen Menzel19 Mar
  • Re: MySQL, FreeBSD problemDan Nelson19 Mar