I want to upgrade my virtual server’s MySql (4.x to 5.0) but FIRST need someone to update perl/php scripts on 2 directory sites to be sure the databases work after the MySql upgrade. The sites are:
info-storm.com & marketing-register.com. I host on a LAMP virtual server.
Recently mysqly server crash, due to too many connections, or error, or any other reason. The mysql is down now. I need an expert to bring it up online and also tune it up for maximum performance. This is mysql server only, there is nothing else running on it.
I’ve recently experienced some issues with my hosting provider (IPOWER) which is continuously locking my MySQL connections because I’ve reach either the max per user/hour, or the current connections.
It has been frustrating dealing with them to find a solution. So I’m not looking for help.
Basically I’m using 2 applications a CMS (Vivvo) and a forum (vBulletin), and towards the end of the hour, they are both getting locked until the DB connections reset at the end of the hour.
I have tried using multiple users to the DBs, and then in the config files of each application randomly connecting to it, but no luck yet.
I’m looking for either a php code in the application files to avoid this issue, or some type of configuration that I can use in the phpAdmin interface to also avoid it.
Thanks for your time
Subscribe in a reader
or
by Email (for daily job notification)
