MySQL Forums
Forum List  »  Performance

Re: Performance Schema Does Not Initialize
Posted by: Format Dynamics
Date: July 05, 2012 03:59PM

I had this issue when going from cluster 7.1.18 to 7.2.6
I noticed the performance_schema database and dir existed, but no .frm files in the dir
I ran mysql_upgrade on my 1st access node (i have 2 of them) and that created the .frm files on that node, but after running mysql_upgrade on the 2nd access node, the .frm files get removed from the 1st access node (though added on the 2nd node).
I haven't found out how to keep the .frm files on all access nodes (and not just 1), short of keeping a copy of the .frm files in a template-like dir and having the startup script copy them to the performance_schema/ dir on every restart.
Even setting performance_schema=off in my my.cnf file didn't stop it from looking for the tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Performance Schema Does Not Initialize
3820
July 05, 2012 03:59PM


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.