Re: FreeBSD and MySQL - mysqld eats CPU alive
Andrey Kotrekhov [EMAIL PROTECTED] wrote: äÏÂÒÙÊ ÄÅÎØ. áÇÁ, ÄÏÂÒÙÊ, but we speak english here. :) Usually I run configure like this: Well I don't remember the configure options used in mysql40-server port, but these are recommended. You just want to enable linuxthreads and buildstatic and you can add there your own configure options. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
adp [EMAIL PROTECTED] wrote: I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Running MySQL on FreeBSD requires some magic. One of the famous magicians is Jeremy Zawodny. Check his sacred MySQL-on-FreeBSD scriptures at http://jeremy.zawodny.com/blog/archives/cat_mysql.html I hope you will find a revelation there. ;) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
Did you compile mysql from source or you use precompiled binary package? I use mysql with different versions of FreeBSD without big problems. adp [EMAIL PROTECTED] wrote: I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Running MySQL on FreeBSD requires some magic. One of the famous magicians is Jeremy Zawodny. Check his sacred MySQL-on-FreeBSD scriptures at http://jeremy.zawodny.com/blog/archives/cat_mysql.html I hope you will find a revelation there. ;) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
Andrey Kotrekhov [EMAIL PROTECTED] wrote: Did you compile mysql from source or you use precompiled binary package? I use mysql with different versions of FreeBSD without big problems. On FreeBSD, you can compile MySQL from ports. I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Running MySQL on FreeBSD requires some magic. One of the famous magicians is Jeremy Zawodny. Check his sacred MySQL-on-FreeBSD scriptures at http://jeremy.zawodny.com/blog/archives/cat_mysql.html I hope you will find a revelation there. ;) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
. Usually I run configure like this: ./configure \ --prefix=/usr/local/mysql_4 \ --without-debug \ --with-charset=koi8_ru \ --with-extra-charset=koi8_ukr,win1251,win1251ukr \ --with-mysqld-user=X \ --without-berkeley-db \ --without-isam \ --without-innodb \ --enable-thread-safe-client because I need koi8 charset and etc... And I don't have any problem Andrey Kotrekhov [EMAIL PROTECTED] wrote: Did you compile mysql from source or you use precompiled binary package? I use mysql with different versions of FreeBSD without big problems. On FreeBSD, you can compile MySQL from ports. I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Running MySQL on FreeBSD requires some magic. One of the famous magicians is Jeremy Zawodny. Check his sacred MySQL-on-FreeBSD scriptures at http://jeremy.zawodny.com/blog/archives/cat_mysql.html I hope you will find a revelation there. ;) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
Hi, It sounds like you are using the default thread library. I would install MySQL from /usr/ports/databases (WITH_LINUX_THREADS, see options in Makefile) or barring that try Jeremey's excellent build recipe at http://jeremy.zawodny.com/blog/archives/000458.html . We used to have the same problem and everything runs great now. Ken - Original Message - From: adp [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 30, 2004 2:58 PM Subject: FreeBSD and MySQL - mysqld eats CPU alive I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Our servers are generally heavily loaded. I would say that I'm doing something wrong (although what I could be doing wrong I'm not sure), but I recently began working with another company that has the EXACT SAME PROBLEM. They are even thinking of moving to PostgreSQL, but we are trying to fix mysqld instead for now. This behavior has been seen on: FreeBSD 4.4, 4.7, 4.9, 4.10 MySQL 3.x and 4.x Typical load: 50 qps With and without replication enabled. Some sites are SELECT heavy, some are INSERT heavy. For one site I think we will be moving from FreeBSD to Linux for the MySQL servers since MySQL seems to run like a champ on Linux. We will continue to use FreeBSD for everything else. Anyone experienced this problem? Is it mysqld or FreeBSD? I can't pinpoint the exact issue. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. For what it's worth, we had the exact OPPOSITE happen: We were using OpenBSD for a long time, and when we switched to FreeBSD, MySQL CPU usage dropped from like 75% to 5%. It's been running amazingly fast ever since, for a database-driven website that gets 10,000 unique visitors a day. (100,000 page views a day, all MySQL-generated.) Just using a stock install from FreeBSD ports -- although we did choose the OPTIMIZED settings in ports install that it shows you when you first go to install MySQL server. Choose linux threads, too. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
adp, There are quite a few people with a similar problem with Free BSD. I don't know if they found a solution but here is a place to start looking: http://groups.google.ca/groups?hl=enlr=ie=UTF-8q=freebsd+mysql+heavy+cpubtnG=Search Mike At 01:58 PM 7/30/2004, you wrote: I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Our servers are generally heavily loaded. I would say that I'm doing something wrong (although what I could be doing wrong I'm not sure), but I recently began working with another company that has the EXACT SAME PROBLEM. They are even thinking of moving to PostgreSQL, but we are trying to fix mysqld instead for now. This behavior has been seen on: FreeBSD 4.4, 4.7, 4.9, 4.10 MySQL 3.x and 4.x Typical load: 50 qps With and without replication enabled. Some sites are SELECT heavy, some are INSERT heavy. For one site I think we will be moving from FreeBSD to Linux for the MySQL servers since MySQL seems to run like a champ on Linux. We will continue to use FreeBSD for everything else. Anyone experienced this problem? Is it mysqld or FreeBSD? I can't pinpoint the exact issue. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]