Opec,
On your FreeBSD machine, please run the following
commands and send the results:
uname -v
sysctl -a | grep files
mysqladmin variables
netstat -m
I'm running a very busy MySQL server on FreeBSD
with little problem, but I've made some OS
modifications, so the results of the above should
help in diagnosing the problem.
-Troy Cobb
Circle Net, Inc.
http://www.circle.net
> -----Original Message-----
> From: Opec Kemp (Ozlinx) [mailto:opec@stripped]
> Sent: Saturday, June 12, 1999 11:52 PM
> To: Mysql Mailing List
> Subject: Re: MySQL Server connection problem
>
>
> > Ozlinx> Not quite 24 hrs but close to it :)
> >
> > <cut>
> >
> > Not my day (or rather night). I meant 'mysqladmin
> extended-status'
> > Could you please repost the status.
> That's OK Monty :) you're a busy man here it is:
> +--------------------------+----------+
> | Variable_name | Value |
> +--------------------------+----------+
> | Aborted_clients | 0 |
> | Aborted_connects | 7849 |
> | Created_tmp_tables | 0 |
> | Delayed_insert_threads | 0 |
> | Delayed_writes | 0 |
> | Delayed_errors | 0 |
> | Flush_commands | 2 |
> | Handler_delete | 119507 |
> | Handler_read_first | 196373 |
> | Handler_read_key | 1586297 |
> | Handler_read_next | 3235531 |
> | Handler_read_rnd | 15925965 |
> | Handler_update | 230965 |
> | Handler_write | 122342 |
> | Key_blocks_used | 3212 |
> | Key_read_requests | 10574179 |
> | Key_reads | 3034 |
> | Key_write_requests | 1340110 |
> | Key_writes | 673463 |
> | Max_used_connections | 180 |
> | Not_flushed_key_blocks | 0 |
> | Not_flushed_delayed_rows | 0 |
> | Open_tables | 460 |
> | Open_files | 119 |
> | Open_streams | 0 |
> | Opened_tables | 1016 |
> | Questions | 7465851 |
> | Running_threads | 2 |
> | Slow_queries | 455 |
> | Uptime | 96597 |
> +--------------------------+----------+
>
> > Ozlinx> 1.2) If my understanding of pconnect() is correct
> then how do I
> bump up the
> > Ozlinx> max_connect, do I have to modify mysql source to
> > Ozlinx> acheive this?.
> >
> > No, you don't have to modify the MySQL source (MySQL allows you to
> > have up to 16384 connections). You may have to recompile
> your FreeBSD
> > kernel to support much more file descriptors. What is
> your current
> > file descriptor limit?
>
> Yeah, that what I thought too, however, I can't seems to
> find any info on
> increasing the file descriptor on FreeBSD ... maybe
> I will have to post to the mailing list.
>
> > By the way (no flames please); I have had some problems with a
> > FreeBSD machine lately which also behaves likes your (and without
> > reasons). Any change you can install Linux on a second
> harddisk and
> > try if MySQL behaves better on Linux in this case? It
> would be VERY
> > interesting to know if this is a FreeBSD or a MySQL problem!
>
> Yeah I find the same. I have used Linux/MySQL and never see
> this problem.
> Unfortuantely I can't change the OS as
> do don't make the big decision .. :(.
>
> Thankyou
>
> Opec
>
>
>
>
>
>
>
> ------------------------------------------------------------
> ---------
> Please check
"http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread5130@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
