Permanent connection to MySQL



  • I know that if you connect with the server (MySQL), that's timeout, after which the connection closes. You need to make sure that the annex (e.g.) works. It's possible, in principle, to put the timeout value at a very large time. But I guess that's not the way.

    Can I build mySQL for a permanent compound?

    PDO - ATTR_PERSISTENT typically includes a permanent compound. We have Python, ORM peewee. I mean, if it's possible with the PDO, it's probably different. It's just mySQL. Aren't they?



  • A parameter is used to set the waiting time in MySQL. wait_timeout♪ This parameter cannot be set to an endless expectation.

    Modify this parameter by the following team:

    SET GLOBAL connect_timeout=....;
    

    http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_wait_timeout




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2