Menu
I though it is a silly question but after searching all over internet could not find an answer. So how do I check if I have Percona or original MySQL installed on the server?
200
To address this challenge, we implemented a “Version Check” feature in Percona Toolkit which will be available in the next release, version 2.1. 4. To activate Version Check, you will call the tool that supports this feature with an option --version-check and the tool will connect to the Percona Version Check database.
Percona is an American company based in Durham, North Carolina and the developer of a number of open source software projects for MySQL, MariaDB, PostgreSQL, MongoDB and RocksDB users.
service mysql status
On a centos/fedora based server, this command is a pseudonym for
systemctl status mysql
it will report
mysqld.service - MySQL Percona Server
If you have percona installed. You may need root permissions.
50
Another way to check is to issue "SHOW PLUGINS" from your mysql client.
If you see anything XTRADB such as XTRADB_READ_VIEW/XTRADB_INTERNAL_HASH_TABLES/XTRADB_RSEG then you know it is Percona Server since they add in XTRADB. That will not be part of Oracle Community.
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
