List:General Discussion« Previous MessageNext Message »
From:Jacek Becla Date:March 16 2006 6:12pm
Subject:max_allowed_packet
View as plain text  
Hi,

I'm trying to see what speed I will get from a simple query like:

select * from <bigTable>

and I noticed the server-> client transfer is always 512 bytes.
(iostat tells me I read 6348.80*1024 bytes/sec in a given time
period, and 12697.60 reads/sec, which translates to exactly 512)


I set the max_allowed_packet on the server side (through my.cnf
and restarting the server):


show variables like '%allowed%';
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 1047552 |
+--------------------+---------+
1 row in set (0.00 sec)


and I am running the client as:


mysql --max_allowed_packet=1M smdev -e "select * from MyTable" > /dev/null

What am I missing?


Thanks,
Jacek
Thread
max_allowed_packetJacek Becla16 Mar