On Sat, 2002-02-02 at 20:22, Egor Egorov wrote:
> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
Hi,
Would the REPLACE .. SELECT be faster if i use LOCK TABLES as it says in
the manual for the INSERT command ?
It's a REPLACE .. SELECT for thousands of rows.
Thanx,
--
Dia
On Monday 04 February 2002 14:02, Henry Hank wrote:
> >> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
>
> That suggests using LOAD DATA INFILE, but I would really like to avoid
> dumping a very large ISAM mysql table to a text file, just to load it back
> into another tabl
>> Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
That suggests using LOAD DATA INFILE, but I would really like to avoid dumping
a very large ISAM mysql table to a text file, just to load it back into another
table (MYISAM).
I was looking for answers as to why isamchk w
Henry,
Saturday, February 02, 2002, 12:25:16 AM, you wrote:
HH> Hello,
HH> Under mysql 3.22.29, I was able to use isamchk to disable all index keys (-r
HH> -k0), do millions of inserts into the table, then re-enable all the indexes
HH> again with "isamchk -r -k4" (4 indexes). I'm testing out
Hello,
Under mysql 3.22.29, I was able to use isamchk to disable all index keys (-r
-k0), do millions of inserts into the table, then re-enable all the indexes
again with "isamchk -r -k4" (4 indexes). I'm testing out a new Redhat 7.2
Linux server with mysql 3.23.41, and am attempting to load
