how to check and set max_allowed_packet mysql variable [duplicate]

by

max_allowed_packet
is set in mysql config, not on php side

[mysqld]
max_allowed_packet=16M

You can see it’s curent value in mysql like this:

SHOW VARIABLES LIKE 'max_allowed_packet';

You can try to change it like this, but it’s unlikely this will work on shared hosting:

SET GLOBAL max_allowed_packet=16777216;

You can read about it here http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

EDIT

The [mysqld] is necessary to make the max_allowed_packet working since at least mysql version 5.5.

Recently setup an instance on AWS EC2 with Drupal and Solr Search Engine, which required 32M max_allowed_packet. It you set the value under [mysqld_safe] (which is default settings came with the mysql installation) mode in /etc/my.cnf, it did no work. I did not dig into the problem. But after I change it to [mysqld] and restarted the mysqld, it worked.

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. how to write php code for the key press enter button when fill the form?
  3. Just using mysql real escape string [closed]
  4. Create hyperlink from html table row to open record on a new page
  5. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  6. Many-to-many relationships examples
  7. SELECT COUNT(*) AS count – How to use this count
  8. How to execute two mysql queries as one in PHP/MYSQL?
  9. Storing files in database Vs file system
  10. How to upload images into MySQL database using PHP code
  11. selecting unique values from a column
  12. MySQL Join two tables with comma separated values
  13. MySQL – Access denied for user [duplicate]
  14. Calling stored procedure with Out parameter using PDO
  15. When *not* to use prepared statements?
  16. How to display an BLOB image stored in MySql database?
  17. How to bind LIKE values using the PDO extension?
  18. How do I set the selected item in a drop down box
  19. Fatal error: Call to undefined function mysqli_result()
  20. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  21. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  22. PHP 7 RC3: How to install missing MySQL PDO
  23. How can I employ “if exists” for creating or dropping an index in MySQL?
  24. PHP MySQL pagination with random ordering
  25. How to backup MySQL database in PHP?
  26. Auto Increment skipping numbers?
  27. PDO bindParam into one statement?
  28. Convert Time String to Decimal Hours PHP [closed]
  29. How to make mysqli connect function?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment