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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us.
