Hello,
Unless I misunderstood the task, the exclusive lock would be one way to solve
it. What you want to do, is have both parent and children start their
activities with locking the table in exclusive mode and then performing their
operations. The parent and children will then all seriali
According to Michael Dykman on Fri, 02/24/12 at 14:10:
>
> *maybe* your router is doing some packet mangling? Wild shot in the dark..
That is worth investigating... :-)
Thanks.
> Perhaps try hitting that 'local' server' from a remote client to see
> if the effect is the same? Is this the one
According to Andrew Moore on Fri, 02/24/12 at 14:03:
>
> To rule out a version issue have you tried another host with the
> problematic version and same/similar config?
No, for two reasons:
a) I just tumbled onto the idea of doing a version upgrade today,
and
b) the amount of work to do as you
On Fri, Feb 24, 2012 at 1:46 PM, William Bulley wrote:
>> Are both servers on the same subnet?
>
> Negative.
*maybe* your router is doing some packet mangling? Wild shot in the dark..
>> Is your DBVisualizer client local to either of these or on the same
>> subnet as one and not another?
>
> Th
To rule out a version issue have you tried another host with the
problematic version and same/similar config?
On Feb 24, 2012 6:47 PM, "William Bulley" wrote:
> According to Michael Dykman on Fri, 02/24/12 at 13:23:
> >
> > At this point, I would not know what else to do except fire up
> > wires
According to Michael Dykman on Fri, 02/24/12 at 13:23:
>
> At this point, I would not know what else to do except fire up
> wireshark and start debugging the packets.
Well, doesn't that beat all, sigh... Now I'm back to square zero... :-(
> Are both servers on the same subnet?
Negative.
> Is
At this point, I would not know what else to do except fire up
wireshark and start debugging the packets.
Are both servers on the same subnet?
Is your DBVisualizer client local to either of these or on the same
subnet as one and not another?
You mentioned a minor version difference between the se
According to Michael Dykman on Fri, 02/24/12 at 12:58:
>
> I see your point. Configuration files aside, what do you get when you
> query the servers themselves with:
>
> show variables like 'max_allowed_packet'
>
> There *might* be something in your start-up scripts overriding that
> config
I see your point. Configuration files aside, what do you get when you
query the servers themselves with:
show variables like 'max_allowed_packet'
There *might* be something in your start-up scripts overriding that
config setting.
- md
On Fri, Feb 24, 2012 at 11:57 AM, William Bulley wrot
According to Michael Dykman on Fri, 02/24/12 at 11:42:
>
> That error is coming from neither the MySQL server nor from
> DBVisualizer. That is coming from your JDBC driver. Check the
> version of that and research the effect of configuration options.
>
> http://dev.mysql.com/doc/refman/5.0/en/c
That error is coming from neither the MySQL server nor from
DBVisualizer. That is coming from your JDBC driver. Check the
version of that and research the effect of configuration options.
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
- michael dykm
I am using DBvisualizer to inspect two MySQL 5.1 databases on two
different systems. The two different systems are nearly identical
in the O/S and the version of MySQL (5.1.58 vs 5.1.60). Both the
systems have MySQL configured in the same way (see below) and are
successfully using MySQL underneat
On Thu, Feb 23, 2012 at 5:50 PM, Daevid Vincent wrote:
> Anyone have any thoughts on how I might optimize this query?
As always, it's all about the indexes. The index it chose on your
main table looks pretty weak. You probably should move those
non-joining columns out of your join condition in
- Original Message -
> From: "Daevid Vincent"
>
> d.`date_release`!='-00-00' AND sd.`scene_id`=s.`scene_id` GROUP
> BY sg.`scene_id` ORDER BY num DESC, sd.`count_dl_monthly` DESC LIMIT 30;
Could you put an index on sg.scene_id? Not sure, but it might help the grouping
be more effici
14 matches
Mail list logo
