I’ve started using Percona’s version of MySQL 5.1 and have run into a few issues trying to get other tools such as mytop or maatkit to install but have been having problems with RPM dependency’s. I found the solution on this guy’s blog. Basically, if you install the MySQL-client-percona, MySQL-percona, MySQL-server-percona, MySQL-shared-percona and Percona-XtraDB, instead of installing MySQL-shared-percona, you should download and force upgrade (rpm -Uvh –force packagename) the MySQL-shared-compat library directly from MySQL. Just make sure you get the same version from MySQL that you’re using of the Percona MySQL.
Useful RPM commands
Dec
12
Now that 64bit systems have come along, I’ve come across issues using just
rpm -qa
If you have package that installs both a x86 & x86_64 package, it will only show the package name once for both packages.
Try the following, it will list all packages along with the arch type
rpm -qa --queryformat "%{NAME}-%{VERSION}.%{ARCH}\n"
How to find what RPM provides what files
Dec
12
Have you ever tried to find where a specific file came from? If it was installed from an RPM, there is an easy way. Just use the following command.
rpm -q --whatprovides /path/to/file
