- From: Eric Prud'hommeaux <eric@w3.org>
- Date: Tue, 16 Mar 2004 20:39:42 -0500
- To: public-annotation-dev@w3.org
On Tue, Mar 16, 2004 at 08:13:11PM -0500, Eric Prud'hommeaux wrote:
>
> still cound't sleep
>
> On Tue, Mar 16, 2004 at 05:22:52PM -0500, Eric Prud'hommeaux wrote:
> >
> > i haven't checked out the reply queries.
hmm, there seems to be something locking up the server when i do
this on a server with lots of triples (i wrote some queries to
import all the old annotations into the new tables).
best not try replying for now. if you do, and the server stops
responding, log into iggy and do
mysqladmin processlist
You should see the one using up all the resources, ala:
# mysqladmin processlist
+-----+------+-----------+------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
| 157 | root | localhost | iggy | Sleep | 27390 | | |
| 409 | root | localhost | iggy | Sleep | 15645 | | |
| 850 | root | localhost | iggy | Query | 7 | Sending data | SELECT STRAIGHT_JOIN count(*)
FROM __Holds__ AS __Holds___0
INNER JOIN __Nodes__ AS __Nodes___0 |
| 862 | root | localhost | | Query | 0 | | show processlist |
+-----+------+-----------+------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+
# mysqladmin kill 850
> > haven't formulated the DC1.0/1.1 flexible queries.
>
> done
>
> > attribution queries fail.
> > the program is actually just a small brick with a bow and wrapping paper.
> >
> > apart from that, all set!
> > --
> > -eric
> >
> > office: +81.466.49.1170 W3C, Keio Research Institute at SFC,
> > Shonan Fujisawa Campus, Keio University,
> > 5322 Endo, Fujisawa, Kanagawa 252-8520
> > JAPAN
> > +1.617.258.5741 NE43-344, MIT, Cambridge, MA 02144 USA
> > cell: +1.857.222.5741 (does not work in Asia)
> >
> > (eric@w3.org)
> > Feel free to forward this message to any list for any purpose other than
> > email address distribution.
>
> --
> -eric
>
> office: +81.466.49.1170 W3C, Keio Research Institute at SFC,
> Shonan Fujisawa Campus, Keio University,
> 5322 Endo, Fujisawa, Kanagawa 252-8520
> JAPAN
> +1.617.258.5741 NE43-344, MIT, Cambridge, MA 02144 USA
> cell: +1.857.222.5741 (does not work in Asia)
>
> (eric@w3.org)
> Feel free to forward this message to any list for any purpose other than
> email address distribution.
--
-eric
office: +81.466.49.1170 W3C, Keio Research Institute at SFC,
Shonan Fujisawa Campus, Keio University,
5322 Endo, Fujisawa, Kanagawa 252-8520
JAPAN
+1.617.258.5741 NE43-344, MIT, Cambridge, MA 02144 USA
cell: +1.857.222.5741 (does not work in Asia)
(eric@w3.org)
Feel free to forward this message to any list for any purpose other than
email address distribution.
Received on Tuesday, 16 March 2004 20:40:05 UTC