• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

mysql memory .. OS X issues

 
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
 
author & internet detective
Posts: 39343
755
Eclipse IDE VI Editor Java
  • 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.
 
author
Posts: 4107
28
Google Web Toolkit Eclipse IDE Flex
  • 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
Posts: 4107
28
Google Web Toolkit Eclipse IDE Flex
  • 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 ?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!