I can't seem to properly wrap my brain around left joins. If anyone
knows of a good tutorial somewhere, I'd appreciate it. That having been
said, I was hoping someone could help with this query I'm trying to do
as I've been horribly unsuccessful.
3 tables: goal (own goals), goalopp (opponent
A few weeks ago, my mysql 3.23.46 server spontaneously started changing
its data directory to /var/tmp/ once or twice a week, and once or twice
a day for a short span. Nothing in the error file. Anyone seen anything
like this or have any idea what's going on? I changed the data directory
to a
Assuming you have the developer tools installed, it compiles just fine:
./configure
make
make install
if you don't have the dev tools, check VersionTracker. Someone probably
has the binaries packaged up.
On Tuesday, April 2, 2002, at 01:11 PM, Bensin Joseph wrote:
I have MACOSX 10.1.3.
Well, first off, I can't seem to get max_allowed_packet higher than 64
MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are
reflected in the system settings, but only up to 64 MB, then regardless
of what I put in there, it stays at 64 MB. But like I said, the file is
only
I've been using a perl script to insert a very large blob (up to about 8
MB) into a DB successfully, but now I need to do it with a 34 MB BLOB,
so I upgraded to MySQL 4.0.1. First off, I can't get
max_allowable_packet to go higher than 64M, regardless of what I set it
to, but that shouldn't
I've got a large table with, amongst other things, two indexed varchar
fields. Individual queries,
SELECT count(*) FROM orders WHERE email != 'control';
is fast (0.01 sec), and
SELECT count(*) FROM orders WHERE distdate LIKE '07/%/2001';
is fast (0.02 sec). But,
SELECT count(*) FROM
Well, I successfully solved our 2 gig file limit problem with RAID
tables without too much hassle, despite a dearth of documentation.
However, it has introduced another significant problem. It would seem
mysqldump isn't smart enough to look for raided tables. Taking the
server down to do