SQL Locks Up

Posted on 15 Jun 2010, 22:01:54

Access: Member
Total Posts: 1
Joined: 2010-06-15

I have a pretty active website with about 114,000 unique visits a month and I upgraded from 3.3 to 3.6 when doing so I started to get tons of MySql process hanging around and after about 5 minutes mysql would stop working and I would need to restart it. I have since reverted back to my backup. Any ideas on why this would be?

#2499

Chris

Posted on 15 Jun 2010, 23:52:14

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Since 3.3 there has been some huge changes in the system, most of it has been rewritten from scratch.

When you do a fresh install of 3.6 it gives you the option of which type of interface you want to use for the database, MySQL, MySQLi or PDO. If upgrading from 3.3 or less it'll use MySQL by default.

You can try switching it from MySQL to one of the others to see if that makes any difference in performance.

Edit your db.php, it should look something like this

Code:


<?php
/*------- Database connection info & settings ------*/
$cfg['hostname'] = "localhost";
$cfg['user'] = "username";
$cfg['pass'] = "password";
$cfg['database'] = "news33";
?>

Change it to look like this

Code:


<?php
/*------- Database connection info & settings ------*/
define('HOSTNAME',    'localhost');
define('USER',        'username');
define('PASS',        'password');
define('DATABASE',    'news33');
define('PORT',        '');
define('SOCKET',    '');
define('EXTENSION',    'mysql');
?>

Changing the extension to either 'mysqli' or 'pdo'

#2500