mysql database crashing frequently Any dynamic application requires database. You can have discussion of databases like MySQL, MSSQL, Oracle and more.

[UTHAI]

Hi,

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?

[amit]

Hi,

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
Hardware failures.
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"

[JimmyTrerb]

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.