Hi Noor, Here is my my.cnf file, it has almost nothing in it.
[mysqld]
port=3306
set-variable = max_allowed_packet=1M
log-update
[mysql.server]
user=mysqladm
[mysqldump]
And Here are some stats for you, it sounds like our servers are very
close. I am using DELL 2400's with 2 processors. I do NOT have SMP
enabled on FreeBSD yet. Although I have a new test server I am just
setting up that does have SMP on it. Nor do I have apache running on
the same server. I find the CPU load to be very low. Are you running
SMP? Have you modified the GENERIC kernel? There must be something
different between our two systems, maybe we could take this
discussion private find the answers then just post our results to the
list.
> mysqladmin -uken -p status
Enter password:
Uptime: 350099 Threads: 55 Questions: 3161869 Slow queries: 1
Opens: 17814
Flush tables: 1 Open tables: 64 Queries per second avg: 9.031
>
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU
COMMAND
11507 sysadm 28 0 1880K 1056K RUN 0:00 1.45% 0.73% top
3346 mysqladm 2 0 20884K 16932K poll 130:06 0.00% 0.00%
mysqld
117 root 2 -12 1256K 716K select 0:16 0.00% 0.00% ntpd
167 root 2 0 2496K 1240K select 0:02 0.00% 0.00%
sendmail
164 root 10 0 952K 560K nanslp 0:01 0.00% 0.00% cron
114 root 2 0 916K 532K select 0:01 0.00% 0.00%
syslogd
171 root 2 0 2092K 848K select 0:00 0.00% 0.00% sshd
256 root 3 0 1332K 812K ttyin 0:00 0.00% 0.00% csh
11495 sysadm 18 0 1328K 808K pause 0:00 0.00% 0.00% tcsh
206 root 10 0 632K 232K wait 0:00 0.00% 0.00% sh
11410 sysadm 3 0 1328K 808K ttyin 0:00 0.00% 0.00% tcsh
11494 root 2 0 2136K 1316K select 0:00 0.00% 0.00%
telnetd
162 root 2 0 1032K 592K select 0:00 0.00% 0.00% inetd
11409 root 2 0 2136K 1316K select 0:00 0.00% 0.00%
telnetd
-----------------------------------------------------
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
----- Original Message -----
From: "Noor Dawod" <[EMAIL PROTECTED]>
To: "Ken Menzel" <[EMAIL PROTECTED]>; "Sinisa Milivojevic"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 11:49 AM
Subject: RE: Unexplained high-loads on FreeBSD
> Hi Ken,
>
> After making the world last week, I've updated sources for Apache,
> MySQL, PHP and mod_ssl. Afterwards, recompiled all of them, stopped
> previous instances, installed them again and then started all of
them.
> So yes, I did recompile MySQL.
>
> Regarding the conservative configuration settings, this is as you
said
> the default values. Our server has between 5-20 queries per second
> (almost quiet at night), so our servers are almost alike. What do
you
> suggest for the values of the variables in my.cnf?
>
> TIA
>
> Noor
>
> -----Original Message-----
> From: Ken Menzel [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 22, 2001 6:09 PM
> To: Sinisa Milivojevic; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Unexplained high-loads on FreeBSD
>
>
> Hi Sinisa and everyone,
> I have a question for Noor, after updating freeBSD-stable last
> week, I assume you did a "make world", but did did you recomiple
> MySQL under that update? The compiler itself was broken on the
older
> FreeBSD and was not fixed till the 12th of Jan (except by patches on
> the mailing list!). Also my setting with memory and such are VERY
> conservative. We are mostly using the MySQL defaults. I will be
> increasing this soon. Our current servers run about 9 queries per
> second. (They are quiet at night).
> Solaris threads may be an excellent OS, however it is too expensive
> for our market. I have found FreeBSD groups to be very responsive
to
> threads issues, with patches being issued as soon as a repeatable
> test case is identified.
> All of this does not mean that there may not also be a problem with
> MySQL, that would be common to all platforms, however in my
> experience, most of these sorts of issues were threads related.
> Hope this helps. Ken
> -----------------------------------------------------
> Ken Menzel ICQ# 9325188
> www.icarz.com [EMAIL PROTECTED]
> ----- Original Message -----
> From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, January 22, 2001 9:25 AM
> Subject: RE: Unexplained high-loads on FreeBSD
>
>
> > Noor Dawod writes:
> > > Hi Sinisa
> > >
> > > Is the FreeBSD problem previously submitted by me known to you?
> > >
> > > Noor
> >
> >
> > Ken Manzel has submitted many valuable messages to this mailing
list
> > concerning many important patches for FreeBSD 4.* threads.
> >
> > He has even provided names of files and dates when they were
> released.
> >
> >
> >
> > Regards,
> >
> > Sinisa
> >
> > ____ __ _____ _____ ___ == MySQL AB
> > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> > /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
> > /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> > ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> > /*/ \*\ Developers Team
> >
>
> --------------------------------------------------------------------
> -
> > 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 <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
>
> --------------------------------------------------------------------
-
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
