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

3 posts   •   Page 1 of 1
UTHAI
 
Posts: 7
Joined: Wed Sep 25, 2013 8:51 am

mysql database crashing frequently

by UTHAI » Mon Oct 07, 2013 6:55 pm

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
 
Posts: 25
Joined: Fri Sep 20, 2013 6:07 pm

Re: mysql database crashing frequently

by amit » Wed Oct 09, 2013 4:12 pm

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"

User avatar
JimmyTrerb
 
Posts: 5
Joined: Fri Dec 25, 2020 4:17 pm
Location: Saudi Arabia

-

by JimmyTrerb » Sun Apr 25, 2021 7:24 pm

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

3 posts   •   Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest

It is currently Tue Oct 19, 2021 7:35 am