Posts: 534
Threads: 265
Joined: Jul 2014
Hi,
What max size is let for mysql_tquery(UPDATE ....);
Posts: 534
Threads: 265
Joined: Jul 2014
Posts: 534
Threads: 265
Joined: Jul 2014
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?
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
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.