Hi Dushyant,
Setting the variable from the command works only if you
do that for every client (application) when you connect
to the server. Since you're working with multiple connections,
then the better solution is to start the server with the
correct setting for the global max_questions variable, which
will affect all clients as they connect. For a description see
the MySQL Reference Manual at:
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
You can force the global setting either on the command line
when you start the server or (more permanently) change the
setting in your configuration file (.my.cnf file for Linux and
my.cnf/my.ini for Windows); see:
http://dev.mysql.com/doc/mysql/en/Option_files.html
Trudy Pelzer, Engineering Project Manager
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification