Hi Maurice,
You say the MySQL data wasn't on the stuck volume, but were the InnoDB logs?
What is the disk configuration?
It sounds to me like bad hardware/software, which, unfortunately MySQL
and InnoDB cannot protect you from...
Regards,
Jeremy
Maurice Volaski wrote:
Some processes
Some processes on a server (64-bit Gentoo Linux with MySQL 5.0.44),
which seemed to be related to I/O on LVM volumes hung and it was
necessary to force reboot it. The mysql data was not on an LVM volume
though it still may have been affected since over time, more and more
processes became unres
Egor Egorov <[EMAIL PROTECTED]> wrote:
> "Stefan Gnann" <[EMAIL PROTECTED]> wrote:
>
>> I have a mysql database 4.0.15 on a suse linux 9.x system running.
>
> First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/).
> RPM version is easy to install and run.
O
"Stefan Gnann" <[EMAIL PROTECTED]> wrote:
> I have a mysql database 4.0.15 on a suse linux 9.x system running.
First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/).
RPM version is easy to install and run.
> Now we have to use the features of InnoDB tables (rollbac
://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: "Gary Richardson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 21, 2004 7:46 PM
Subject: Re: mysql and innoDB
Is there any
Is there any output from the command? Any errors?
Try SHOW CREATE TABLE x. It should show you the TYPE= at the end.
out.
On Thu, 21 Oct 2004 11:10:10 +0200, Stefan Gnann
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have a mysql database 4.0.15 on a suse linux 9.x system running.
> Now we hav
Hi all,
I have a mysql database 4.0.15 on a suse linux 9.x system running.
Now we have to use the features of InnoDB tables (rollback, a.s.o.).
Up to now we use the standard table type MyISAM.
Now I want to change the tabel type with the command "ALTER TABLE x TYPE
= InnoDB".
The command doesn
nal Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 10:48 PM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hello Heikki,
>
> > why you do not look with SHOW INNODB STATUS if there are dang
Hello Heikki,
> why you do not look with SHOW INNODB STATUS if there are dangling
> transactions which could still see the delete-marked rows? Purge cannot
> remove them then.
This is what I see:
mysql> show table status like 'sccchangelog';
+--++++---
ECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 12:10 AM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hi,
>
> I wanted to post a follow-up question to the inquiry below. I've done some
more research since my last post and now
Hi,
I wanted to post a follow-up question to the inquiry below. I've done some more
research since my last post and now think that the performance problem is related to
something other than uncommitted transactions. More specifically, I think the culprit
is the lack of timely synchronization
Hi,
> > Hi,
> >
> >I would like to know if is there a way to delete constraints
> >without dropping and recreating a table. If there isn't, I would
> >like to know when do you plan to implement this important feature.
I would also like to see this feature. I have been implementing a
Dyego,
- Original Message -
From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 10:42 PM
Subject: The MySQL and InnoDB FK´s
> Hi,
>
>I would like to know if
Hi,
I would like to know if is there a way to delete constraints
without dropping and recreating a table. If there isn't, I would
like to know when do you plan to implement this important feature.
Thanks in advance,
sql,query
Hi.
Is there a chance that you make this behaviour dependend on the --ansi
switch? I never used foreign keys until now, but from the theory I
would expect that a missing "not null" declaration on a FK declaration
should either be implicitly assumed or result in an error - at least
on insert.
I m
ttp://www.innodb.com, download MySQL-Max from http://www.mysql.com
- Original Message -
From: ""Alain Del Giust"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, April 09, 2002 7:59 PM
Subject: Re: mySQL and innoDB
> "if you have a forei
> -Original Message-
> From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:48 PM
> To: Christopher Thompson; [EMAIL PROTECTED]
> Cc: Rance Hall
> Subject: Re: mySQL and innoDB
>
>
> I am just testing mySQL so I will be able to
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote:
> I am just testing mySQL so I will be able to use it instead of Oracle
> Sybase ...
>
> I am not saying a PK can be NULL wich is impossible
> But a FK can be NULL and I'd like to know how to do that with mySQL
I do not see this as being a
he employee who is at the top of the hierarchy as no manager ...
so for A and B in the hierarchy table the foreign key referencing
employee.employee_id is NULL
Alain
- Original Message -
From: "Christopher Thompson" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROT
c.
[EMAIL PROTECTED]
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 12:05 PM
To: Alain Del Giust; [EMAIL PROTECTED]
Subject: Re: mySQL and innoDB
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
> "if you have a foreign key con
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
> "if you have a foreign key constraint, that field must be one of the values
> of the referenced column and that column, being an index, is never NULL"
>
> OK so my understanding is that it is impossible with mySQL to do such
> things wich
Enterprise
Sybase Adaptive Server Anywhere
Thanks,
Alain
- Original Message -
From: "Rance Hall" <[EMAIL PROTECTED]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:42 PM
Subject: RE: mySQL and innoDB
b values ('BBB','aaa');
> works well
>
> Alain
>
> - Original Message -
> From: "Rance Hall" <[EMAIL PROTECTED]>
> To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, April 09, 20
ssage-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:45 AM
To: Rance Hall; [EMAIL PROTECTED]
Subject: Re: mySQL and innoDB
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for exam
D]>
To: "Alain Del Giust" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 6:25 PM
Subject: RE: mySQL and innoDB
The "insert into b values ('BBB', NULL)" statement should fail under the
conditions you describe, BBB was not inserted int
mer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: mySQL and innoDB
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles i
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
i
27 matches
Mail list logo
