At 06:59 PM 6/22/2002, you wrote:
>On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote:
> > Re Gunnar Helliesen e-mail
> > I have FreeBSD4.2 and MySQL 3.23.49.
> > I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
> > After making the suggested changes to my.cnf we rebooted the system.
> > For 3 days all ran fine (low cpu) then at 2am cpu went back up to 99%.
> > Has any body know why FreeBSD with MySQL had this problem?
> > Simon
> > PS apart from that it kicks ass.....as MySQL should...
>
>We've managed to reproduce this pretty reliably at Yahoo and are
>working to track and fix the bug. If we find a resolution, I'll post
>a note here.
There have been a few threads regarding high CPU utilization on FreeBSD
systems. The 2nd processor may be causing the problem. You may want to
contact the original authors to see if they've come up with a solution.
Mike
Here are 3 threads:
Thread #1:
X-Sieve: CMU Sieve 2.1
Received: from www.fastmail.fm ([unix socket])
by www.fastmail.fm (Cyrus v2.1.3) with LMTP; Tue, 11 Jun 2002
04:13:55 -0500
Received: from www.fastmail.fm (localhost [127.0.0.1])
by localhost.localdomain (Postfix) with ESMTP id 398FF6D9FB
for <[EMAIL PROTECTED]>; Tue, 11 Jun 2002 04:13:55 -0500 (CDT)
X-Mail-from: [EMAIL PROTECTED]
X-Delivered-to: <[EMAIL PROTECTED]>
Received: from web.mysql.com (web.mysql.com [192.58.197.162])
by www.fastmail.fm (Postfix) with SMTP id 43FE26D9E5
for <[EMAIL PROTECTED]>; Tue, 11 Jun 2002 04:13:54 -0500 (CDT)
Received: (qmail 1417 invoked by uid 7797); 11 Jun 2002 09:04:38 -0000
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
List-ID: <mysql.mysql.com>
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 1341 invoked from network); 11 Jun 2002 09:04:17 -0000
Content-Type: text/plain;
charset="iso-8859-1"
From: Leo De Geer <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Organization: Kristianstad Teknikverkstad
To: Simon Green <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: problem with mysql threads on freebsd
Date: Tue, 11 Jun 2002 11:12:46 +0200
X-Mailer: KMail [version 1.4]
References: <[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Message-Id: <[EMAIL PROTECTED]>
On Tuesday 11 June 2002 10.48, Simon Green wrote:
> We are ruing a box with freeBSD and MySQL with twin processors....
> It looked like it was using only on processor but we decided that it was
> the way FreeBSD's threads work?
> There seems to be two problems with ruing MySQL on FreeBSD.
> One: Seems not to use both processors (on twin system)
> Two: All ways a load on 1 even when the system in not at hi load (seem to
> go down when it is!)
>
> What is up with freeBSD or MySQL.....
>
> Simon
>
> -----Original Message-----
> From: Leo De Geer [mailto:[EMAIL PROTECTED]]
> Sent: 11 June 2002 09:35
> To: Alexander V Zubchenko
> Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: Re: problem with mysql threads on freebsd
>
> On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote:
> > Greetings!
> >
> > On Tue, 11 Jun 2002, Leo De Geer wrote:
> > > but in my case its not good to have it that way im having one dedikated
> > > dual server for the sql and now im yust using one cpu for the sql
> > > questions. i nead it to start sub conections to the sql to serv all my
> > > conections good.
> >
> > In such case provide, please additional info. AFAIU, You want to use
> > both cpu for sql, in other words, optimal use of Your server. Than, do
> > You recompile (or compile) kernel with SMP support (afaik, this is
> > only arch for multicpu systems, supported by fbsd)? You can b sure,
> > that if mysql will run separate process for each request, it will
> > slowdown perfomance, but never increase it. In fact, balancing load on
> > many cpus is OS task. And multithreaded processes _must_ b processed
> > similarly to multiprocess environment (but i don't know, how exactly
> > fbsd smp-support built). Check Your kernel config
> > /usr/src/sys/i386/conf/<name>. You may find also this <name>
> > interesting:
> > LINT - list [almost?] all options recognized in config-file.
> >
> > With respect,
> >
> > Alexander V Zubchenko, E-Mail: [EMAIL PROTECTED]
> > System Administrator, WWW: http://www.hermes-comp.zp.ua/
> > Hermes-comp,
> > Ukraine,
> > Zaporizhzhya,
> > Geroev Stalingrada 50
> > phone/fax: +380 612 64-19-72
>
> the kernel is runing both cpu. and the balancing is working good on
> everything
> but the sql!
>
> i have on my linux sql server aproximatly 100 simultanius conections that
> du
>
> you think that the standard memory size of 128 do you think i nead to put
> it
>
> up to 256 meg in the kernel
the problen nr 2 i dont have but the server we have dont handle the load on
one cpu. at the moment we are runing the sql on a linux instead (same
hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter
regards leo
--
MVH C. Leo De Geer
www.dinsignal.com
www.ktv.se
www.teknikshoppen.nu
Thread#2:
Hi Joe,
I'm actually going through this same issue on 4.5 box
right now running Mysql max.. i've submitted ticket into support @ mysql
since i bought it.. I guess this seems to be common thing in Bsd
Hope we can all figure whats wrong with it..
-Frankie
----- Original Message -----
From: "Joe Maimon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 9:28 AM
Subject: Mysqld runs with high cpu load on freebsd 4.4
> Hey All,
>
> We recently picked up a box running a web site with mysql on freebsd.
> The cpu load gets pegged high realy quickly under its normal load. This
> wasnt always the case.My designers do not believe it to be the queries
> shown in the slow query log, which return quickly on development
> platforms (winnt) and appear to be highly optimized. I have tried the
> port version, a compiled from source version, and the binary off the web
> site.
>
> The system is a PIII 800 with 1G RAM.
>
> While soaking the cpu, the mysqladmin processlist return minimal
> activity happening. The mysqld spends most of its time in the poll
> stage. Disk I/O seems minimal. The web site response slows down
> considerably.
>
> Restarting the mysqld daemon puts the load back down, but within minutes
> its bouncing back up there and after about an hour it stabilizes at ~70
> percent or higher.
>
> This is the contents of the my.cnf I have been playing with. I havent
> seen much performance difference no matter what values I put in here.
>
> [mysqld]
> #port = 3306
> #socket = /tmp/mysql.sock
> skip-locking
> set-variable = max_connections=100
> set-variable = key_buffer=512M
> set-variable = max_allowed_packet=2M
> set-variable = table_cache=1000
> set-variable = sort_buffer=32M
> set-variable = record_buffer=4M
> set-variable = myisam_sort_buffer_size=92M
> set-variable = thread_cache=32
> set-variable = tmp_table_size=128M
> #set_variable = log-slow-queries
> # Try number of CPU's*2 for thread_concurrency
> set-variable = thread_concurrency=6
> log-bin
> server-id = 1
>
> Has anyone come across a freeBSD 4.4 issue - possibly with the thread
> library? Short of putting in a test box, is there a conclusive way to
> determine that its the queries/configuration causing this not the box?
>
> Joe
>
Thread #3:
From: "Dreamtime.net Inc." <[EMAIL PROTECTED]>
To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]>
Subject: Mysql Problems - Peak loads - Two processors
Date: Sun, 3 Mar 2002 13:25:46 -0800
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Hi,
We have mysql 3.23.43 running under FreeBSD 4.2, two-processors and a
Tyan LE S2510 motherboard with 1 gig of ram. After a few peak loads of the
server (load avg. gets higher than 20), mysql starts eating processor
cycles.
Server load gets close to 1.0, mysqld is active all the time,
although almost no queries comes in.
Has anyone had this problem before? Any help is highly
appreciated.
Below is (slightly edited) "mysqldadmin status extended-status
variable" output.
mysqladmin -u root -p status extended-status variables
Enter password:
Uptime: 382385 Threads: 26 Questions: 10065975 Slow queries:
3 Opens: 414 Flush tables: 1 Open tables: 64 Queries per
second avg: 26.324
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 1006 |
| Aborted_connects | 0 |
| Bytes_received | 1030079334 |
| Bytes_sent | 3599913822 |
| Connections | 460421 |
| Created_tmp_disk_tables | 787 |
| Created_tmp_tables | 11911 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 292472 |
| Handler_read_first | 1291 |
| Handler_read_key | 9330959 |
| Handler_read_next | 4044092 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 19142458 |
| Handler_read_rnd_next | 959934027 |
| Handler_update | 3251570 |
| Handler_write | 3824893 |
| Key_blocks_used | 10086 |
| Key_read_requests | 40011425 |
| Key_reads | 8283 |
| Key_write_requests | 1549487 |
| Key_writes | 762676 |
| Max_used_connections | 229 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 112 |
| Open_streams | 0 |
| Opened_tables | 414 |
| Questions | 10065975 |
| Select_full_join | 71 |
| Select_full_range_join | 87 |
| Select_range | 683 |
| Select_range_check | 77 |
| Select_scan | 65901 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 3 |
| Sort_merge_passes | 0 |
| Sort_range | 140 |
| Sort_rows | 15892575 |
| Sort_scan | 42546 |
| Table_locks_immediate | 9382816 |
| Table_locks_waited | 11753 |
| Threads_cached | 0 |
| Threads_created | 460420 |
| Threads_connected | 26 |
| Threads_running | 1 |
| Uptime | 382385 |
+--------------------------+------------+
| Variable_name |
Value
+---------------------------------+------------
| back_log |
450
| basedir |
/usr/local/
| bdb_cache_size |
8388600
| bdb_log_buffer_size |
32768
| bdb_home |
/var/db/mysql/
| bdb_max_lock |
10000
| bdb_logdir
|
| bdb_shared_data |
OFF
| bdb_tmpdir |
/var/tmp/
| bdb_version | Sleepycat Software: Berkeley
DB 3.2.9a: (October 3, 2001) |
binlog_cache_size |
32768
| character_set |
latin1
| character_sets | latin1 dec8 dos german1 hp8
koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia
hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert |
ON
| connect_timeout |
5
| datadir |
/var/db/mysql/
| delay_key_write |
ON
| delayed_insert_limit |
100
| delayed_insert_timeout |
300
| delayed_queue_size |
1000
| flush |
OFF
| flush_time |
0
| have_bdb |
YES
| have_gemini |
NO
| have_innodb |
NO
| have_isam |
YES
| have_raid |
NO
| have_openssl |
NO
| init_file
|
| interactive_timeout |
28800
| join_buffer_size |
131072
| key_buffer_size |
16773120
| language |
/usr/local/share/mysql/english/
| large_files_support |
ON
| log |
OFF
| log_update |
OFF
| log_bin |
OFF
| log_slave_updates |
OFF
| log_long_queries |
OFF
| long_query_time |
10
| low_priority_updates |
OFF
| lower_case_table_names |
0
| max_allowed_packet |
1048576
| max_binlog_cache_size |
4294967295
| max_binlog_size |
1073741824
| max_connections |
1000
| max_connect_errors |
10
| max_delayed_threads |
20
| max_heap_table_size |
16777216
| max_join_size |
4294967295
| max_sort_length |
1024
| max_user_connections |
0
| max_tmp_tables |
32
| max_write_lock_count |
4294967295
| myisam_max_extra_sort_file_size |
256
| myisam_max_sort_file_size |
2047
| myisam_recover_options |
0
| myisam_sort_buffer_size |
8388608
| net_buffer_length |
16384
| net_read_timeout |
30
| net_retry_count |
1000000
| net_write_timeout |
60
| open_files_limit |
0
| pid_file |
/var/db/mysql/turbo.pid
| port |
3306
| protocol_version |
10
| record_buffer |
131072
| record_rnd_buffer |
131072
| query_buffer_size |
0
| safe_show_database |
OFF
| server_id |
0
| slave_net_timeout |
3600
| skip_locking |
OFF
| skip_networking |
OFF
| skip_show_database |
OFF
| slow_launch_time |
2
| socket |
/tmp/mysql.sock
| sort_buffer |
2097144
| sql_mode |
0
| table_cache |
64
| table_type |
MYISAM
| thread_cache_size |
0
| thread_stack |
65536
| transaction_isolation |
READ-COMMITTED
| timezone |
EST
| tmp_table_size |
33554432
| tmpdir |
/var/tmp/
| version |
3.23.43
| wait_timeout |
3600
+---------------------------------+----------------
$uptime
4:50AM up 4 days, 10:28, 1 user, load averages: 1.08, 1.08, 1.02
$
---------------------------------------------------------------------
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
