Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql memory .. OS X issues

 
jay vas
Ranch Hand
Posts: 407
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi guys : Please help ! Im desperate here.

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 !

Jay
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34396
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use SQL Administrator GUI tool to modify the server parameters and/or change them in the mysql.conf file.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
jay vas
Ranch Hand
Posts: 407
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
jay vas
Ranch Hand
Posts: 407
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the sql manager tool you mentioned ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic