> Baron Schwartz wrote:
>> Hi Joseph,
>>
>> Joseph Koenig wrote:
>>> Hi,
>>>
>>> I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I
>>> moved the
>>> data directory of MySQL. I updated everything that SELinux
> Hi,
>
> CA Lists wrote:
>>> Hi Joseph,
>>>
>>> Joseph Koenig wrote:
>>>> Hi,
>>>>
>>>> I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the
>>>> data directory of MySQL. I updated e
;s driving me nuts. Is there any way to
create the necessary tables now so that MySQL does actually start logging
everything they way it should be able to and also will make these errors go
away? Thanks in advance,
Joe
--
Joseph Koenig
Creative Anvil, Inc.
Ph: 314.773.2611
FX: 314.773.2
How stable is version 4.x? This database will be moved into production
fairly shortly and I need to make sure the version of mysql is extremely
stable. Thanks,
Joe
> From: Victor Pendleton <[EMAIL PROTECTED]>
> Date: Wed, 23 Oct 2002 14:40:58 -0500
> To: "'Joseph Ko
Wed, 23 Oct 2002 14:00:29 -0500
> To: Joseph Koenig <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Optimizing Query to use Index in ORDER BY
>
> Does explain say an index is used on pt for the join?
> Only one index per table is used in a query.
> It is probably
Hi,
I'm having trouble getting the following query to use the indexes on the
order by.
SELECT vr.muzeid, vr.releaseformat, vr.releasestatus, vr.collectorsedition,
pt.title FROM v_videorelease vr, v_producttitle pt, v_prodcategory pc WHERE
pc.muzeid = vr.muzeid AND pt.muzeid = vr.muzeid AND vr.rel
