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  

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 


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 ([]) by 
>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 ( local policy)
>X-Message-Info: JGTYoYF78jG+JHHNCikggl2bAzRuoWUi
>Mailing-List: contact mysql-help@stripped; run by ezmlm
>List-ID: <>
>Precedence: bulk
>List-Help: <mailto:mysql-help@stripped>
>List-Post: <mailto:mysql@stripped>
>Delivered-To: mailing list mysql@stripped
>In-reply-to: <p06020415bd090b530ef1@[]>
>Message-id: <0BA9C21F0D52E354E62523EA@wobbly>
>X-Mailer: Mulberry/3.1.5 (Linux/x86)
>References: <5E70D3BB72A4271223D182AB@wobbly> 
>X-Virus-Checked: Checked
>X-OriginalArrivalTime: 01 Jul 2004 16:51:13.0639 (UTC) 
>--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:
>>>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.
>>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.
>>>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
>| Bill MacAllister
>| 14219 Auburn Road
>| Grass Valley, CA 95949
>| 530-272-8555
>MySQL General Mailing List
>For list archives:
>To unsubscribe:


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