List:General Discussion« Previous MessageNext Message »
From:tcobb Date:June 13 1999 4:51am
Subject:RE: MySQL Server connection problem
View as plain text  
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.
Thread
MySQL Server connection problemOzlinx)12 Jun
  • MySQL Server connection problemMichael Widenius12 Jun
  • Re: MySQL Server connection problemOzlinx)12 Jun
    • Re: MySQL Server connection problemMichael Widenius12 Jun
  • Re: MySQL Server connection problemOzlinx)13 Jun
    • Re: MySQL Server connection problemDan Nelson13 Jun
  • Re: MySQL Server connection problemOzemail)13 Jun
    • Re: MySQL Server connection problemDan Nelson13 Jun
  • Re: MySQL Server connection problemOzemail)13 Jun
    • Re: MySQL Server connection problemMichael Widenius25 Jun
RE: MySQL Server connection problemtcobb13 Jun
  • Re: MySQL Server connection problemOzemail)13 Jun
Re: MySQL Server connection problemOzlinx)13 Jun