Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : increase the length of query string

[prashant1979]

How to increase the length of query string for a website developed in PHP and MySQL and running on Linux?

[foobic]

What limit are you hitting? And are you referring to the url query string or the php-mysql query string (or something else)?

In any event the best option is probably to change your code so you don't need to increase the length of query string beyond standard limits (eg. use http post or split up your mysql queries).

[prashant1979]

I want to know what is the standard limit and up to what limit is recommended to be set.

[drspliff]

The limit is almost always enforced at the client side and varies between browsers. The Boutell.com FAQ covering maximum URL length.

You know - 1 minute of internet searching would've given you all the information you need... maybe you should try & use your brain next time rather than having WebHostingTalk users to google stuff for you.

[prashant1979]

Originally Posted by drspliff

The limit is almost always enforced at the client side and varies between browsers. The Boutell.com FAQ covering maximum URL length.

You know - 1 minute of internet searching would've given you all the information you need... maybe you should try & use your brain next time rather than having WebHostingTalk users to google stuff for you.

Before advising people on using Google, I think you need to contain your excitement and read carefully what I am searching for. I need the default value of the maximum query length in MySQL and the recommended value. What you have given me is the maximum length of a URL. About people searching on Google for an answer for me, what is wrong in that? I have myself used Google to find answers for people's queries in WHT. If you don't wanna help, it is better not to reply to the thread. If your intention is just to increase your posts, then I don't need your help.

[prashant1979]

While searching on the net, I get details on max allowed packet size. Is it the same as Max query length?

[prashant1979]

I found max_allowed_packet is the setting that should be enabled in the my.cnf for setting the maximum query length. The default value is 1 MB. I have set 16 MB for mine.