Hi,
Status;
gives your own session id. To be combined to show innodb status (ksh or perl).
Mathias
Selon Frank Schröder [EMAIL PROTECTED]:
[EMAIL PROTECTED] wrote:
Frank Schröder [EMAIL PROTECTED] wrote on 05/31/2005 03:18:11 AM:
Hello,
I have an InnoDB table running on MySQL 4.1.11
[EMAIL PROTECTED] wrote:
Hi,
Status;
gives your own session id. To be combined to show innodb status (ksh or perl).
Mathias
I'm not sure I understand.
Are you saying that SHOW INNODB STATUS shows only the information of the
current session or that I can supply a session id to the call?
I say this :
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.11-nt-max-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql status
--
mysql Ver 14.7 Distrib 4.1.11, for Win32
Frank Schröder [EMAIL PROTECTED] wrote on 05/31/2005 03:18:11 AM:
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know which of the
constraints failed.
SHOW
[EMAIL PROTECTED] wrote:
Frank Schröder [EMAIL PROTECTED] wrote on 05/31/2005 03:18:11 AM:
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know which of the
Frank Schröder wrote:
The thing that's really a headscratcher for me is why its possible for
me to set a name for a constraint if it isn't displayed in an error and
I can't get to it. It's useless.
Same as setting a name for an index -- it allows you to alter or delete it
later.
--
Keith
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know which of the
constraints failed.
SHOW INNODB STATUS returns the following output
...
CONSTRAINT
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know which of the
constraints failed.
SHOW INNODB STATUS returns the following output
...
CONSTRAINT