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 <baron@stripped> 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=1
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on
us.
