Hey List,
We have a CentOS VPS with a hosting provider hosting one of our company websites. We are finding recently that about once a week a table will "crash" and needs repairing via phpMyAdmin. This is a recent development as this never used to be a problem. I wondered if any has any insight as to why this might be happening?
Hi James
I am just wondering if there is a problem with the hard drives in the host OS ?
Regards Ian Porter
www : www.codingfriends.com
On 19 Feb 2010, at 13:53, James Bensley jwbensley@gmail.com wrote:
Hey List,
We have a CentOS VPS with a hosting provider hosting one of our company websites. We are finding recently that about once a week a table will "crash" and needs repairing via phpMyAdmin. This is a recent development as this never used to be a problem. I wondered if any has any insight as to why this might be happening?
-- Regards, James ;)
Stephen Leacock - "I detest life-insurance agents: they always argue that I shall some day die, which is not so." - http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html
main@lists.alug.org.uk http://www.alug.org.uk/ http://lists.alug.org.uk/mailman/listinfo/main Unsubscribe? See message headers or the web site above!
On 19/02/10 13:53, James Bensley wrote:
We have a CentOS VPS with a hosting provider hosting one of our company websites. We are finding recently that about once a week a table will "crash" and needs repairing via phpMyAdmin. This is a recent development as this never used to be a problem. I wondered if any has any insight as to why this might be happening
No harm in ruling out something obvious, so when I've seen this before it's turned out to be the disk getting full. Something (like a busy mail spool or large logs) has been taking up disk space which was later freed so it wasn't immediately obvious (but you'd know if the disk was close to full or a bit on the tight side).
On 19 February 2010 13:53, James Bensley jwbensley@gmail.com wrote:
Hey List,
We have a CentOS VPS with a hosting provider hosting one of our company websites. We are finding recently that about once a week a table will "crash" and needs repairing via phpMyAdmin. This is a recent development as this never used to be a problem. I wondered if any has any insight as to why this might be happening?
I'm assuming it's a MyISAM table - they are very easy to "crash"; if anything is left "open" on them when the DB is closed, then they are marked as crashed - for example if your VPS goes through an unclean shutdown, loses connectivity to the (virtual) drives, etc.
Probably the easiest way to get around it is to convert the table to InnoDB, If you can't do that for whatever reason (it will almost certainly have performance implications), then enable the auto-repair option for MyISAM tables in MySQL - either at the command line when you start MySQL or in your my.cnf file - see http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_myi... for details.
HTH,
Greg
-
Greg Thomas -
Ian Porter -
James Bensley -
Mark Rogers