473,668 Members | 2,290 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

measure throughput and latency between mysqlclient and server

d
Hi,

I have setup a GigE LAN with 1 mysql server and another having the
mysql client. the OS is slackware 10.1. the mysql is compiled from
source and is ver 4.1.9.

How do I measure throughput and latency between mysqlclient and
server ?

Thanks
--
d@t@ Fish
Swimming in Data

Jul 23 '05 #1
0 1382

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3887
by: JP | last post by:
My company is considering acquisition of a packaged application that's based on My SQL. This would be our first use of MySQL and the CEO is worried about using a "no-name" database (he's a Microsoft bigot). His specific concern is that an app written on MySQL will not have the necessary throughput and he's asked me to research MySQL's capabilities. From everything I've read so far, I'm comfortable that throughput will not be a problem...
2
1752
by: Sumanth | last post by:
How do we increase the throughput between an app server and the DB2 server. I tried increasing the bufferpage size, and get throughput around 5.4 mb/sec. I compute throughput by calculating the total number of bytes inserted/ total time taken. I tried increasing the buffer pool page size to 32KB the maximum allowed . and the mode is in non-blocking mode..any other params that i can tune? Thanks,
2
8770
by: Bill | last post by:
Hi, I try to connect to Mysql using the Mysql Connector 1.0.7. with asp.net 2.O. In "mysql.aspx", i put: <%@ import namespace="System.Data"%> <%@ Import Namespace = "MySql.Data.MySqlClient" %> ..... In "mysql.aspx.vb", i put:
3
2251
by: jcvoon | last post by:
Hi: My customer request me to provide how much bandwidth required by my application (For both Winform and Asp.net application). I've no idea how to measure it. Please advice. Thanks JCVoon
1
3196
by: frank.preiss | last post by:
Hi, I'm looking for help monitoring the communication of a client/server application. We are using the .Net default serialization/ deserialization with the binary formatter using .Net 2.0. I don't see any chance spying on what is going on during communication. We experience poor performance and I want to figure out why. I'd like to measure the throughput and amount of data and I'd like to figure out how much time is consumed by...
4
3495
by: 73k5blazer | last post by:
Hello again all.. We have a giant application from a giant software vendor that has very poor SQL. It's a PLM CAD application, that makes a call to the db for every cad node in the assembly. So for an assembly with many parts, from remote locations, the performance goes out the window. Locally, it all works fine because network latency is <1ms. But some remote sites we have (that are growing) latency can be as high as 80-100ms.
2
6027
by: jeff80 | last post by:
Hello, I'm an absolute newbie when it comes to SQL. I was told that SQL server does not function well on a WAN where network latency between, say, the SQL server and a front-end server is greater than 250ms. I can't find anything information supporting this claim online, so I was hoping someone here could tell me if this is true or not? Thank You!!
1
9771
by: Carmine [www.thetotalsite.it] | last post by:
Hi, I am using ASP.Net 2.0 with the MySQL Connector .Net 5.1.2.2. I added these lines to the web.config to make the connector.net able to handle the SqlConnection object (and so to bind it to a grinview/formview etc.): <DbProviderFactories> <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,
3
8641
by: Kaheru | last post by:
Hi, my IT knowledge not that strong. Hope you guys dun mind I asking a stupid question. I recently been assign with an assignment to performance test a FTP server. I gathered the data using a test tool. The test is to simulate 100 users sending multiple FTP request to upload and download file of various size from the FTP server. The test need to be done for 100,200,300,400,...1000 concurrent connection. I got the result data and plotted 2...
0
8459
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8378
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8890
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8791
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6206
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5677
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4202
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2786
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2018
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.