MYSQL 4.1 Performance issue

MySQL & MariaDB Other MySQL® Questions
1

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.