# Performance Tuning in INNODB

**URL:** <https://forums.percona.com/t/performance-tuning-in-innodb/464>\
**Category:** Other MySQL® Questions\
**Created:** [September 25, 2007, 9:32am UTC](https://forums.percona.com/t/performance-tuning-in-innodb/464 "2007-09-25T09:32:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![caf\_anto](https://avatars.discourse-cdn.com/v4/letter/c/f1d935/32.png) [@caf\_anto](https://forums.percona.com/u/caf_anto)\
**Post date:** [September 25, 2007, 9:32am UTC](https://forums.percona.com/t/performance-tuning-in-innodb/464/1 "2007-09-25T09:32:30Z")

</div>

Hello,

I Have a P4, with 1GB RAM on WinXP pro. Ive Tomcat as my container with MySQL 5.0 running in the default configuration. the only modifcation i did was this.

innodb\_buffer\_pool\_size = 300M

I have innodb table with apprx 78,000 records and the record size is approx. 1KB.

When Mysqld-nt process starts it increase the Memory usage to 1.2GB, but my physical memory is only 1GB.

What modification i need to do  
a. in my.ini to reduce the memory usage.  
b. upgradation of my server hardware.

Thanks.

---

<div class="post-metadata">

**Author:** ![sterin](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@sterin](https://forums.percona.com/u/sterin)\
**Post date:** [September 25, 2007, 3:13pm UTC](https://forums.percona.com/t/performance-tuning-in-innodb/464/2 "2007-09-25T15:13:34Z")

</div>

The thing is that a couple of parameters like innodb\_buffer\_pool\_size and key\_buffer\_size are global  
and only used once in the mysql instance.

But some parameters are per connection, for example sort\_buffer\_size and read\_buffer\_size etc are per connection.

So if you are allowing a lot of concurrent connections  
then your DB can very easily allocate to much memory.

---

<div class="post-metadata">

**Author:** ![vicklik](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@vicklik](https://forums.percona.com/u/vicklik)\
**Post date:** [January 9, 2008, 5:07am UTC](https://forums.percona.com/t/performance-tuning-in-innodb/464/3 "2008-01-09T05:07:09Z")

</div>

| [B]sterin wrote on Tue, 25 September 2007 16:43[/B] |
| The thing is that a couple of parameters like innodb\_buffer\_pool\_size and key\_buffer\_size are global and only used once in the mysql instance.

But some parameters are per connection, for example sort\_buffer\_size and read\_buffer\_size etc are per connection.

So if you are allowing a lot of concurrent connections  
then your DB can very easily allocate to much memory.

 |

Does anyone know which paremeters are per connection and which setting is propose for a 4GB machine? (I have regular out of memory error messages and think that my settings are wrong) - my problem report