Local vs. remote performance C-API
I have a huge problem with an application using the C-API to connect to a remote MySQL 4.1.8 (and previous versions).
When I run my application locally, I get a decent performance (connecting to localhost).
If I host the database on a remote server (connection through 100 mbit switched network) the performance goes down to about 25% of what I have locally.
The bottleneck is not the network. I have also disabled reverse DNS on the server - although DNS is working fine. I have tried several servers in several networks (so I can exlude server NICs, switches and DNS in general for being responsible). I have also tried different client machines.
The queries are very mixed: INSERT,SELECT,UPDATE. Locally I manage about 2000-3000 / second, remotely I can do up to 500 / second, not more.
I have tried tweaking some server parameters but nothing really makes a difference. Actually the server hardware has much more resources than my local application. Which server side parameters (or client side) should I focus on? I think I have a good handle on what it takes on the database parameters to get a could performance (such as key buffers, etc) since my localhost performance is quite ok.
I rewrote the entire app to not use prepared statements anymore since I suspected that they could be part of the problem. Didn't help - except for avoiding some of the prepared statement bugs (such as stalling the server whenever you issue a mysql_stmt_prepare).
PLEASE SOMEBODY HELP ME!
Subject
Views
Written By
Posted
Local vs. remote performance C-API
6846
December 20, 2004 06:10AM
3134
December 20, 2004 06:23AM
2710
December 28, 2004 03:59PM
3799
December 31, 2004 12:36AM
2827
December 31, 2004 01:56AM
2265
January 04, 2005 05:11AM
2363
January 05, 2005 07:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.