Server Variable Suggestions

[dstrange]

Anyone have any initial my.ini server variable suggestions for improving db performance. We use a INNODB db at work containing 200 tables with 60 views and usually have between 3-5 users using an app writing to the db constantly.

By default the ini file variables are setup like this:

[client]

port=3306

[mysql]

default-character-set=latin1

[mysqld]

port=3306
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=500k
table_cache=256
tmp_table_size=17M
thread_cache_size=8

#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=34M
key_buffer_size=25M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K


#*** 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=47M
innodb_log_file_size=24M
innodb_thread_concurrency=8

Really any suggestions as to what I can read/research about or what could be improved upon would be a great start. I'm just not too sure where to start. Thanks in advance.
-DS

 

[Bastien]

http://www.mysqlperformanceblog.com

also turn on slow query log to trap slow queries

and run explain plans on slow queries to help ensure that indeces are used and the query is optimized.

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[Bastien]

And this just showed up in my inbox

http://blogs.techrepublic.com.com/opensource/?p=285&tag=nl.e011

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...