Announcement

fipar · 11-06-2011, 12:58 PM

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

falves1 · 11-06-2011, 01:21 PM

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?

falves1 · 11-06-2011, 04:05 PM

There is something wrong with the software. I inserted 274 million rows in an innodb table. I stopped and tried to shut down the mysql server. It took 15 mins stopping and it failed like this:

Shutting down MySQL (Percona Server)........................................... .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... .................................................. .......... ....... ERROR!

falves1 · 11-06-2011, 04:54 PM

I need some help compiling from sources. There is no file build-binary.sh and I need to install the server to a particular location, not the default location. Unless that can be done with the binary version. Any way, the sources should compile no matter what, in RHEL 6.1.

sterin · 11-10-2011, 09:17 AM

The source code compiles if you have all prerequisites installed on your RHEL 6.1.
But I recommend against compiling your own if you are not sure about it.

Use the general Linux Binary instead.
It is a simple .tar.gz which you can unpack at the location of your choosing.
But since you want to place it in a custom location you will need to fix things like ownership of directories and init startup/shutdown scripts etc.

And if you want to place the data directory in some other place than in a sub-directory to the installation folder then you will have to modify the my.cnf file accordingly.

As for the settings for your box something like:

innodb_buffer_pool_size = 100G

Will bring you a long way since according to my very rough calculations your table shouldn't be more than about 15-20G.

And if you have a lot of writes then you can consider something like:
innodb_log_buffer = 8M
innodb_log_file_size = 128M

And depending on if you have a BBU RAID controller or are willing to loose some data in case of a OS crash then you can trade robustness for speed:
innodb_flush_log_at_trx_commit = 2

Announcement

Compilation Blows up

Compilation Blows up

Comment

Comment

Comment

Comment

Comment