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

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?

max_allowed_packetJacek Becla16 Mar