Announcement

Announcement Module
Collapse
No announcement yet.

Innodb variables

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

  • Innodb variables

    Hi,

    I have installed MySQL 5.0.51 on Linux 32 bit plateform all tables are using innodb engine

    I want to set all innodb related variables for better performance

    what is forumula to set innodb_buffer_pool_size and other related innodb variable

    I have set Max_connection to 100

  • #2
    There's no easy answer to this question. It's best to educate yourself. Obviously the MySQL manual is a good source of information. Here are a few links that might help you out as well:

    http://www.bigdbahead.com/?p=115

    http://www.mysqlperformanceblog.com/2007/11/03/choosing-inno db_buffer_pool_size/

    Comment


    • #3
      Thanks Dear cool:

      Comment

      Working...
      X