Performance Tuning in INNODB

[caf_anto]

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.

[sterin]

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.

[vicklik]

[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