| Author |
Message |
Jim_UK
Board Member
Joined: 19 Nov 2008
Posts: 562
Location: North West UK
|
 Posted: Fri Jun 12, 2015 1:13 pm
Post subject: Table crash |
|
|
For the very first time I have just experienced my database crash. This was a single table in the database (sessions table)
What would be the most likely cause of a table such as "sessions" crashing or is it just one of those things and I have been lucky up to now?
The whole server had been down for unknown reason and had just been rebooted. Could that be the cause?
Jim
_________________
The truth is out there.
Unfortunately they will not let you anywhere near it! |
|
| Back to top |
|
|
StarWolf3000
Board Member
Joined: 10 Jun 2010
Posts: 107
Location: Germany
|
Posted: Sun Jun 14, 2015 8:54 am
Post subject: Re: Table crash |
|
|
Is your sessions table using the default MyISAM engine? In most cases MEMORY would be the better storage engine (you can change it with ALTER TABLE prefix_sessions ENGINE=MEMORY; ).
This stores the structure of the table on disk, but it's contents in RAM of the server (make sure your server has enough RAM and MySQL enough assigned), emptying the table when MySQL is stopped/restarted.
To repair the sessions table:
REPAIR TABLE prefix_sessions;
If your server rebooted without a MySQL clean shutdown, this can lead to a problem with tables, when data is written to the disk during that moment. Normally, MySQL autochecks most databases and tables on startup and tries to repair them on its own (or prompting the user to do that, only with shell access), but there can always be some lost or corrupted data.
A lot of database related problems in phpBB 2.x origin of corrupted sessions tables. |
|
| Back to top |
|
|
Jim_UK
Board Member
Joined: 19 Nov 2008
Posts: 562
Location: North West UK
|
Posted: Sun Jun 14, 2015 9:02 am
Post subject: Re: Table crash |
|
|
Thanks for the info. I shall monitor it for a while before deciding whether to make any change. That is the first table crash in 10 years.
Jim
_________________
The truth is out there.
Unfortunately they will not let you anywhere near it! |
|
| Back to top |
|
|
Matuse
Board Member
Joined: 18 Apr 2017
Posts: 1
|
Posted: Sat Apr 22, 2017 7:24 am
Post subject: Re: Table crash |
|
|
| Jim_UKe wrote: | Thanks for the info. I shall try the Yoga Burn monitor it for a while before deciding whether to make any change. That is the first table crash in 10 years.
Jim |
I've had one of those rare occasional crashes after years of running perfectly recently, just like yourself. |
|
| Back to top |
|
|
Jim_UK
Board Member
Joined: 19 Nov 2008
Posts: 562
Location: North West UK
|
Posted: Sat Apr 22, 2017 7:30 am
Post subject: Re: Table crash |
|
|
We have had no problems since that incident.
Have you run a repair on your database tables?
Jim
_________________
The truth is out there.
Unfortunately they will not let you anywhere near it! |
|
| Back to top |
|
|
DanielBenford
Board Member
Joined: 20 Jul 2018
Posts: 1
|
Posted: Fri Jul 20, 2018 2:47 am
Post subject: Re: Table crash |
|
|
| Matuse wrote: | | Jim_UKe wrote: | Thanks for the info. I shall try to monitor it for a while before deciding whether to take phenq will make any change. That is the first table crash in 10 years.
Jim |
I've had one of those rare occasional crashes after years of running perfectly recently, just like yourself. |
I've also experienced a crash once after 5-6 years of running with no problem. One table got corrupted, but backups helped. No problem experienced since then. |
|
| Back to top |
|
|
Jim_UK
Board Member
Joined: 19 Nov 2008
Posts: 562
Location: North West UK
|
Posted: Fri Jul 20, 2018 9:01 am
Post subject: Re: Table crash |
|
|
Still just had the one table crash and now at 14 years.
I do of course do regular database backups "just in case"
Jim
_________________
The truth is out there.
Unfortunately they will not let you anywhere near it! |
|
| Back to top |
|
|
JLA
Board Member
Joined: 30 Apr 2009
Posts: 310
Location: U.S.A
|
Posted: Mon Jul 23, 2018 8:32 pm
Post subject: Re: Table crash |
|
|
We've found it helpful to run scheduled optimize and repairs on tables. Also for INNODB it has been helpful to have each table have its own file....
_________________
http://www.jlaforums.com |
|
| Back to top |
|
|
Manuelm
Board Member
Joined: 02 Aug 2018
Posts: 1
|
Posted: Thu Aug 02, 2018 9:40 am
Post subject: Re: Table crash |
|
|
| Matuse wrote: | | Jim_UKe wrote: | Thanks for the info. I shall try the Yoga Burn monitor it for a while before deciding whether to make any change. That is the first table crash in 10 years.
Jim |
I've had one of those rare occasional crashes after years of running perfectly recently, just like yourself. |
I had my first one the other day after 8 years of perfect running. I've been doing backups since the start and I can tell you, all of that extra time backing things up did pay off in the end  |
|
| Back to top |
|
|
Jim_UK
Board Member
Joined: 19 Nov 2008
Posts: 562
Location: North West UK
|
Posted: Thu Aug 02, 2018 11:01 am
Post subject: Re: Table crash |
|
|
I used to do a daily backup using Msqldumper but have reduced it to about once a week.
Daily is better of course. 
Jim
_________________
The truth is out there.
Unfortunately they will not let you anywhere near it! |
|
| Back to top |
|
|
|
This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.
