Page 1 of 1
Mysql connections not being released
Posted: Tue Feb 09, 2016 5:00 am
by lettertech
Just recently I have been having issues with my site not releasing the database after inquiries (per hosting company) I haven't done anything other than add a few products in the last few weeks. Nothing has been updated or changed other that that. I have downloaded the error log and it is quite big. (5mb) I am having a hard time viewing orders because I will hit my max db connections, so my site will either time out or come back with an empty store.
www.lettertech.com Someone please help me figure this out.
Thank you in advance
Re: Mysql connections not being released
Posted: Tue Feb 09, 2016 5:41 am
by IP_CAM
just to prepare for a clean DB Setup first:
Step 1:
config.php Files in SHOP
ROOT and
ADMIN Section:
if this exists:
// DB
define('DB_DRIVER', 'mysql');
---
change to:
// DB
define('DB_DRIVER', 'mysqli');
Step 2:
Download
Atomix legendary
turbo.php File, unzip and upload it to your Server ROOT, and
start it by calling it trough your Browser. Then start BOTH ROUTINES,
the first one, changing ALL OC-default MyISAM DB-Engine driven Tables to the one (only) single and even
more efficient
INNODB Engine troughout the
DB, and second,
indexing the full DB:
Atomix OpenCart TURBO OpenCart v.1.5.x - 2.x.x:
viewtopic.php?f=199&t=221103&p=805841#p805841
Then, come back and tell us more about possible errors,
still existing on your System.
Ernie
openshop.li
PS: Atomix is not longer active on Github, that's why I keep the latest ZIP on one of my servers.