What is maximum query size for mysql?

by

You can check your current
server setting with:

SHOW VARIABLES LIKE 'max_allowed_packet';

This gives you the answer in bytes. for e.g max_allowed_packet=1048576 or 1 MiB

More Related Contents:

  1. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  2. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  3. where does MySQL store database files?
  4. MySQL and GROUP_CONCAT() maximum length
  5. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  6. MySQL convert date string to Unix timestamp
  7. How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
  8. Using an Alias in SQL Calculations
  9. MySql Table Insert if not exist otherwise update
  10. How to get difference between two dates in months using MySQL query?
  11. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  12. On duplicate key ignore? [duplicate]
  13. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  14. List of Stored Procedures/Functions Mysql Command Line
  15. mySQL longitude and latitude query for other rows within x mile radius
  16. How to design a multi tenant mysql database
  17. How to get the count of each distinct value in a column? [duplicate]
  18. Get results that fall within marker radiuses from database
  19. Bash script to insert values in MySQL
  20. MySQL dynamic cross tab
  21. SELECT INTO and “Undeclared variable” error
  22. How to disable index in innodb
  23. How do I lag columns in MySQL?
  24. How to get multiple records against one record based on relation?
  25. SQL query to check if a name begins and ends with a vowel
  26. What is the best way to store media files on a database?
  27. SQL: deleting tables with prefix
  28. How to use a user variables in MySQL LIKE clause?
  29. How can a query multiply 2 cell for each row MySQL?
  30. Rails select random record

Leave a Comment