# Percona Server sample configuration

**URL:** https://forums.percona.com/t/percona-server-sample-configuration/2640
**Category:** Other MySQL® Questions
**Created:** [April 23, 2013, 1:54am UTC](https://forums.percona.com/t/percona-server-sample-configuration/2640 "2013-04-23T01:54:09Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![devi](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@devi](https://forums.percona.com/u/devi)
#### Post date: [April 23, 2013, 1:54am UTC](https://forums.percona.com/t/percona-server-sample-configuration/2640/1 "2013-04-23T01:54:09Z")

</div>

Hi,

I’ve just installed percona and what should be the configuration in .cnf. I just want to compare the performance (just a simple login page) of the application against oracle mysql 5.5… Is there any sample configurations that i can use to see the performance.

Thanks  
Devi

---

<div class="post-metadata">

### Author: ![larishosting](https://avatars.discourse-cdn.com/v4/letter/l/71e660/32.png) [@larishosting](https://forums.percona.com/u/larishosting)
#### Post date: [April 23, 2013, 11:37pm UTC](https://forums.percona.com/t/percona-server-sample-configuration/2640/2 "2013-04-23T23:37:02Z")

</div>

You can use the default one you had for mysql for testing. You can also generate a new one [tools.percona.com](http://tools.percona.com)

---

<div class="post-metadata">

### Author: ![oldschool](https://avatars.discourse-cdn.com/v4/letter/o/e19adc/32.png) [@oldschool](https://forums.percona.com/u/oldschool)
#### Post date: [May 20, 2014, 10:50am UTC](https://forums.percona.com/t/percona-server-sample-configuration/2640/3 "2014-05-20T10:50:29Z")

</div>

Here mine:

quick  
[mysql]  
no-auto-rehash  
[myisamchk]  
key\_buffer=256M  
key\_buffer\_size=32M  
write\_buffer=2M  
read\_buffer=2M  
sort\_buffer\_size=256M  
[client]  
socket=“/mysql/mysql.sock”  
[mysqld]

# INNODB

innodb\_flush\_method = O\_DIRECT  
innodb\_log\_files\_in\_group = 2  
innodb\_log\_file\_size = 256M  
innodb\_flush\_log\_at\_trx\_commit = 1  
innodb\_file\_per\_table = 1  
innodb\_buffer\_pool\_size = 4G

wait\_timeout = 600 seconds

# CACHES AND LIMITS

tmp\_table\_size = 32M  
max\_heap\_table\_size = 32M  
query\_cache\_type = 0  
query\_cache\_size = 32M  
max\_connections = 100  
thread\_cache\_size = 50  
open\_files\_limit = 65535  
table\_definition\_cache = 4096  
table\_open\_cache = 10240

# LOGGING

log\_error = /mysql/mysql-error.log  
log\_queries\_not\_using\_indexes = 1  
slow\_query\_log = 1  
slow\_query\_log\_file = /mysql/mysql-slow.log

loose\_handlersocket\_port = 9998

# the port number to bind to for read requests

loose\_handlersocket\_port\_wr = 9999

# the port number to bind to for write requests

loose\_handlersocket\_threads = 16

# the number of worker threads for read requests

loose\_handlersocket\_threads\_wr = 1

# the number of worker threads for write requests

# to allow handlersocket to accept many concurrent

# connections, make open\_files\_limit as large as

# possible.

#join\_buffer\_size=12M  
#thread\_concurrency=4  
#query\_cache\_limit=256M  
#connect\_timeout=1000  
#key\_buffer=384M  
#table\_cache=4096  
#max\_user\_connections=50  
#local-infile=0  
#server-id=14  
#wait\_timeout=1000  
#read\_rnd\_buffer\_size=16M  
#read\_buffer\_size=2M  
#myisam\_sort\_buffer\_size=64M  
#max\_allowed\_packet=32M  
#socket=“/mysql/mysql.sock”  
#skip-external-locking  
#sort\_buffer\_size=2M  
#datadir=“/mysql”  
#[mysqlhotcopy]  
#interactive-timeout