- 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.
Post a job, hire, collaborate and pay in our secure online workplace.
Find projects related to your professional skill sets.
Top-Rated Freelancers Ready To Work. Find Someone Perfect For Your Team.
Commission Available For Every Projects Done by Your Referrals.
Who is online
Users browsing this forum: No registered users and 4 guests
It is currently Thu Nov 30, 2023 7:53 am