Thanks guys,
Actaully my Hard disk is 10G, just for one table. There is enough table
space. I noticed when I created index for 1.9G table, at the first phase,
mysql copy table, but mysql doesn't write to the tmp index file, I means the
filesize of the tmp index didn't increase. When I create in
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote:
> On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
> > I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
> > create indexs for it, I couldn't finish after 4 hours.
>
> You mean it was still running?
On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
> I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
> create indexs for it, I couldn't finish after 4 hours.
You mean it was still running? Was there still disk or CPU activity
after 4 hours?
>
Hello MySQL,
I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
create indexs for it, I couldn't finish after 4 hours. But when I reduce the
records to 16,000,000, about 1.9G, the same index can be finished within 35
minutes. Can anyone explain it? Thanks in advance.
I a
