# Help with my.cnf  (8GB Ram)(x64 Mysql)

**URL:** <https://forums.percona.com/t/help-with-my-cnf-8gb-ram-x64-mysql/851>\
**Category:** Other MySQL® Questions\
**Created:** [July 22, 2008, 11:29pm UTC](https://forums.percona.com/t/help-with-my-cnf-8gb-ram-x64-mysql/851 "2008-07-22T23:29:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![satrojj](https://avatars.discourse-cdn.com/v4/letter/s/ce7236/32.png) [@satrojj](https://forums.percona.com/u/satrojj)\
**Post date:** [July 22, 2008, 11:29pm UTC](https://forums.percona.com/t/help-with-my-cnf-8gb-ram-x64-mysql/851/1 "2008-07-22T23:29:02Z")

</div>

We have 8GB of ram on our server,  
with x64 OS and x64 Mysql. This server  
runs only MySql. What we do with  
this server is very simple, SELECT and INSERT.  
Only two people will use this private server.  
It’s not going to be used in public.  
Our biggest table is around 3GB.  
We want to make the most of that 8GB of RAM.  
I posted our my.cnf so anyone tell us  
if there are options that you think  
is wrong and inappropriate. Million thanks in advance. )

# My.cnf

[client]  
port = 3306  
socket = /var/lib/mysql/mysql.sock  
[mysqld]  
port = 3306  
socket = /var/lib/mysql/mysql.sock  
skip-locking  
thread\_cache\_size = 8  
thread\_concurrency = 16  
back\_log = 50  
max\_connect\_errors = 10  
table\_cache = 2048  
max\_allowed\_packet = 48M  
binlog\_cache\_size = 9M  
max\_heap\_table\_size = 1500M  
sort\_buffer\_size = 36M  
join\_buffer\_size = 36M  
query\_cache\_size = 128M  
query\_cache\_limit = 2M  
ft\_min\_word\_len = 4  
default\_table\_type = MYISAM  
thread\_stack = 192K  
transaction\_isolation = REPEATABLE-READ  
tmp\_table\_size = 2000M  
log-bin=mysql-bin  
log\_slow\_queries  
long\_query\_time = 2  
log\_long\_format  
key\_buffer\_size = 2000M  
read\_buffer\_size = 8M  
read\_rnd\_buffer\_size = 48M  
bulk\_insert\_buffer\_size = 512M  
myisam\_sort\_buffer\_size = 512M  
myisam\_max\_sort\_file\_size = 10G  
myisam\_max\_extra\_sort\_file\_size = 10G  
myisam\_repair\_threads = 1  
myisam\_recover  
skip-bdb  
server-id = 1

[mysqldump]  
quick  
max\_allowed\_packet = 48M

[mysql]  
no-auto-rehash

[isamchk]  
key\_buffer = 256M  
sort\_buffer\_size = 256M  
read\_buffer = 2M  
write\_buffer = 2M

[myisamchk]  
key\_buffer = 2000M  
sort\_buffer\_size = 1500M  
read\_buffer = 10M  
write\_buffer = 10M

[mysqlhotcopy]  
interactive-timeout

---

<div class="post-metadata">

**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\
**Post date:** [July 30, 2008, 2:23am UTC](https://forums.percona.com/t/help-with-my-cnf-8gb-ram-x64-mysql/851/2 "2008-07-30T02:23:06Z")

</div>

What storage engine do you use? InnoDB or MyISAM?

---

<div class="post-metadata">

**Author:** ![ankur02018](https://avatars.discourse-cdn.com/v4/letter/a/838e76/32.png) [@ankur02018](https://forums.percona.com/u/ankur02018)\
**Post date:** [July 31, 2008, 5:35am UTC](https://forums.percona.com/t/help-with-my-cnf-8gb-ram-x64-mysql/851/3 "2008-07-31T05:35:59Z")

</div>

please guid for Innodb engine how we should set variable on the bases of RAM to improve performance

---

<div class="post-metadata">

**Author:** ![satrojj](https://avatars.discourse-cdn.com/v4/letter/s/ce7236/32.png) [@satrojj](https://forums.percona.com/u/satrojj)\
**Post date:** [August 1, 2008, 12:15am UTC](https://forums.percona.com/t/help-with-my-cnf-8gb-ram-x64-mysql/851/4 "2008-08-01T00:15:47Z")

</div>

Hello, thanks for the reply, we use MyISAM tables for the whole database. Thank you )

---

<div class="post-metadata">

**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\
**Post date:** [August 1, 2008, 2:11am UTC](https://forums.percona.com/t/help-with-my-cnf-8gb-ram-x64-mysql/851/5 "2008-08-01T02:11:58Z")

</div>

You can also have a look at [http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-](http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-) in-mysql-server-after-installation/
