I am having problems with my mysq db. The symthoms are many I'll
list them:
1. some select statements return error when the dataset grows to
a certain size,
I think this is because of defect records.
You do not provide a lot of information to go by.
Getting the obvious questions out of
- At what size of the DB does it fail?
?? do you mean the size of the database?
- Do you have enough disk space for all those records?
Yes.
And then:
Have you run CHECK TABLE on your tables?
midgardstaging.topic check error The handler for the table doesn't support
check/repair
Which
Hi,
I would like to thank everyone (esp Carsten and Jocelyn) who helped me solve
this problem. It now seems that the db now works ok.
For the record, I suggest that isamchk should contain a warning in the help text
that you should not run it when mysqld is running. This combined with isamchk -i
I would /strongly/ advise that you discontinue the use of
the Isam table type in mysql. The Isam table type is a legacy of the mysql 3.22.x
series. If you are using the stable 3.23.x series Myisam is the new default type.
One of the cool things about Myisam is that you CAN repair it while the
