Hello @all,
I recently found about Percona and I decided to give it a try.
Till now I was using the default version of MySQL server for CentOS which
is MySQL 5.0.95.
What I did was to remove mysql-server mysql and their dependencies
$ yum erase mysql-server mysql
Installed the Percona yum repo
$ rpm -Uhv
http://www.percona.com/downloads/percona-release/percona-release-0.0-...
Installed the required packages
$ yum install Percona-Server-client-55.x86_64
Percona-Server-shared-compat.x86_64 Percona-Server-server-55.x86_64
And the following message appeared.
120829 10:42:48 [Note] Flashcache bypass: disabled
120829 10:42:48 [Note] Flashcache setup error is : ioctl failed
ERROR: 1136 Column count doesn't match value count at row 1
120829 10:42:49 [ERROR] Aborting
120829 10:42:49 [Note] /usr/sbin/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/sbin/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
Percona Server is distributed with several useful UDF (User Defined
Function)
fr
om Maatkit.
Run the following commands to create these functions:
mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME
'libmurmur_udf.so'"
See http://code.google.com/p/maatkit/source/browse/trunk/udf for more
details
Installed:
Percona-Server-client-55.x86_64 0:5.5.27-rel28.0.291.rhel5
Percona-Server-server-55.x86_64 0:5.5.27-rel28.0.291.rhel5
Percona-Server-shared-compat.x86_64 0:5.5.27-rel28.0.291.rhel5
Dependency Installed:
Percona-Server-shared-55.x86_64 0:5.5.27-rel28.0.291.rhel5
Complete!
I had to start mysqld executing
$ /etc/init.d/mysql start
After that I executed
$ mysql_upgrade -u root -p
which resulted on getting some errors like this
MyDB.consumer
error : Table upgrade required. Please do "REPAIR TABLE `consumer`" or
dump/reload to fix it!
Are all these normal?
One more thing I would like to point out that no /etc/my.cnf file was
installed.
I extracted Percona-Server-server-55-5.5.27-rel28.0.291.rhel5.x86_64.rpm
file and the my.cnf file was not present there either.
Thank you
