Im running a jdbc application and a query is taking a VERY long time on a HUGE server. I think its because Im not using enough possible memory. I want to setup mysql to use as much memory as is available.
I changed mysql to use more memory by adding my-huge.cnf to the /etc
Im not sure how to find out from the client how much memory is available to the server. Even though I followed the steps to tell mysql use the my-huge.cnf - how do I know its using all 30 or so free Gigabytes in memory ?
I have a 32G machine with 4 processors (xserve) and I want to make sure I use it to its full potential ... Please help !
Id totally hate to have to switch back to windows for over a simple confusion like this !
Originally posted by Jeanne Boyarsky: Jay, Have you run an OS command to confirm that memory is the issue? UNIX has commands to check server resource usage, so I would assume OS X has the same.
Yep, top and ps. OS X has the most important unix tools built in. I agree with Jeanne though, its rare to run out of memory in MySQL. Are you sure its a memory issue? It's probably a lack-of-index issue. [ July 29, 2008: Message edited by: Scott Selikoff ]
Nope... I know its the machine because it is a clone of an exact equivalent mysql database which runs faster on a 12 G RAM server (same operating system - os x, same chip set, etc...) which we were using as our db (our tables are large and queries are computatioally intensive). The database is perfect - its the server that i done know how to configure.
mysql administrator doesnt seem to be available for leopard.... What other simple ways to conifgure it for high speed are there ?