From: Pat Singer (patsingerfbsdyahoo.com)
Date: Sat Jul 14 2007 - 16:27:44 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

First up, the sites were working fine until the old server went buggy. I hadn't worked on either of the shopping carts, so they should have been fine when I transfered them over. No, I'm confident there is nothing wrong with my code, etc. I suspect it has something to do with copying over the database, which was strange. Certain databases didn't copy over for some reason, and I had to install them manually. Plus, the permissions database (whichever that is, forgive my ignorance) didn't copy and I just recreated it (that is, created the correct user gave the permissions to the proper databases). Now, here's the output from mytop:
   
    2 mysqluser localhost mrtableclo 0 Sleep
      14 root localhost test 0 Query show full processlist
       4 mysqluser localhost mrtableclo 6154 Sleep
       3 mysqluser localhost mrtableclo 9210 Sleep
   
  So, apparently it's asleep. How do I wake it up ;)
  TIA,
  Pat

Baron Schwartz <baronxaprb.com> wrote:
  Hi,

Pat Singer wrote:
> Hi;
> I just built out a new server and transfered my databases. I use Zope to server my web sites and ZMySQLDA to interface between the two. Everything seems to be fine. I can see the databases, the tables, the columns in the tables, the permissions are correct, etc. I hook up ZMySQLDA and that seems to be fine. It connects to the database. However, when I go to look at the pages from served the database, the browser hangs. Any ideas how to troubleshoot this?

Is it really the database that's hanging? Use innotop or mytop to see if a
query is stuck. Maybe the problem is in your code or on the web server, not the
database.

Baron

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=patsingerfbsdyahoo.com

       
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]