On Thu, Mar 12, 2009 at 8:41 AM, mos wrote:
> I have 3 tables that are 1:1 and will always have a row for a given
> product,_code & date. If I want to join them together, is it going to be
> faster to use an equi join or a left join, or does it matter?
>
IIRC:With an inner join the optimizer has
make all-am
Making all in mysql-test
Making all in lib/My/SafeProcess
g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3
-fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP
-MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc
In file included from safe_
IIRC it does not matter. But you can double-check my opinion with EXPLAIN.
A.
On Thu, Mar 12, 2009 at 11:41 AM, mos wrote:
> I have 3 tables that are 1:1 and will always have a row for a given
> product,_code & date. If I want to join them together, is it going to be
> faster to use an equi joi
I wanted to respond with what I found:
APPARMOR blocks mysql from writing to any other directory than the data
dir and /tmp.
I had to edit the /etc/apparmor.d/usr.sbin.mysqld file and add the
following:
/backups/mysql** rwk,
to the bottom.
Hope this helps someone.
Ray
--
MySQL General
