Max mysql query lenght
#1

Hi,

What max size is let for mysql_tquery(UPDATE ....);
Reply
#2

It's different for every server, and system admins can also change the setting as well in the MySQL options.
According to http://dev.mysql.com/doc/refman/5.0/...too-large.html, max packet size can go up to 1GB.
But usually it's set to 16MB.

My own server at home has it set to 4MB.

Best check the options to see how large your max_allowed_packet size is.
Reply
#3

But in cells?
Reply
#4

Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server.

I have VPS and i'am going to etc/mysql/my.cnf and there found where to change. How to change it in server?
Reply
#5

You don't need to change this unless you want to upload a large (in SA-MP context that's like 100,000 rows) database backup. A normal query during normal operation will never exceed that limit. Given that a a cell is 4 bytes, even if the limit was 1mb you'd be able to send a query 250,000 characters in length, which is more than you'll ever need.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)