Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: max_allowed_packet

by gmax (Abbot)
on Jun 14, 2004 at 11:37 UTC ( #366505=note: print w/ replies, xml ) Need Help??

in reply to max_allowed_packet

Here is a simple recipe to get the value of "max_allowed_packet".

my $dbh = DBI->connect('dbi:mysql:dbname', 'user', 'pwd') or die "$DBI::errstr\n"; my (undef, $max_allowed_packet) = $dbh->selectrow_array( qq{show variables LIKE ? }, undef, "max_allowed_packet" ) ; printf "max_allowed_packet => %.2f MB\n", $max_allowed_packet / (1024 +*1024);
Sample output:
max_allowed_packet => 3.00 MB

SHOW VARIABLES returns a 2-column dataset, with a label in the first column and a value in the second one. Thus you need to get the second column with the value you need.

Check DBI Recipes for more on idioms, and Handling huge BLOB fields with DBI and MySQL for a sample program that checks max_allowed_packet to do something practical.

 _  _ _  _  
(_|| | |(_|><

Comment on Re: max_allowed_packet
Download Code
Re^2: max_allowed_packet
by js1 (Monk) on Jun 14, 2004 at 19:13 UTC

    Thanks gmax, that was very useful.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://366505]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (7)
As of 2015-05-05 04:33 GMT
Find Nodes?
    Voting Booth?

    In my home, the TV remote control is ...

    Results (110 votes), past polls