Unusual mysql my.cnf optimization

[Ridge]

what would your my.cnf file look like for the following.


this is for an internal application that has no more than 10 concurrent users at a time.

centos 5.3
all latest versions

2.83GHZ CORE 2 QUAD 1333 MHz FSB 12 MB CACHE
4 gigs of ram
u2 scsi

 

[katherine]

Things I would do:

• obviously make sure the current database structure is adequate
• OPTIMIZE the tables on a regular basis
• rebuild the indexes
• use the appropriate storage engine for the purpose, for example use HEAP for search-only/temporary tables

As for the my.cnf one thing you can do is optimize by reducing the number of allowed clients

• Also look at the various caching facilities including the query cache
• log the heavier queries and analyze them for possible optimization, debug, refine...

More: http://www.linuxweblog.com/tune-my.cnf

 

[south]

More: http://www.linuxweblog.com/tune-my.cnf

Great stuff! Thanks Kate!

 

[Ridge]

Thanks the post! I've tuned this bad boy as far as I think I can go. I think the bottleneck is slow db queries.

 

[katherine]

The EXPLAIN command can help optimize queries so you can spot possible bottlenecks such as missing indexes etc.
Obviously you need to fine-tune the code and the queries to the maximum before you even tweak the config file