Current time: 02-23-2020, 12:18 PM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MyISAM Tables keep Crashing
02-10-2016, 11:33 PM
Post: #2
RE: MyISAM Tables keep Crashing
First consideration is your hosting.

Whether you're using MyISAM or InnoDB, repetitive crashes relate to unstable hosting.

Your first question then becomes, "Is this a hobby project or a money project?"

For Hobby sites, ignore the problem. For Money sites, move to fast stable hosting.

What I do for my clients, to maintain stable database system is...

1) Use MariaDB rather than MySQL. It's faster + more stable + recovers faster when problems occur.

2) Run mysqltuner + mysql-tuning-primer, retuning database every day for first week of hosting, then once a week thereafter, till no tuning suggestions are presented.

3) Track database error log + slow query log + /tmp usage (used when SELECTs exceed memory buffers) + resolve all problems as they arise.

Reasons for repeat table crashes include...

1) Interrupted long queries, or updates which will show up in one of the database logs, if correct logging is enabled.

2) Incorrect configuration/use of BINARY LOGs.

3) /tmp filing up

4) Database disk filing up

5) Connections broken during database transaction

And the list goes on...

Only way to know for sure is have access to all system logs + database logs + have correct database logging enabled.

If this is a Money site, likely best you hire an expert to fix your site.

Also likely you'll require changing hosting companies.

Like help speeding up your site? Skype me @ ID davidfavor for a quote. Be sure to include your site name in your Skype Add Contact request.
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
MyISAM Tables keep Crashing - hotdot - 01-28-2016, 01:02 PM
RE: MyISAM Tables keep Crashing - dfavor - 02-10-2016 11:33 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)