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 Forum 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 06: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-03-2005 12:16 AM
Oracle to MySQL through Unix Z24_2000 UNIX for Dummies Questions & Answers 6 01-16-2004 01:06 PM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 12-16-2007
Registered User
  

Join Date: Sep 2007
Posts: 165
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  
Old 12-16-2007
Technorati Master
  

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

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

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

Join Date: Mar 2005
Location: Large scale systems...
Posts: 2,610
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  
Old 12-16-2007
Registered User
  

Join Date: Sep 2007
Posts: 165
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  
Old 12-20-2007
Registered User
  

Join Date: Sep 2007
Posts: 165
Someone please?
Reply With Quote
Google The UNIX and Linux Forums
Reply

« How to select a particular media from the printer with a UNIX command | maximum tar file size? »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode




All times are GMT -7. The time now is 09:25 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. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0