Re: Mysqld runs with high cpu load on freebsd 4.4
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 > > > - > 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
Re: MySQL Performance on Dual Processor machine
Do keep in Mind that FreeBsd isn't 100 % with Smp .. you might have to compile linux threads in order to try and use the dual cpu's .. FreeBSD 5.0 should have the next Generation of SMP that should work great with mysql.. - Original Message - From: "Ken Menzel" <[EMAIL PROTECTED]> To: "Jay Blanchard" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 5:09 PM Subject: Re: MySQL Performance on Dual Processor machine > Just becareful not to use too much memory unless you raise the DMAX > and such values (see /usr/src/sys/i386/conf/LINT ) if mysql runs out > of memory things can get ugly! > > Also just run "show variables" to see the differences in the default > configs. Also you did not say if both machines were the same version > of FreeBSD and if both machine used the same type of SCSI harddisk and > controller. CPU speed does not mean much during inserts, there is > alot of disk writing. > > Ken > - Original Message - > From: "Jay Blanchard" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 30, 2002 3:34 PM > Subject: RE: MySQL Performance on Dual Processor machine > > > > [snip] > > I would suspect other things first such as the my.cnf configuration > > (show variables) or has the kernel been optimised on the old box. > > Did you check kernel configurations and disk subsystems? Also the > > default process size on FreeBSD is 256Meg, so more memory won't > help > > much unless you use it in my.cnf and the kernel configuration allows > > it! > > [/snip] > > > > Amazingly enough (I did not do the install of MySQL) there is no > my.cnf on > > either machine (there are the default my-whatever.cnf files.). I > belive that > > I should use the my-large.cnf as a starting point. Does anyone have > any > > suggestions other than the default configuration for this file? > > > > Thanks! > > > > Jay Blanchard > > Applications Development > > nii communications, inc. > > 210-403-9100 x285 > > > > > > > > > - > > 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
Re: Load Blancing Mysql Max Db Server Between 2 Servers
Yes this is good subject problem is the site this is being used on had data being written to the db so read only system really isn't going to help me. wonder if mysql developers can shed some light on this subject. - Original Message - From: "Jason Yates" <[EMAIL PROTECTED]> To: "Russell E Glaue" <[EMAIL PROTECTED]> Cc: "Frankie Gravato" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 11:55 AM Subject: Re: Load Blancing Mysql Max Db Server Between 2 Servers > On Fri, 2002-04-12 at 11:47, Russell E Glaue wrote: > > > > If your database is read-only, you can use Linux Virtual Server to load > > balance traffic to MySQL servers. > > -RG > > > > > > LVS as you said it is only good for read-only. Are there any solutions > for non read-only load balancing, using replication maybe or nfs? > > Anyone have a solution? I'm really interested in this subject. > > -Jason - 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
Load Blancing Mysql Max Db Server Between 2 Servers
Hello Fellow Mysql Users Is Mysql Max Data Base Server even possible to do loadblancing to spread its load between 2 or more machines. I'm having tough time getting my mysql to work under heavy site load on Dual Cpu FreeBSD 4.5 machine running Mysql max. Any insight would help me at this point. thanks -Fgravato - 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
