Bob , i saw what you meant me to set, it was on the daemon login
class , i changed it with chfn to _mysql .
Tonight i will test it again with mysqlcheck -m -A -p
to see if i still reach the limits.
Thanks for your advice!
Regards,
Marcos
----- Original Message -----
From: "Bob Beck" <[EMAIL PROTECTED]>
To: "Marcos Laufer" <[EMAIL PROTECTED]>
Cc: "Otto Moerbeek" <[EMAIL PROTECTED]>; <misc@openbsd.org>
Sent: Friday, July 13, 2007 1:54 PM
Subject: Re: mysql problem
You are setting the user, not the login class.
You have made a login class _mysql in /etc/login.conf,
but it looks like you may not have that as user _mysql's default
login class. You need to either change user _mysql to be in the
_mysql login class by default, (hint, chfn _mysql as root) OR,
use the su command to start it as otto showed you.
Note as well, that just setting it to use 8192 open
files won't necessarily get you all the way there if the
kernel doesn't have that many configured. You may also need
to increase this if you *really* need that many:
# sysctl kern.maxfiles
kern.maxfiles=1772
-Bob
* Marcos Laufer <[EMAIL PROTECTED]> [2007-07-13 10:46]:
> I am , and i have a simple and nice script for starting and stopping it
> properly:
>
> # /usr/local/bin/my start
>
> cat /usr/local/bin/my
>
> #!/bin/sh
> #
> test -z "$1" -o \( "$1" != "start" -a "$1" != "stop" \) \
> && echo "syntax: $0 [start|stop]" && exit 1
>
> exec /usr/local/share/mysql/mysql.server $1 > /dev/null 2>&1
>
> --
> and in mysql.server it says:
>
> # Set some defaults
> pid_file=
> server_pid_file=
> use_mysqld_safe=1
> user=_mysql
>
>
> What do you think, should i add more openfiles to mysql?
> Regards,
> Marcos
>
> ----- Original Message -----
> From: "Otto Moerbeek" <[EMAIL PROTECTED]>
> To: "Marcos Laufer" <[EMAIL PROTECTED]>
> Cc: <misc@openbsd.org>
> Sent: Friday, July 13, 2007 4:07 AM
> Subject: Re: mysql problem
>
>
> On Fri, 13 Jul 2007, Marcos Laufer wrote:
>
> > I did read the archives, and it helped me to find out that
> > restarting mysql fixes it for some time, and i increased the values
> > several times but no luck. It starts working fine
> > for a while but then again it fails . In the end i have
> > this config right now and the problem persists, i can
> > reproduce the problem just by executing
> >
> > mysqlcheck -m -A -p
>
> How are yo starting mysql? You need to explicitly set the login class.
>
> Somthing like
>
> su -c mysql root /usr/local/bin/mysqld_safe ...
>
> -Otto
> >
> >
> > --
> > # sysctl kern.maxfiles
> > kern.maxfiles=20000
> > --
> >
> > in login.conf:
> > _mysql:\
> > :openfiles=8192:\
> > :datasize=infinity:\
> > :maxproc=infinity:\
> > :openfiles-cur=8192:\
> > :openfiles-max=10000:\
> > :stacksize-cur=8M:
> >
> >
> >
> > in my.cnf:
> >
> > [mysqld]
> > socket = /var/www/logs/mysql/mysql.sock
> > old-passwords
> > tmpdir = /var/mysql/tmp
> > open-files-limit = 10000
> > sql-mode = MYSQL40
> > skip-name-resolve
> > table_cache = 1024
> > query_cache_size = 64M
> > key_buffer = 64M
> > long_query_time = 5
> > #log-slow-queries
> > #log-queries-not-using-indexes
> > thread_concurrency = 2
> > #query_cache_limit = 1M
> > interactive_timeout=60
> > wait_timeout=60
> > connect_timeout=15
> >
> > basedir=/usr/local
> > datadir=/var/mysql
> >
> > sort_buffer_size = 1M
> > read_buffer_size = 1M
> > read_rnd_buffer_size = 4M
> > myisam_sort_buffer_size = 64M
> >
> > [mysql.server]
> > old-passwords
> >
> > [mysqld_safe]
> > open-files=8192
> >
> >
> > ----
> >
> > Maybe i need to increase something else?
> > Thanks!
> >
> >
> > ----- Original Message -----
> > From: "Otto Moerbeek" <[EMAIL PROTECTED]>
> > To: "Marcos Laufer" <[EMAIL PROTECTED]>
> > Cc: <misc@openbsd.org>
> > Sent: Friday, July 13, 2007 3:12 AM
> > Subject: Re: mysql problem
> >
> >
> > On Fri, 13 Jul 2007, Marcos Laufer wrote:
> >
> > > I am having a very strange problem on a 3.9 , suddenly i can't access any
> > > table
> > > on the databases. I have around 100 databases on this server and can't
> > access
> > > not even one. This is a production server and i am in an urge to solve it,
> > if
> > > anyone
> > > can help i would appreciate it:
> > >
> > > # mysql mysql -p
> > > Enter password:
> > > Welcome to the MySQL monitor. Commands end with ; or \g.
> > > Your MySQL connection id is 303342 to server version: 5.0.18
> > >
> > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > >
> > > mysql> show tables;
> > > ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9)
> > > mysql>
> > >
> > >
> > > I have backups of all databases, including mysql database which i think is
> > the
> > > one
> > > broken , how can i restore it ?
> > >
> > > Thanks for your help
> >
> > You are running out of file descriptors. Search the archives for answers.
> >
> > -Otto
>
--
#!/usr/bin/perl
if ((not 0 && not 1) != (! 0 && ! 1)) {
print "Larry and Tom must smoke some really primo stuff...\n";
}
