CREATE INDEX problems on sparse column of huge table

2003-03-23 Thread Steve Allaway
I am trying to create indexes on several columns of a huge table in MySQL 4.0.12 running on Windows 2000 Server. The table contains 42 million rows, and occupies about 7G of disk space. The server is a 1.5GHz P4 with 1G RAM, and performs fairly well - the load data infile takes from 22 - 28

Index problems

2002-04-03 Thread Egor Egorov
João, Monday, April 01, 2002, 9:12:04 PM, you wrote: JPV Hello everybody, JPV I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I JPV get the following error: JPV [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.* JPV myisamchk: error:

Index problems

2002-04-02 Thread João Paulo Vasconcellos
Hello everybody, I am running mysql-3.23.47 on FreeBSD 4.5, and everytime I use myisamchk I get the following error: [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.* myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a correct index

Index problems

2002-04-02 Thread João Paulo Vasconcellos
Hello everybody, I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I get the following error: [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.* myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a correct index