mysql getting dead on high load

[shivendra]

this is serious issue and this is 2nd time iam getting this problem

today and 2days before my server get down .Db got dead might be on high load .
when i checked server responds mysql error

mysqld dead but subsys locked

and i can't do any thing.i restarted server and it recover innodb .

can any one tell me why always mysql get dead on high load.
is their any way to limit customer login.
pls.give solution iam in big problem

[jojo]

just a guess as your information is not accurate enough: the server might have not enough memory and started swapping

[shivendra]

urgent help


mysql db got hand and database not showing ticket detail from frontend.


when customer login gives error messages..

Error Message: No article found for TicketID 413!

Backend ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Wed Jan 2 10:14:26 2013 Message: No article found for TicketID 413! Traceback (4907): Module: Kernel::Modules::CustomerTicketOverview::ShowTicketStatus (v1.4.2.2) Line: 423 Module: Kernel::Modules::CustomerTicketOverview::Run (v1.4.2.2) Line: 348 Module: Kernel::System::Web::InterfaceCustomer::Run (v1.63) Line: 998 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_customer_2epl::handler (unknown version) Line: 46 Module: (eval) (v1.44) Line: 204 Module: ModPerl::RegistryCooker::run (v1.44) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.44) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31



and agent can't open ticket view.

pls its urgent help

[shivendra]

mysql log error



130102 10:38:36 [ERROR] /usr/libexec/mysqld: Table './ticket/article' is marked as crashed and should be repaired


pls.guide me

[jojo]

Your DBA (database administrator) should be able to help you
also reading the MySQL Admin Documentation will give you the answer: http://dev.mysql.com/doc/refman/5.5/en/index.html

[shivendra]

i dont have any DB admin.

server is under mine so i have to take care.

so can u tell me why this issue is frequently coming

[jojo]

see my first post on this thread.

[shivendra]

ok....

yesterday suddenly mysql/httpd load get high infact their is not alot connection.their is only 39 session .
when i checked mysql server it respond dead.

iam not able to login into mysql from backend also.i reboot the server.
server also get stuck at boot.
i run fsck -A -y command at boot .

it recover Innodb and server started once again .
after that otrs started again and checked the load .avg.load of server goes upto 37.
in this satiuation no agent are able to login and otrs gets loading browser.
i messup a lot till today.and i failed to stable the load .
finally when load goes down and login sucessfully then got another issue .
while clicking on any ticket to view, no agent are able to see ticket detail in ticketView.

then i check mysld log.it show
130102 10:38:36 [ERROR] /usr/libexec/mysqld: Table './ticket/article' is marked as crashed and should be repaired

article is crashed.

i run repair also from Phpmyadmin but no effect.
i tried alot to recover but i can't .

finally i restore 1days before data and run .

--------------------------------------------------

now when i am restoring currupted bkup in bkup linux server it show only article table .rest table not showing.

what is the issue please....tell me...it will eat my job.

also pl. provide me proper backup and restoration of db into another otrs server.