- Original Message -
From: Daevid Vincent dae...@daevid.com
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
On Thu, Feb 23, 2012 at 5:50 PM, Daevid Vincent dae...@daevid.com 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
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
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
According to Michael Dykman mdyk...@gmail.com 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.
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
According to Michael Dykman mdyk...@gmail.com 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
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
According to Michael Dykman mdyk...@gmail.com 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?
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 w...@umich.edu wrote:
According to Michael Dykman mdyk...@gmail.com on Fri, 02/24/12 at 13:23:
At this point, I would not know what else to do
On Fri, Feb 24, 2012 at 1:46 PM, William Bulley w...@umich.edu 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?
According to Andrew Moore eroomy...@gmail.com 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
According to Michael Dykman mdyk...@gmail.com 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?
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
14 matches
Mail list logo