FANDOM


MySQL Cheat Sheet

MySQL Replication

MySQL Users & Passwords

Upgrading from 5.x to 5.5

  1. upgrading from mysql 5.0.xx to 5.5

I wouldn't say it's straightforward. It depends on how risk-tolerant you are. At a minimum, the mysql_upgrade process needs to happen. I believe that if the data is important, using pt-upgrade to validate that everything still works as expected afterwards is also pretty much a minimal requirement for such a big upgrade. The MySQL manual's upgrading pages for each major version, and the changelogs between those versions, are important to read too. One of the things I try to make everyone aware of when upgrading from 5.0 -> 5.1+ is the change in some of the charset/collations that happened in 5.1.24

In specific this changelog.



This percona blog post mentions the compatibility patches introduced in 5.1.58 by percona:

http://www.mysqlperformanceblog.com/2011/08/17/percona-serve r-5-1-58-12-9/


MySQL Admin ToolsEdit

mysql utilities;
innotop.noarch : A MySQL and InnoDB monitor program
maatkit.noarch : Essential command-line utilities for MySQL
mysqlreport.noarch
mysqltuner.noarch
mysql-utilities.noarch : Scripts for managing and administering MySQL servers
mysql-workbench.x86_64 : A MySQL visual database modeling, administration and querying tool
mytop.noarch

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.