The reason I'm asking is because I need to install the sys schema on my database so that I can utilize performance_schema because I'm hoping that will help me figure out why mysql is crashing every 30 minutes exactly.
I am running MySQL 5.5.45 on Windows Server 2016. I have four schemas on this server, of which the production schema is 4.1GB in size. The other schemas are almost as big.
MySQL Workbench gives me an option to install it. Also, I understand that running mysql_upgrade will install it, which as far as I can tell simply executes mysqlcheck.
So it looks like I have three options for installing the sys schema.
- Execute mysqlcheck (I think)
- Execute mysql_upgrade
- Click the install button on MySQL Workbench
What does MySQL Workbench do exactly? Does it simply execute mysql_upgrade or mysqlcheck? Or does it do the install a different way?
Will any or all of these options make my other schemas unusable while this install is executing (as in locking tables)? What other implications are there to using any of these three options? And most importantly, needing to install this on a production server, what is my best approach?