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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
