Compilation Blows up

MySQL & MariaDB Other MySQL® Questions
1

I cannot compile the application on RHEl 6.1 fully updated.
I started with
cmake . -DBUILD_CONFIG=mysql_release -DCMAKE_INSTALL_PREFIX=/usr/mysql

and did “make”
These are the errors:

Scanning dependencies of target mysql_client_test_embedded
[100%] Building C object libmysqld/examples/CMakeFiles/mysql_client_test_embedded.dir ///tests/mysql_client_test.c.o
Linking CXX executable mysql_client_test_embedded
…/libmysqld.a(lib_sql.cc.o): In function clean_up': /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1509: undefined reference to query_response_time_free()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:1511: undefined reference to free_global_user_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1512: undefined reference to free_global_client_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:1513: undefined reference to free_global_thread_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1514: undefined reference to free_global_table_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:1515: undefined reference to free_global_index_stats()' ../libmysqld.a(lib_sql.cc.o): In function init_server_components’:
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:4061: undefined reference to query_response_time_init()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4064: undefined reference to init_global_table_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:4065: undefined reference to init_global_index_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4203: undefined reference to init_global_user_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:4204: undefined reference to init_global_client_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4205: undefined reference to init_global_thread_stats()’
…/libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_reset(THD*, char*)': /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:30 14: undefined reference to update_global_user_stats(THD*, bool, long)’
…/libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_fetch(THD*, char*, unsigned int)': /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:28 88: undefined reference to update_global_user_stats(THD*, bool, long)’
…/libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_execute(THD*, char*, unsigned int)': /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:27 13: undefined reference to update_global_user_stats(THD*, bool, long)’
…/libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_prepare(THD*, char const*, unsigned int)': /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:22 73: undefined reference to update_global_user_stats(THD*, bool, long)’
…/libmysqld.a(sql_parse.cc.o): In function log_slow_statement(THD*)': /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:1531 : undefined reference to query_response_time_collect(unsigned long long)’
…/libmysqld.a(sql_parse.cc.o): In function mysql_parse(THD*, char*, unsigned int, Parser_state*)': /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:5807 : undefined reference to update_global_user_stats(THD*, bool, long)’
…/libmysqld.a(sql_show.cc.o):(.data.rel+0x598): undefined reference to query_response_time_fill(THD*, TABLE_LIST*, Item*)' ../libmysqld.a(sql_reload.cc.o): In function reload_acl_and_cache(THD*, unsigned long, TABLE_LIST*, int*)‘:
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:315 : undefined reference to free_global_index_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:316 : undefined reference to init_global_index_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:308 : undefined reference to free_global_table_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:309 : undefined reference to init_global_table_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:300 : undefined reference to query_response_time_flush()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:334 : undefined reference to free_global_thread_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:335 : undefined reference to init_global_thread_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:329 : undefined reference to free_global_client_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:330 : undefined reference to init_global_client_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:324 : undefined reference to free_global_user_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:325 : undefined reference to init_global_user_stats()' ../libmysqld.a(ha_innodb.cc.o): In function innobase_commit_low’:
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi' ../libmysqld.a(ha_innodb.cc.o): In function innobase_init’:
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to init_strvar_from_file(char*, int, st_io_cache*, char const*)' /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to init_intvar_from_file(int*, st_io_cache*, int)’
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to init_strvar_from_file(char*, int, st_io_cache*, char const*)' /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to init_intvar_from_file(int*, st_io_cache*, int)’
…/libmysqld.a(ha_innodb.cc.o): In function innobase_commit_low': /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi’
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi' /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi’
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi' /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi’
…/libmysqld.a(ha_innodb.cc.o):/usr/src/Percona-Server-5.5.1 6-rel22.0/storage/innobase/handler/ha_innodb.cc:3103: more undefined references to active_mi' follow collect2: ld returned 1 exit status make[2]: *** [libmysqld/examples/mysql_client_test_embedded] Error 1 make[1]: *** [libmysqld/examples/CMakeFiles/mysql_client_test_embedded.di r/all] Error 2 make: *** [all] Error 2Scanning dependencies of target mysql_client_test_embedded [100%] Building C object libmysqld/examples/CMakeFiles/mysql_client_test_embedded.dir /__/__/tests/mysql_client_test.c.o Linking CXX executable mysql_client_test_embedded ../libmysqld.a(lib_sql.cc.o): In function clean_up’:
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:1509: undefined reference to query_response_time_free()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1511: undefined reference to free_global_user_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:1512: undefined reference to free_global_client_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1513: undefined reference to free_global_thread_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:1514: undefined reference to free_global_table_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:1515: undefined reference to free_global_index_stats()’
…/libmysqld.a(lib_sql.cc.o): In function init_server_components': /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4061: undefined reference to query_response_time_init()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:4064: undefined reference to init_global_table_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4065: undefined reference to init_global_index_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:4203: undefined reference to init_global_user_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/../sql/mysq ld.cc:4204: undefined reference to init_global_client_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/libmysqld/…/sql/mysq ld.cc:4205: undefined reference to init_global_thread_stats()' ../libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_reset(THD*, char*)‘:
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:30 14: undefined reference to update_global_user_stats(THD*, bool, long)' ../libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_fetch(THD*, char*, unsigned int)’:
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:28 88: undefined reference to update_global_user_stats(THD*, bool, long)' ../libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_execute(THD*, char*, unsigned int)‘:
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:27 13: undefined reference to update_global_user_stats(THD*, bool, long)' ../libmysqld.a(sql_prepare.cc.o): In function mysqld_stmt_prepare(THD*, char const*, unsigned int)’:
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_prepare.cc:22 73: undefined reference to update_global_user_stats(THD*, bool, long)' ../libmysqld.a(sql_parse.cc.o): In function log_slow_statement(THD*)‘:
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:1531 : undefined reference to query_response_time_collect(unsigned long long)' ../libmysqld.a(sql_parse.cc.o): In function mysql_parse(THD*, char*, unsigned int, Parser_state*)’:
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_parse.cc:5807 : undefined reference to update_global_user_stats(THD*, bool, long)' ../libmysqld.a(sql_show.cc.o):(.data.rel+0x598): undefined reference to query_response_time_fill(THD*, TABLE_LIST*, Item*)’
…/libmysqld.a(sql_reload.cc.o): In function reload_acl_and_cache(THD*, unsigned long, TABLE_LIST*, int*)': /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:315 : undefined reference to free_global_index_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:316 : undefined reference to init_global_index_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:308 : undefined reference to free_global_table_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:309 : undefined reference to init_global_table_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:300 : undefined reference to query_response_time_flush()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:334 : undefined reference to free_global_thread_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:335 : undefined reference to init_global_thread_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:329 : undefined reference to free_global_client_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:330 : undefined reference to init_global_client_stats()’
/usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:324 : undefined reference to free_global_user_stats()' /usr/src/Percona-Server-5.5.16-rel22.0/sql/sql_reload.cc:325 : undefined reference to init_global_user_stats()’
…/libmysqld.a(ha_innodb.cc.o): In function innobase_commit_low': /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi’
…/libmysqld.a(ha_innodb.cc.o): In function innobase_init': /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to init_strvar_from_file(char*, int, st_io_cache*, char const*)’
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2555: undefined reference to init_intvar_from_file(int*, st_io_cache*, int)' /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to init_strvar_from_file(char*, int, st_io_cache*, char const*)’
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:2570: undefined reference to init_intvar_from_file(int*, st_io_cache*, int)' ../libmysqld.a(ha_innodb.cc.o): In function innobase_commit_low’:
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi' /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi’
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi' /usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi’
/usr/src/Percona-Server-5.5.16-rel22.0/storage/innobase/hand ler/ha_innodb.cc:3103: undefined reference to active_mi' ../libmysqld.a(ha_innodb.cc.o):/usr/src/Percona-Server-5.5.1 6-rel22.0/storage/innobase/handler/ha_innodb.cc:3103: more undefined references to active_mi’ follow
collect2: ld returned 1 exit status
make[2]: *** [libmysqld/examples/mysql_client_test_embedded] Error 1
make[1]: *** [libmysqld/examples/CMakeFiles/mysql_client_test_embedded.di r/all] Error 2
make: *** [all] Error 2

2

Hello, can you find the build-binary.sh script in your copy of the tree? That script should fetch all dependencies before running make.

Also, have you tried to install the binary instead?:

http://www.percona.com/doc/percona-server/5.5/installation/y um_repo.html

3

I downloaded the binaries using yum, and it installed, but It is still using my old my.cnf. How do I get an ideal, maxed out my.cnf for a box with 127 GB, dedicated to mysql? The business issue is this: I have a table with 340 Million records, 3 columns, 2 Bigint and 1 varchar(4). I need to load the table in RAM for the predictable response for a query based on the primary key (first Bigint) must be 1/4 of a second. Can I achieve this with Percona?