From: Martin Gainty (mgaintyhotmail.com)
Date: Wed Oct 28 2009 - 07:44:44 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 serious 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 other tables so as to place those columns into discrete tables which would be created/named based on functionality..associations between tables should always be unique
and may involve concatenated columns the most famous example is OrderLine Item which consists of
OrderID from Order-Header and OrderLineItemID

i hope this addresses your requirement
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.

> Subject: Open Tables
> From: sangprabvgmail.com
> To: mysqllists.mysql.com
> Date: Wed, 28 Oct 2009 18:59:44 +0700
>
> I saw so many open tables in my server, is it dangerous? And if I
> execute flush tables what does it impacts to the open tables? Thx.
>
>
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgaintyhotmail.com
>
                                               
_________________________________________________________________
Windows 7: Simplify your PC. Learn more.
http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen1:102009

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]