*
The moose likes JDBC and the fly likes mysql memory ..  OS X issues Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "mysql memory ..  OS X issues" Watch "mysql memory ..  OS X issues" New topic
Author

mysql memory .. OS X issues

jay vas
Ranch Hand

Joined: Aug 30, 2005
Posts: 407
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30076
    
149

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3702
    
    5

You can use SQL Administrator GUI tool to modify the server parameters and/or change them in the mysql.conf file.


My Blog: Down Home Country Coding with Scott Selikoff
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3702
    
    5

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

Joined: Aug 30, 2005
Posts: 407
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

Joined: Aug 30, 2005
Posts: 407
What is the sql manager tool you mentioned ?
 
 
subject: mysql memory .. OS X issues
 
Similar Threads
Hashtable in memory versus database table in memory
how to lock only once method
"main" java.sql.SQLException: Access denied for user 'root'@'192.168.1.1' (using password: YES)
Session Object size - memory management problem
Combo Boxes