Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Table Size Killer?

Table Size Killer?

Table Size Killer?

Mysql recently crashed my Linux box during a cron. Mysql quit responding and then the cron keep opening mysql until it cooked the memory. I rebooted, and now I can't restart mysql, I can't use mysqldump or mysqladmin either. They all just hang.

Could it be possible that the table locked up because it exceeded size limits? I have been able to run myisamchk and it says it fixed some errors, but still mysql will not start. The error logs are really of no help in determining what happened as far as I can tell.

My system info:
Linux 2.2.14-5.0 #1 i686

mysql  Ver 10.8 Distrib 3.23.21-beta, for pc-linux-gnu (i686)

My error log tells me this:
[Thu Feb 15 20:26:33 2001] [info] [client] (32)Broken pipe: client stopped connection before rflush completed
[Fri Feb 16 06:03:48 2001] [error] (23)Too many open files in system: accept: (client socket)

The mysql error log says this:
mysqld ended on  Sun Feb 25 22:16:34 EST 2001
mysqld started on  Sun Feb 25 22:16:41 EST 2001
/usr/sbin/mysqld: Can't change dir to '/host/' (Errcode: 2)
010225 22:16:41  Aborting

mysqld ended on  Sun Feb 25 22:16:41 EST 2001
mysqld started on  Sun Feb 25 22:17:06 EST 2001
Please read "Security" section of the manual to find out how to run mysqld as ro
010225 22:17:06  Aborting

Any help is appreciated.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close