From: Martin Gainty Date: November 9 2008 5:01pm Subject: RE: Tuning a MySQL desktop database List-Archive: http://lists.mysql.com/mysql/215152 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_5ed60b39-317d-42ec-a303-4e482e72225e_" --_5ed60b39-317d-42ec-a303-4e482e72225e_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Quiesce ALL slaves if you have master/slave DB's Once you've implemented explain plans..check any SQL statements which produ= ce Full Table Scans If so You'll want to implement Indexes on columns for those join= conditions to implement a Unique Constraint you will need to extract out the data and reload as The table now accepts u= nique data items only Get familiar with export routines available via mysqladmin to export the da= ta recreate the Tables with the Unique column constraint create the indexes to use those unique columns and finally use mysqladmin to import the data to those tables HTH Martin=20 ______________________________________________=20 Disclaimer and confidentiality note=20 Everything in this e-mail and any attachments relates to the official busin= ess of Sender. This transmission is of a confidential nature and Sender doe= s not endorse distribution to any party other than intended recipient. Send= er does not necessarily endorse content contained within this transmission.= =20 > Date: Sun=2C 9 Nov 2008 12:44:29 +0100 > From: s.nait-mouloud@stripped > To: passionate_programmer@stripped > Subject: Re: Tuning a MySQL desktop database > CC: mysql@stripped >=20 > Hello=2C >=20 > Here=2C you can get some help: > http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-serv= er-after-installation/ >=20 > Regards. > ---- > Salah NAIT-MOULOUD > www.echovox.com | www.m-boost.com >=20 > On Sun=2C Nov 9=2C 2008 at 12:33 PM=2C RP Khare > wrote: >=20 > > > > We are testing MySQL in production environment with real data. When the > > application is ready and all tests have been conducted well=2C we will = finally > > migrate to MySQL Enterprise. > > > > At present our application is running on a desktop machine with MySQL 5= .1 > > Community Edition installed on it. MySQL 5.1 is using default settings. > > > > Machine is: Pentium 4 with 256 MB RAM. > > > > What settings I need to change to tune MySQL? > > > > ............... > > Rohit. > > > > _________________________________________________________________ > > Movies=2C sports & news! Get your daily entertainment fix=2C only on li= ve.com > > http://www.live.com/?scope=3Dvideo&form=3DMICOAL _________________________________________________________________ Stay up to date on your PC=2C the Web=2C and your mobile phone with Windows= Live http://clk.atdmt.com/MRT/go/119462413/direct/01/= --_5ed60b39-317d-42ec-a303-4e482e72225e_--