Increase max_input_vars for phpMyAdmin like an expert.

At Bobcares, we are devoted to coming up with solutions for every query, big and small. Our Server Management Service is here to make your life easier.

Let’s take a look at how our Support Techs recently helped a customer increase the max_input_vars value in the PHP configuration file.

increase max_input_vars for phpMyAdmin

Have you come across a warning message while attempting to use phpMyAdmin to manage very large database tables?

Warning: a form on this page has more than 10000 fields. 
On submission, some of the fields might be ignored, 
due to PHP's max_input_vars configuration.

This warning message is in relation to the default max_input_vars value seen in the phpMyAdmin’s PHP configuration file:

# grep max_input_vars /usr/local/cpanel/3rdparty/php/73/etc/phpmyadmin/php.ini
max_input_vars = 10000

How to increase max_input_vars for phpMyAdmin

First, we have to locate the PHP configuration file. The location may differ according to the PHP version

/usr/local/cpanel/3rdparty/php/*/etc/phpmyadmin/php.ini

Then, we will increase the max_input_vars value and change the memory_limit line in the file via any text editor. According to our Support Techs, it is a good idea to increase the value incrementally. For instance, 10000, 20000, and so on as required.

Furthermore, it is advisable to manage the database via CLI for very large databases. Additionally, increasing the PHP values way beyond the default values may lead to new errors and even cause phpMyAdmin to be unresponsive.

[Need a helping hand? We are available 24/7.]

Conclusion

In brief, we learned How to increase max_input_vars for phpMyAdmin under the guidance of the skilled Support Engineers at Bobcares.