Skip to main content
Home
Blog

Main navigation

  • Home
User account menu
  • Log in

Breadcrumb

  1. Home

Mysql persistent connection or not?

By ongetc , 12 February, 2017

When installing a CMS you usually present with a choice to use MySQL persistent connection and the question is should you use persistent or not!

The reason for using persistent connections is reducing the number of connects which are rather expensive but...

On shared host, people frequently are having trouble with MySQL timeout and MySQL connection problem and I believe the major contributing factor is there are only so many numbers of connections on a particular server and if you setup your site to use a persistent connection you basically limiting other people chances of using the connection when your site might not using the connection.

In a server where the connection to the server is pretty static and predictable then MySQL persistent connection might help to improve some but on a shared host, MySQL persistent connection will do more harm than good.

So my recommendation is not to use MySQL persistent connection when to install a CMS on shared host.

Reseller hosting (free)

Hosting24 (w/ ssh)

A2 Hosting

Monthly archive

  • September 2009 (14)
  • October 2009 (11)
  • January 2010 (2)
  • June 2010 (3)
  • October 2011 (1)
  • March 2012 (1)
  • July 2012 (1)
  • February 2017 (564)
  • March 2017 (5)
  • April 2017 (2)

Pagination

  • 1
  • Next page

Popular content

Last viewed:

  • F3Site
  • How to do normal URL with Zend Framework?
  • CuteNews
  • Piwigo
  • Geeklog
  • PDF pages counting using VB script.
  • Diem
  • DotNetNuke
  • widgEditor
  • hosting24.com

User login

  • Reset your password