File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes jdbc/mysql performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc/mysql performance" Watch "jdbc/mysql performance" New topic

jdbc/mysql performance

Ryan Atwood

Joined: Feb 03, 2009
Posts: 15
Not sure if anyone else has seen this problem but I've seen this happen multiple times and don't know how to fix it.

I have a java application that updates a mysql database thousands of times per second and a web client that reads it every few seconds. What I've noticed is that when the mySQL server is running on OSX, the program is much faster (by 4-5x) than if it's running on a Windows or Linux machine.

I've done many tests to isolate this problem -- running the Java app on the linux machine and the database on the mac vs both programs on Linux vs both on Mac, etc.. etc..

The funny thing is that my Linux box is uber-powerful.. much more powerful than my mac. I'm talking about an 8-core nehalem w/ HT vs a quad-core nehalem. I've installed multiple flavors of Linux on the 8-core too -- Ubuntu 32-bit, Cent-OS 64-bit and it's the same issue.

I've tried mimicking the config files on both machines but to no luck. Anyone know if this is a JDBC or JVM issue?
Edison Gualberto

Joined: Nov 05, 2008
Posts: 5
Personally I think the problem here is the operating system. Anyway, I found a guide to speed up a your web server. [removed]
I agree. Here's the link:
subject: jdbc/mysql performance
jQuery in Action, 3rd edition