включаем show user_statistics patch на centos5 для mysql-5.0.77

wget http://mirror.corbina.net/pub/Linux/centos/5.4/os/SRPMS/mysql-5.0.77-3.el5.src.rpm
rpm -i mysql-5.0.77-3.el5.src.rpm

wget http://www.percona.com/percona-builds/Percona-SQL-5.0/Percona-SQL-5.0-5.0.87-b20/source/Percona-SQL-50-5.0.87-b20.6.rhel5.src.rpm

rpm -i Percona-SQL-50-5.0.87-b20.6.rhel5.src.rpm
cd /home/rpmbuild/rpm/SOURCES/
cd percona_mysql.5.0.77-b16/
mv * ../

cd /home/rpmbuild/rpm/SPECS/
vi mysql.spec

меняем все что касается патчей на
Patch1: show_patches.patch
Patch2: microslow_innodb.patch
Patch3: profiling_slow.patch
Patch4: userstatv2.patch
Patch5: microsec_process.patch
Patch6: innodb_io_patches.patch
Patch7: mysqld_safe_syslog.patch
Patch8: innodb_locks_held.patch
Patch9: innodb_show_bp.patch
Patch10: innodb_check_fragmentation.patch
Patch11: innodb_io_pattern.patch
Patch12: innodb_fsync_source.patch
Patch13: innodb_show_hashed_memory.patch
Patch14: innodb_dict_size_limit.patch
Patch15: innodb_extra_rseg.patch
Patch16: innodb_thread_concurrency_timer_based.patch
Patch18: innodb_misc_patch.patch
Patch120: innodb_rw_lock.patch
Patch21: mysql-test.patch

и
%patch1 -p1
%patch2 -p1
%patch3 -p1
%patch4 -p1
%patch5 -p1
%patch6 -p1
%patch7 -p1
%patch8 -p1
%patch9 -p1
%patch10 -p1
%patch11 -p1
%patch12 -p1
%patch13 -p1
%patch14 -p1
%patch15 -p1
%patch16 -p1
%patch18 -p1
%patch120 -p1
%patch21 -p1

в %configure отключаем ssl
--without-openssl

и комментим make test
# make test

собираем
rpmbuild -bb mysql.spec

и инсталлируем
rpm --force -iv /home/rpmbuild/rpm/RPMS/x86_64/mysql-5.0.77-3.x86_64.rpm
rpm --force -iv /home/rpmbuild/rpm/RPMS/x86_64/mysql-server-5.0.77-3.x86_64.rpm

vi /etc/my.cnf

в [mysqld] добавляем

userstat_running=1


/etc/init.d/mysqld restart
mysql -u root -p

show user_statistics\G
User: root
Total_connections: 1
Concurrent_connections: 0
Connected_time: 707
Busy_time: 0
Cpu_time: 0
Bytes_received: 75
Bytes_sent: 4734
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 3
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0

работает