Any ideas why the following upgrade from ISAM to MyISAM fails:
mysql alter table users type = MYISAM;
ERROR 1036: Table 'users' is read only
This only occurs for about half the tables I tried to upgrade.
Thanks!
Paul
-
Hey everyone. I figured it out.
Packed tables are read only.
Thanks!
Paul
-Original Message-
From: Paul Borghese [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 9:26 PM
To: [EMAIL PROTECTED]
Subject: Upgrade from ISAM to MyISAM fails with read only error
Any ideas why
I am running MySQL 3.23.46 under Linux kernel 2.2.20 as the back-end of
an active website. On occasion mysql seems to stop responding. When I
log into the server one of the MySQL processes is consuming a
substantial amount of CPU resources (i.e. it is on the top of the list
when viewing the
Thanks Benjamin,
I found that kill -9 seems to be the only way to kill the hung process.
I'll see if I can find another way.
Here is the output of mysqlbug:
Submitter-Id: Paul Borghese
Originator:-
Organization:-
MySQL support: [none]
Synopsis: MySQL process hanging
Severity