0

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?

  • What version of Mysql5.5 are you using? You need at least 5.5.3 to have performance_schema available. – Jesus Uzcanga Jul 25 '18 at 17:47
  • version 5.5.45. I've updated my question. – Vincent Jul 25 '18 at 23:24
  • it looks like I have three options for installing the sys schema You forget the most important step - full backup. – Akina Jul 26 '18 at 4:49
  • Yes, a full backup is good advice, but I wasn't listing steps. I was listing options. – Vincent Jul 26 '18 at 14:54
0

Option 4: Download it from github and install it manually.

Installation would work like this:

# mysql -uroot -ppassword < sys_56.sql

(I'm aware you're using MySQL 5.5. Please read on...)

When you examine what this does, you see that a separate schema is created and in this schema some procedures, functions, views and tables are created. Nothing too fancy. I can't imagine, that this would have any dramatic influence on the server.
Regarding compatibility with 5.5, I must admit that I'm not familiar with 5.5, but given that it's just some views and so on in a separate schema, I'd say that it either works or it doesn't. I personally wouldn't mind at all. Try it on a VM or docker container or whatever, if you like.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.