Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

How to Increase MYSQL performance [message #3660] Mon, 27 October 2008 13:39 thehawk Messages: 3 Registered: October 2008 Junior Member Hello All, I'm currently running mysql 5 on a server with 6GB of RAM and dual Xeon processors and I wish to take full advantage of the box's horse power. Right now mysql runs fairly slow and it only occupies about 1GB of the total 6GB memory. I wish to increase its utilization so that some queries run faster (in memory). Can someone suggest what changes I can make to have mysql utilize more server resources? (a lot of the queries are Join queries) I currently have the following lines in my.cfg file: [mysqld] key_buffer_size=256M query_cache_limit=32M query_cache_size=256M thread_cache_size=256M join_buffer=64M max_allowed_packet=16M table_cache=2048 sort_buffer_size=16M read_buffer_size=4M myisam_sort_buffer_size =64M [isamchk] key_buffer=128M sort_buffer=128M read_buffer=32M write_buffer=32M [myisamchk] key_buffer=128M sort_buffer=128M read_buffer=32M write_buffer=32M Anything I can tweak better? Thanks TheHawk Report message to a moderator

	How to Increase MYSQL performance By: thehawk on Mon, 27 October 2008 13:39
	Re: How to Increase MYSQL performance By: debug on Tue, 28 October 2008 02:00
	Re: How to Increase MYSQL performance By: thehawk on Tue, 28 October 2008 16:11
	Re: How to Increase MYSQL performance By: razdaman on Tue, 28 October 2008 16:18
	Re: How to Increase MYSQL performance By: thehawk on Thu, 30 October 2008 00:22
	Re: How to Increase MYSQL performance By: debug on Thu, 30 October 2008 00:27

Previous Topic:	Choosing a server
Next Topic:	Log I/O - What's Acceptable?

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]