GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Performance Tuning in INNODB

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Performance Tuning in INNODB

    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.

    Comment


    • #3
      sterin wrote on Tue, 25 September 2007 16:43

      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) - http://forum.mysqlperformanceblog.com/s/t/566/" target="_blank">my problem report

      Comment

      Working...
      X