- Original Message -
From: "matt ryan" <[EMAIL PROTECTED]>
> I need the DIC in the key to keep the record unique, I have thousands
> with everything identical except the DIC.
In your schema you had DIC in the PRIMARY KEY and an additional
(unnecessary?) KEY on DIC.
> I was confused on t
I know it's naff but I've found it quicker to use "myisamchk" with row-sort
than it is to get the MySQL daemon to regenerate keys (and if you know
you're not changing the data file you can tell myisamchk not to copy the
data), unless I've missed something in the MySQL config ...
The only way I kno
If you want to use as little space as possible use char(0) and null/not-null
for your boolean values:
CREATE TEMPORARY TABLE test_bool (i char(5), bool char(0));
INSERT INTO test_bool VALUES
('true',''),('false',null),('true',''),('true',''),('false',null);
SELECT * FROM test_bool WHERE bool is no
Nope.
As far as I'm aware the only disk space being used is in the database's
directory, and that file system has 200Gb spare.
(/tmp has 19Gb free anyway)
Regards,
Tim.
gerald_clark wrote:
Are you running out of temp space?
Tim Brody wrote:
binary MySQL 4.0.20-standard on Redhat 7.2/
binary MySQL 4.0.20-standard on Redhat 7.2/Linux
Dual-proc, 4Gb ram, raid
I'm trying to change an index on a 12Gb table (270 million rows). Within an
hour or so the entire table is copied, and the index reaches 3.7Gb of data.
Then the database appears to do nothing more, except for touching the In