<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px">
<DIV>Yes, the server has been restarted and it doesn't make a difference.</DIV>
<DIV>The application slows down when a query is running. I'm having the
programmer look over his code to see if it's a design/code issue.</DIV>
<DIV>The server is a IBM x325</DIV>
<DIV>2GB Ram</DIV>
<DIV>4x76GB SCSI 320 drives in a RAID 5 configuration</DIV>
<DIV>Using MyISAM table types</DIV>
<DIV> </DIV>
<DIV>Jon</DIV>
<DIV> </DIV>
<DIV>Jon L. Miller, ASE, CNS, CLS, MCNE<BR>Director/Sr Systems
Consultant<BR>MMT Networks Pty Ltd<BR><A
href="http://www.mmtnetworks.com.au">http://www.mmtnetworks.com.au</A></DIV>
<DIV> </DIV>
<DIV>"I don't know the key to success, but the key to failure<BR> is trying
to please everybody." -Bill Cosby</DIV>
<DIV> </DIV>
<DIV><BR><BR>>>> ranz@devdata.net 2:47:34 pm 7/09/2004
>>><BR>Hi Jon,<BR><BR>Before we go delving into your problems with
MYSQL, and this may have<BR>already been done (but you didn't mention it) ....
Have you tried<BR>restarting either the MYSQL service or the entire server and
see if that<BR>makes any difference?<BR><BR>I'll wait for your reply regards to
this before we explore further.<BR><BR>Many thanks,<BR><BR>Randal
Adamson<BR><BR><BR>-----Original Message-----<BR>From:
plug-bounces@plug.linux.org.au<BR>[<A
href="mailto:plug-bounces@plug.linux.org.au]">mailto:plug-bounces@plug.linux.org.au]</A>
On Behalf Of Jon Miller<BR>Sent: Saturday, 4 September 2004 9:54 AM<BR>To:
plug@plug.linux.org.au<BR>Subject: [plug] MySQL performance
tuning[Scanned]<BR><BR>We are having a problem with our database in that when
several users are<BR>accessing it and a report is being run it slows the network
down<BR>immensely. When running top to check I can see that the mysqld-max
uses<BR>up to 99.9% CPU and about 1-2% memory. The queries are
accessing<BR>database tables in the range of 3-300MB sizes. The server
itself is a<BR>dual Xeon 2.8GHz Hyperthreading with 2GB memory and about
200GB of free<BR>space on the partition of the database. We have about 25
users<BR>accessing the database and plan to have about twice that in the
neat<BR>future.<BR>This is our config file, are there settings that can be
tweaked to use<BR>more memory and less CPU?<BR><BR>The entire system runs on a
2GB backbone with w/ full duplex 100Mbps<BR>switch to each workstation.
Unfortunately the user workstations are<BR>WXPPSP1 and W2KSP4. They access
the database via a VB front-end<BR>client-server
design.<BR><BR>Thanks<BR><BR><BR>[mysqld]<BR>datadir=/var/lib/mysql<BR>socket=/var/lib/mysql/mysql.sock<BR>port=3306<BR><BR>[mysql.server]<BR>user=root<BR>basedir=/var/lib<BR><BR>[safe_mysqld]<BR>err-log
=
/var/log/mysqld.log<BR>pid-file
=
/var/run/mysqld/mysqld.pid<BR>log_slow_queries
=
/var/log/slow-queries.log<BR>long_query_time
= 1<BR>max_allowed_packet = 16M<BR>table
cache =
512<BR>sort_buffer_size =
2M<BR>read_buffer_size =
2M<BR>myisam_sort_buffer_size =
64M<BR>thread_cache
=
16<BR>query_cache
= 32M<BR>thread_concurrency =
32<BR>innodb_buffer_pool_size = 384M<BR>innodb_additional_mem_pool_size =
20M<BR>key_buffer_size =
384M<BR><BR><BR>Jon L. Miller, ASE, CNS, CLS, MCNE<BR>Director/Sr Systems
Consultant<BR>MMT Networks Pty Ltd<BR><A
href="http://www.mmtnetworks.com.au">http://www.mmtnetworks.com.au</A><BR><BR>"I
don't know the key to success, but the key to failure<BR>is trying to please
everybody." -Bill
Cosby<BR><BR><BR><BR><BR>_______________________________________________<BR>PLUG
discussion list: plug@plug.linux.org.au<BR><A
href="http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug">http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug</A><BR>Committee
e-mail:
committee@plug.linux.org.au<BR><BR><BR><BR>_______________________________________________<BR>PLUG
discussion list: plug@plug.linux.org.au<BR><A
href="http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug">http://mail.plug.linux.org.au/cgi-bin/mailman/listinfo/plug</A><BR>Committee
e-mail: committee@plug.linux.org.au<BR><BR></DIV></BODY></HTML>