- Posts: 7
- Joined: Wed Sep 25, 2013 8:51 am
I am running mysql 5.5 on debian server. I was stable since few years but suddenly I started getting error message of database. I checked logs and found messages like this.
121218 3:00:00 [ERROR] /usr/sbin/mysqld: Table 'tablename' is marked as crashed and should be repaired
121218 3:00:00 [ERROR] /usr/sbin/mysqld: Sort aborted: Table 'tablename' is marked as crashed and should be repaired
Its been more than 5 days not its crashing every early morning. Can anyone tell me what is the permanent solution for this?
- Posts: 25
- Joined: Fri Sep 20, 2013 6:07 pm
Can you please let me know the table type MYISAM/INNODB ?
MySQL MYISAM tables are crashing probably due to following reasons.
The mysqld process is killed in the middle of a write
A software bug in the MySQL or MyISAM code.
You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time
If its getting frequent problem than you should change table to innodb for getting best performance.
you can search "myisam vs InnoDB"
- Posts: 5
- Joined: Fri Dec 25, 2020 4:17 pm
- Location: Saudi Arabia
when i tried to add a datafile, i am getting error like:
ORA-01118: cannot add anymore datafiles: limit of string exceeded
What is the problem and how can i fix it? FreelanceJobsDB | Freelance Jobs Online | Freelance Job Marketplace
Hire top freelancers: developers, web designers, writers and all kind of experts. Find freelance jobs on FreelanceJobsDB, the leading freelance marketplace.
How does it work?
Post a job, hire, collaborate and pay in our secure online workplace. Find Freelance Projects
Find projects related to your professional skill sets. Browse Freelance Talent
Top-Rated Freelancers Ready To Work. Find Someone Perfect For Your Team. Referral Program
Commission Available For Every Projects Done by Your Referrals. Visit Site
Who is online
Users browsing this forum: No registered users and 1 guest
It is currently Mon May 10, 2021 11:38 pm