List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:July 1 2004 7:31pm
Subject:Finding Tables created by views
View as plain text  
Folks-

I have a table that is chock full of errors..(PLAN shows Table Access full)
so I know that it was created wrong
Is there an easy way to setup a query to locate all views that use this 
table?

Thanks,

Martin Gainty
(cell) 617-852-7822





>From: Bill MacAllister <bill@stripped>
>To: Paul DuBois <paul@stripped>, mysql@stripped
>Subject: Re: mysqld_safe in 4.1.2
>Date: Thu, 01 Jul 2004 09:21:24 -0700
>MIME-Version: 1.0
>Received: from lists.mysql.com ([213.136.52.31]) by mc11-f37.hotmail.com 
>with Microsoft SMTPSVC(5.0.2195.6824); Thu, 1 Jul 2004 09:51:11 -0700
>Received: (qmail 15454 invoked by uid 109); 1 Jul 2004 16:48:37 -0000
>Received: (qmail 20417 invoked from network); 1 Jul 2004 16:21:57 -0000
>Received: pass (lists.mysql.com: local policy)
>X-Message-Info: JGTYoYF78jG+JHHNCikggl2bAzRuoWUi
>Mailing-List: contact mysql-help@stripped; run by ezmlm
>List-ID: <mysql.mysql.com>
>Precedence: bulk
>List-Help: <mailto:mysql-help@stripped>
>List-Unsubscribe: 
><mailto:mysql-unsubscribe-mgainty=hotmail.com@stripped>
>List-Post: <mailto:mysql@stripped>
>List-Archive: http://lists.mysql.com/mysql/168278
>Delivered-To: mailing list mysql@stripped
>In-reply-to: <p06020415bd090b530ef1@[192.168.1.34]>
>Message-id: <0BA9C21F0D52E354E62523EA@wobbly>
>X-Mailer: Mulberry/3.1.5 (Linux/x86)
>References: <5E70D3BB72A4271223D182AB@wobbly> 
><p06020415bd090b530ef1@[192.168.1.34]>
>X-Virus-Checked: Checked
>Return-Path: mysql-return-168278-mgainty=hotmail.com@stripped
>X-OriginalArrivalTime: 01 Jul 2004 16:51:13.0639 (UTC) 
>FILETIME=[9E6F1770:01C45F8B]
>
>
>
>--On Wednesday, June 30, 2004 07:36:23 PM -0500 Paul DuBois 
><paul@stripped> wrote:
>
>>At 13:58 -0700 6/30/04, Bill MacAllister wrote:
>>>Hello,
>>>
>>>I am a bit confused by processing of user= specifications in the
>>>mysqld_safe script.  Here is what I see:
>>>
>>>* If user= is specificed in the [mysqld] or [server] sections then it is
>>>  ignored and a flag is set that prevents the specification of a user
>>>  in any subsequent options parsing.
>>>
>>>* Otherwise the user will be extracted and used from either the
>>>[mysqld_safe], [safe_mysqld], or command line arguements.
>>
>>Not quite.  For security reasons, only the *first* encountered instance
>>of the user option is used, and any others are ignored.
>>
>>http://dev.mysql.com/doc/mysql/en/Server_options.html
>>
>>See the descripion of --user in the option list.
>
>Thanks for the pointer to the documentation.  I just missed it.
>
>But, my reading of the code in mysqld_safe (4.1.2) does not match the 
>documentation.  The first pass through the option sections [mysqld] and 
>[server] have the SET_USER script variable set to 2.  With this value set 
>any user specification is ignored, but specifying a user disables any 
>subsequent user specifications because SET_USER is set to 1.
>
>Also, I don't see any where that would generate warnings if there are 
>multiple user specifications.  It took me quite a while to figure out why 
>my mysqld_safe was trying to run the mysql server as mysql instead of the 
>user that I specified.  Still looks like a bug to me.
>
>Bill
>
>>>
>>>This is counter intuitive if nothing else, and I really don't see
>>>why user should be parsed any differently than any other options.
>>>Am I missing something or is this a bug?
>>
>>It's by intent.
>>
>>--
>>Paul DuBois, MySQL Documentation Team
>>Madison, Wisconsin, USA
>>MySQL AB, www.mysql.com
>
>
>
>+---------------------------------------------------
>| Bill MacAllister
>| 14219 Auburn Road
>| Grass Valley, CA 95949
>| 530-272-8555
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>

_________________________________________________________________
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Thread
Finding Tables created by viewsMartin Gainty1 Jul
  • Re: Finding Tables created by viewsDan Nelson1 Jul