The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Unix is killing mysql or something else is happening Unix is killing mysql or something else is happening
Google UNIX.COM
Forums Portal Register Rules & FAQContribute Members List Arcade Search Today's Posts Mark Forums Read


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
What?s happening in CEP? iBot Complex Event Processing RSS News 0 02-19-2008 05:40 AM
killing a unix job after the job process gets completed dtazv SUN Solaris 7 09-28-2005 04:18 AM
killing unix job after the job process completes dtazv Shell Programming and Scripting 1 07-22-2005 03:44 AM
Ping is happening, telnet is not happening b_manu78 AIX 2 02-02-2005 11:16 PM
Oracle to MySQL through Unix Z24_2000 UNIX for Dummies Questions & Answers 6 01-16-2004 12:06 PM

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-16-2007
Registered User
  

Join Date: Sep 2007
Posts: 133
Unix is killing mysql or something else is happening
I don't know what is happening but none of my queries work. When I start mysql, even the use <database> option fails... So when I start mysql with -A, it atleast opens the database and shows the tables. But now, when I perform even a select option on the database, it hangs... Repair is not working either..

I've tried restarting the mysql server too.... But nothing is working... Can someone kindly advice me on what to do now?
Reply With Quote
Forum Sponsor
  #2 (permalink)  
Old 12-16-2007
Technorati Master
  

Join Date: Mar 2005
Location: Large scale systems...
Posts: 2,469
Am not sure with my suggestion !

Are there any locks in the table ?
Reply With Quote
  #3 (permalink)  
Old 12-16-2007
Neo's Avatar
Neo Neo is offline
Administrator
  

Join Date: Sep 2000
Location: Asia Pacific
Posts: 4,189
Maybe the query is timing out? What are the params in your config file?
Reply With Quote
  #4 (permalink)  
Old 12-16-2007
Technorati Master
  

Join Date: Mar 2005
Location: Large scale systems...
Posts: 2,469
Quote:
Originally Posted by Neo View Post
Maybe the query is timing out? What are the params in your config file?
If you are executing a very complex query, I would suggest to run the explain plan first to determine the cost and the ways to optimize it if its possible
Reply With Quote
  #5 (permalink)  
Old 12-16-2007
Registered User
  

Join Date: Sep 2007
Posts: 133
Thank you for your suggestions. They were huge tables. For some reason, the database got corrupted... I had to directly goto the mysql directory to remove the database. After that when I try to start mysql, it says "Timeout error occurred trying to start MySQL Daemon." and gives me a FAILED message...
Reply With Quote
  #6 (permalink)  
Old 12-20-2007
Registered User
  

Join Date: Sep 2007
Posts: 133
Someone please?
Reply With Quote
Google UNIX.COM
Reply

« How to select a particular media from the printer with a UNIX command | maximum tar file size? »
Thread Tools
Display Modes
Linear Mode Linear Mode




All times are GMT -7. The time now is 12:21 AM.

The UNIX and Linux Forums RSS Feeds - Contact Us - The UNIX and Linux Forums - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0