MySQL Forums
Forum List  »  InnoDB

show innodb status output
Posted by: Josh fdsafda
Date: July 28, 2009 08:51AM

I'm using the following command to redirect "show innodb status" output to a file:

./bin/mysql --port=<portnum> --socket=/<path_to_file>/mysql.sock -u <un> -p'<pw>' -e"show innodb status" > out_file.dat


The output is placed on "ONE" line with \n as the line terminator.

Status\n=====================================\n090728 9:57:11 INNODB MONITOR OUTPUT\n=====================================\nPer second averages...

is there a "best" method for reformating this file into a readable version? I'm currently using mysql_5.0.67 sparc 64 bit on Solaris 8. I'm guessing there is a unix solution however for this however I'm not making much progress.

Thanks,

Josh

Options: ReplyQuote


Subject
Views
Written By
Posted
show innodb status output
3436
July 28, 2009 08:51AM
1713
July 29, 2009 01:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.