Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Performance Tuning in INNODB

caf_antocaf_anto EntrantCurrent User Role Beginner
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.

Comments

  • sterinsterin Mentor Inactive User Role Contributor
    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.
  • vicklikvicklik Entrant Current User Role Beginner
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">sterin wrote on Tue, 25 September 2007 16:43</td></tr><tr><td class="quote">
    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.

    </td></tr></table>


    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) - <a href="http://forum.mysqlperformanceblog.com/s/t/566/" target="_blank">my problem report</a>
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.