is increasing quite drastically as I pile on more
variable comparisons... I am guessing because I am increasing that
number of comparisons that must be done...
Thanks,
Mathew
[EMAIL PROTECTED] wrote:
Mathew Ray <[EMAIL PROTECTED]> wrote on 03/24/2005 10:42:51 AM:
Been searching for a while a
Been searching for a while and can't seem to come up with any good
answers to this - I have a normalized structure of about 5 tables that I
need to denormalize into one big representation of the entire structure.
Anyone know of a good tool or resource to 'flatten' my tables easily?
I've got a
I am guessing the long duration is caused by having to do complete table
scans. How big is your dataset?
What about creating another index in resource_goals that includes
GoalNumber and ResourceID? Perhaps even Subject, Grade, and
NumericGrade As I learned just a couple days ago, making sur
is zabbix (http://www.zabbix.com), its very
easy to setup and personally I think its excellent. It may be overkill if
you just want to check a db is up though
-Original Message-
From: Mathew Ray [mailto:[EMAIL PROTECTED]
Sent: Thursday, 17 February 2005 2:35 AM
To: mysql
though...
~mathew
Michael Dykman wrote:
On Wed, 2005-02-16 at 10:35, Mathew Ray wrote:
Has anyone used or built a db monitoring tool for MySQL?
I have come across various system-level heartbeat tools, but I am
specifically looking for a solution that will work on Win2K Server and
RedHat boxes
Has anyone used or built a db monitoring tool for MySQL?
I have come across various system-level heartbeat tools, but I am
specifically looking for a solution that will work on Win2K Server and
RedHat boxes, as we have several servers that each run different
instances of mysql.
No replication o
M data
INNER JOIN names ON data.name_id=names.id
INNER JOIN values ON data.value_id=values.id
WHERE data.campaign_id = 22
AND names.name = 'content'
AND values.value = 'index'
PB
-
Mathew Ray wrote:
Newbie on the list here having a bit of confusion at the moment
Newbie on the list here having a bit of confusion at the moment why an
INNER JOIN is taking so long... I have replaced a few column names to
make it a bit more succinct:
SELECT COUNT(*)
FROM data, values, names
WHERE data.campaign_id = 22
AND names.name = 'content'
AND values.value = 'index'
AND
