# MYSQL 4.1 Performance issue

**URL:** <https://forums.percona.com/t/mysql-4-1-performance-issue/608>\
**Category:** Other MySQL® Questions\
**Created:** [January 24, 2008, 12:46am UTC](https://forums.percona.com/t/mysql-4-1-performance-issue/608 "2008-01-24T00:46:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gobinath](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gobinath](https://forums.percona.com/u/gobinath)\
**Post date:** [January 24, 2008, 12:46am UTC](https://forums.percona.com/t/mysql-4-1-performance-issue/608/1 "2008-01-24T00:46:14Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![MarkRose](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@MarkRose](https://forums.percona.com/u/MarkRose)\
**Post date:** [January 24, 2008, 12:54pm UTC](https://forums.percona.com/t/mysql-4-1-performance-issue/608/2 "2008-01-24T12:54:38Z")

</div>

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.