On Tuesday, January 22, 2002, at 01:48 PM, Dan Nelson wrote:
> In the last episode (Jan 22), James Riordon said:
>> At 22:35 -0800 01/21/2002, I whispered:
>>> On Mon, Jan 21, 2002 at 11:02:47PM -0500, James Riordon wrote:
>>>> I have our new client up and running and have come upon another
>>>> question. When I get extended-status I get the following:
>>>> | Bytes_received | 53553199 |
>>>> | Bytes_sent | 664736462 |
>>> Is Apache/PHP on the same server as MySQL?
>> Yes. We have Apache, PHP and MySQL all running on the same server.
>> Our actual throughput yesterday actually turned out to be closer to
>> 350MB but the MySQL extended-status Bytes_Sent showed around 700MB by
>> the end of the day.
> Do you connect via unix domain sockets (i.e. 'localhost'), or TCP
> sockets? Unix sockets will not be counted in any TCP traffic stats.
All of our connections are through localhost. So what I get from this is
that all internal traffic on the localhost will not get counted, but the
final results that are sent through PHP and TCP sockets will get counted.
If this difference between unix domain sockets is huge compared to TCP
sockets, would that mean that the database queries are inefficient?
Many thanks again.
Amigo-3 Interactive Inc.