# Compilation Blows up **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [November 6, 2011, 1:14pm UTC](https://forums.percona.com/t/compilation-blows-up/1701 "2011-11-06T13:14:21Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![falves1](https://avatars.discourse-cdn.com/v4/letter/f/3e96dc/32.png) [@falves1](https://forums.percona.com/u/falves1)\ **Post date:** [November 6, 2011, 1:14pm UTC](https://forums.percona.com/t/compilation-blows-up/1701/1 "2011-11-06T13:14:21Z")
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 ---
**Author:** ![fipar](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fipar/32/16886_2.png) [@fipar](https://forums.percona.com/u/fipar)\ **Post date:** [November 6, 2011, 1:28pm UTC](https://forums.percona.com/t/compilation-blows-up/1701/2 "2011-11-06T13:28:44Z")
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](http://www.percona.com/doc/percona-server/5.5/installation/y) um\_repo.html ---
**Author:** ![falves1](https://avatars.discourse-cdn.com/v4/letter/f/3e96dc/32.png) [@falves1](https://forums.percona.com/u/falves1)\ **Post date:** [November 6, 2011, 1:51pm UTC](https://forums.percona.com/t/compilation-blows-up/1701/3 "2011-11-06T13:51:10Z")
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?