LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 01-15-2010, 07:04 AM   #1
deadeyes
Member
 
Registered: Aug 2006
Posts: 605

Rep: Reputation: 78
mysql "flush logs" or "flush tables with read lock", ... hangs


Hi all,

This is a problem I am having for some time.

The policy is to backup mysql with mysql-zrm.
However at a certain stage it hangs forever.

THis is at the "flush logs".

I tried this manually and it gave the same result.
Even after restarting mysql and the host.

After some googling and trying I found out "flush tables with read lock" gives the same result.

The tables seem to be MyIsam.

I tried with a mysqldump on one server and restore it on a test vm.
I used the same config and flush logs still hangs.
ALso I tried to change some configuration directives... but with the same result

Help would be really appreciated!

Edit: btw, I checked the logfile and didn't found anything (/var/log/mysqld.log)
Edit2: I also did myisamchk -s *.MYI (in all direcoties with db files;actually did it with find command) and it did not return anything so datafiles seem ok.

Last edited by deadeyes; 01-15-2010 at 07:34 AM.
 
Old 01-15-2010, 08:41 AM   #2
Web31337
Member
 
Registered: Sep 2009
Location: Russia
Distribution: Gentoo, LFS
Posts: 399
Blog Entries: 71

Rep: Reputation: 65
Personally, I can't be more of help on this topic, just want to clear some things.
Do you have large amounts of data?
"it hangs": it loads CPU or just silently goes down and doesn't respond: not accepts connections, not replies with anything if accepts, etc? What is your MySQL server version?
Did you ever had same problem on other system(if you previously used that scheme)?
 
Old 01-16-2010, 12:41 PM   #3
deadeyes
Member
 
Registered: Aug 2006
Posts: 605

Original Poster
Rep: Reputation: 78
Quote:
Originally Posted by Web31337 View Post
Personally, I can't be more of help on this topic, just want to clear some things.
Do you have large amounts of data?
"it hangs": it loads CPU or just silently goes down and doesn't respond: not accepts connections, not replies with anything if accepts, etc? What is your MySQL server version?
Did you ever had same problem on other system(if you previously used that scheme)?
If I connect with the mysql client and type flush logs, it just takes forever to get back at the mysql prompt.
It just seems like this is doing nothing.
If I open a new terminal and connect again, this just works.

The database is 1.5 GB data in its whole(mysqldump).

I did a dump and imported it on another system and I got the same problem. Maybe a deadlock? I have no idea how to find this out.
 
Old 01-16-2010, 12:58 PM   #4
Web31337
Member
 
Registered: Sep 2009
Location: Russia
Distribution: Gentoo, LFS
Posts: 399
Blog Entries: 71

Rep: Reputation: 65
tried that with a smaller amounts of data?
what were mysql server versions for both cases? did you try other version?

Last edited by Web31337; 01-16-2010 at 12:59 PM.
 
Old 01-19-2010, 03:24 AM   #5
deadeyes
Member
 
Registered: Aug 2006
Posts: 605

Original Poster
Rep: Reputation: 78
Quote:
Originally Posted by Web31337 View Post
tried that with a smaller amounts of data?
what were mysql server versions for both cases? did you try other version?
No. The customer is using RHEL and the default mysql server.
Dont know by heart what version it is. (but probably a pretty recent ones.)
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get KDE4 to automount all vfat usb-sticks with the "flush" mount option? ssenuta Mandriva 1 01-15-2010 12:14 AM
automatic mail of "Last User Login Logs" & "AIX Logs" nishith AIX 3 12-04-2009 12:42 PM
The "Log out" and "Lock screen" actions cannot be executed through keyboard shortcuts Snood Linux - Desktop 0 04-22-2009 09:30 AM
"Nothing to Flush" during reboot jf_moreira Linux - Networking 3 06-21-2007 12:27 PM
Azureus "flush fails" ivanatora Linux - General 0 12-25-2005 04:04 PM


All times are GMT -5. The time now is 12:43 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration