GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

MYSQL 4.1 Performance issue

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

  • MYSQL 4.1 Performance issue

    Hi,


    recently i have problem in my mysql server 4.1. i am not able to viwe the tables in one of the db it will take too much time.


    mysql MY.INI File settings in the server

    # CLIENT SECTION
    [client]

    port=3306

    default-character-set=latin1


    # SERVER SECTION
    [mysqld]

    port=3306


    basedir="C:/Program Files/MySQL/MySQL Server 4.1/"

    datadir="C:/Program Files/MySQL/MySQL Server 4.1/Data/"

    default-character-set=latin1

    default-storage-engine=INNODB

    max_connections=100

    query_cache_size=0

    table_cache=256

    tmp_table_size=5M


    thread_cache_size=8

    myisam_max_sort_file_size=100G

    myisam_max_extra_sort_file_size=100G

    myisam_sort_buffer_size=8M

    key_buffer_size=8M

    read_buffer_size=64K
    read_rnd_buffer_size=256K

    sort_buffer_size=212K


    #*** INNODB Specific options ***


    innodb_additional_mem_pool_size=2M

    innodb_flush_log_at_trx_commit=1

    innodb_log_buffer_size=1M

    innodb_buffer_pool_size=8M

    innodb_log_file_size=10M

    innodb_thread_concurrency=8


    Server Hardware & Software configuration

    P4 3.0, 2 GB RAM, 250GB IDE HDD,
    windows 2003 Enterprise Server SP1, 4096MB Page file size

    Please help me to solve this issue, also assist me what kind of changes to be made in my.ini for better performance



    Thanks
    S.Gobinath

  • #2
    key_buffer_size=8M (MyISAM tables)
    innodb_buffer_pool_size=8M (InnoDB tables)


    These settings are both very low! If you're using MyISAM tables, I'd change key_buffer_size to 128M or 256M. If you're using InnoDB tables, I'd change innodb_buffer_pool_size to at least 1G. You may want to use lower settings if your machine is used for other purposes than just a database server.

    Comment

    Working...
    X