Thanks for the hint. I'll try it with more tablespace.
The indexes have been optimized pretty much. I have to check whether I
can send you the table layout.
Just for your information. 3.23.38 has the same problem.
Heikki Tuuri wrote:
>Frank,
>
>there is obviously a bug in the insert buffer co
On Wed, May 16, 2001 at 10:58:18PM +0200, Frank Schroeder wrote:
>
> Is there a way of turning the transactional logging off during the
> load of a table? I know that I'm out on my own then but this table
> is loaded only every once in a while.
>
> Am I running out of space on the log/or data fi
Hi,
I'm trying to load a large table with 7 million records, 50 columns and
27 indexes into an innodb table. Works fine for MyISAM. Compressed size
of the data file is about 280MB (830MB uncompressed) and 1.5 GB for the
index file. Platform is RedHat Linux 6.2 with kernel 2.2.16-3 and MySQL
is 3.
