Unix Technical Forum

mysqlmanager safe?

This is a discussion on mysqlmanager safe? within the MySQL General forum forums, part of the MySQL category; --> I've switched over to the mysqlmanager startup system instead of the old mysqld_safe because thats the only supported method ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 05:40 AM
David Sparks
 
Posts: n/a
Default mysqlmanager safe?

I've switched over to the mysqlmanager startup system instead of the old
mysqld_safe because thats the only supported method in mysql5.

I needed to restart a DB so I did a `/etc/init.d/mysqlmanager restart`
which seemed to work, but there were some problems:

- the daemon was no longer accepting connections
- ps showed 2 copies of mysqld running

I also noticed a lot of errors like this in mysqld.err:

070124 15:27:02 [ERROR] /usr/sbin/mysqld: Incorrect information in file:
'./databasename/table.frm'

One of the daemon processes would not respond to kill so eventually I
fired up gdb and killed it (it was stuck on a futex operation). I then
restarted mysql and it went through a huge crash recovery.

A co-worker tells me that mysqlmanager has been known to do this for
ages. Is this true? The DB in question is all InnoDB, approx 150GB in
12 tables. mysql version 5.0.30.

Thanks!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:17 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com