Hello,
I am having trouble finding a way to retrieve the table and field a
foreign key references by querying MySQL. If you look at the following
example tables, there is no way after the tables are created to learn
that:
- address.sid actually references state.id
Is this possible ?
For exam
A quick reminder that there's one week left to submit your abstract for
this year's Surge Scalability Conference. The event is taking place on
Sept 30 and Oct 1, 2010 in Baltimore, MD. Surge focuses on case studies
that address production failures and the re-engineering efforts that led
to victor
Folks - I've check out several application people have suggested.
I LOVE Toad for mySQL, and Spotlight for mySQL.
Thanks for all the advice!
-Original Message-
From: Steven Staples [mailto:sstap...@mnsi.net]
Sent: Friday, July 02, 2010 8:22 AM
To: mysql@lists.mysql.com
Subject: RE: phpM
I personally use SQLYog, and as for it not having the "query creation"... it
has a fairly decent query builder, but it is in the paid version, not the
community one.
I like all the features it has, and I use most of them. Granted, it is
always a good idea to know how to use the command line, just
I do not know that part of the mysql source code well, but I am very sure
you will take the dns hit even if all of your grants are ip based.
I suggest you put put that setting into your cnf and bounce the instance.
You will also never run into issues with max connect error if you set skip
name re
We do not use that setting at present no specifically because all hosts
use ip's to connect and not dns / hostnames.
We can't seem to find any errors thus the reason for truggling to pinpoint
the exact cause.
Machiel Richards
MySQL DBA
Relational Database Consulting
RDC_Logo
A bad assumption I make these days is that everyone has skip resolve off. If
that is the case DNS issues will not impact you.
Do you have that setting?
Do you see errors on the interface?
On Fri, Jul 2, 2010 at 1:05 AM, Machiel Richards wrote:
> Hi
>
>
>
>From a thread found on the net it
Hi
From a thread found on the net it also suggests that it might be network
or DNS related.
The connections building up is the following:
*** 1346. row
***
Id: 903175
User: unauthenticated user
On Thu, Jul 1, 2010 at 5:44 PM, Grant Peel wrote:
> Hi all,
>
> I have serveral servers running mysql 4, and need to update to mysql 5.
>
It would be good if mentioned what release of the various series you
were using or wanting to upgrade to.
> I have version 5 setup on a new dev server and will
On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> A few days ago i posted some questions relating to mysql
> threads running out and not being able to restart the database.
>
>
>
> We had the same again this morning however this ti
10 matches
Mail list logo
