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=gcdmg-mysql-2@m.gmane.org
--_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@gmail.com
> To: mysql@lists.mysql.com
> 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@hotmail.c=
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_--