> Christopher Chan writes:
> >
> > [mysqld]
> > datadir=/var/lib/mysql
> > socket=/var/lib/mysql/mysql.sock
> > set-variable = thread_cache_size=700
> > set-variable = table_cache=850
> > set-variable = key_buffer_size=16M
> > set-variable = max_connections=850
> > set-variable = max_connect_errors=999999999
> > skip-name-resolve
> > skip-locking
> > memlock
>
> Hi!
>
> First of all, try not using memlock.
I'll give this a try.
>
> Second, when MySQL runs out of memory, which is a possibility here, it
> will print the error message in the error log file.
We have 1GB of swap available and only 20% of it was reported as being used
by top when the mysqlds were in their infinite loops. Plural here because we
found the same problem on multiple machines at the time this was discovered.
The mysqld.log did have a few lines about needing 16kb.
>
> Third, try to achieve the same effect with our binary, as you could be
> running out of system space with glibc default stack size.
>
I'll try this one if possible.
>
> --
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@stripped>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
> Join MySQL Users Conference and Expo:
> http://www.mysql.com/events/uc2003/
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread13945@stripped
> To unsubscribe, e-mail <bugs-unsubscribe@stripped>
>
>
