Performance Tuning in INNODB

MySQL & MariaDB Other MySQL® Questions
1

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.

2

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.

3
[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