From: Martin Gainty Date: October 28 2009 12:44pm Subject: RE: Open Tables List-Archive: http://lists.mysql.com/mysql/219169 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_babc7b3b-22b0-4f77-8b04-5b4865f0497d_" --_babc7b3b-22b0-4f77-8b04-5b4865f0497d_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Will Generally this means you need to look at the schema design of your database= system If you are running a simple contact Database for Mom and Pop store and you = have connections to 100 tables open then you would want to take a more seri= ous look at the schema you are using to merge information from spurious one= off tables..this process is called de-normalisation.. the effort would be to take the most often requested column of a table and = integrate that columns definition and data into the driver table to reduce = the IO and any possible contention of a join condition if on the other hand you are running a enterprise portal with 1000 requests= /second with just a few tables open you would want to normalise the data and separate the columns into oth= er tables so as to place those columns into discrete tables which would be = created/named based on functionality..associations between tables should al= ways be unique and may involve concatenated columns the most famous example is OrderLine I= tem which consists of=20 OrderID from Order-Header and OrderLineItemID i hope this addresses your requirement Martin Gainty=20 ______________________________________________=20 Verzicht und Vertraulichkeitanmerkung =20 Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen. > Subject: Open Tables > From: sangprabv@stripped > To: mysql@stripped > Date: Wed=2C 28 Oct 2009 18:59:44 +0700 >=20 > I saw so many open tables in my server=2C is it dangerous? And if I > execute flush tables what does it impacts to the open tables? Thx. >=20 >=20 >=20 >=20 > Willy >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 =20 _________________________________________________________________ Windows 7: Simplify your PC. Learn more. http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=3DPID24727::T:= WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen1:102009= --_babc7b3b-22b0-4f77-8b04-5b4865f0497d_--