t the values have really
been raised ?
The 'safe_mysqld' script I use has an option to raise the limit:
/usr/pkg/bin/safe_mysqld --open-files-limit=256
Anyway the error code doesn't match a per-process limit but a system limit.
This is why I would use ktrace to check what the error r
only has 38 tables, and the datafile I'm trying to load is only
> 37 KB.
>
> Someone suggested a few days ago that perhaps the error reported is not accurate.
>How would
> I test that?
>
> My 'gut' says this is probably an easily resolved co
d' process, using
the 'mysql' command, rigth ?
Maybe it's just the mysql command which runs out of files descriptors ?
Did you try to raise the limit of the shell before starting it ?
--
Manuel Bouyer <[EMAIL PROTECTED]>
--
nd was invoked or the actual mysqld process?
The mysqld process
When mysqld is started the values are herited from the shell, but once it's
started you can change both values independantly with systctl.
--
Manuel Bouyer <[EMAIL PROTECTED]>
--
e mysqld with several databases,
and I don't have problems with it ...
--
Manuel Bouyer <[EMAIL PROTECTED]>
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
t; in the database.
And how much files does mysqld have ?
fstat |grep mysqld |wc -l
--
Manuel Bouyer <[EMAIL PROTECTED]>
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
n count them with 'fstat'.
You may also want to ktrace mysqld while trying to load the
database to get more details.
--
Manuel Bouyer <[EMAIL PROTECTED]>
--
-
Before posting, please check:
http://www.