Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:56 PM
Subject: Re: innodb file won't shrink
Heikki Tuuri wrote:
On September 15th, 2003 you will be able to put every InnoDB table
PROTECTED]; [EMAIL PROTECTED]
|Sent: Tuesday, July 15, 2003 1:13 AM
|Subject: Re: innodb file won't shrink
|
|
|-BEGIN PGP SIGNED MESSAGE-
|Hash: SHA1
|
|There 's any chance that in the future every InnoDB table files from a
|determinated database can be placed in the same directory of the mysql
Alvaro,
- Original Message -
From: Alvaro Avello [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 11:38 PM
Subject: Re: innodb file won't shrink
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sorry HeikkiCan you give me
Heikki Tuuri wrote:
On September 15th, 2003 you will be able to put every InnoDB table into its
own file. That should alleviate this kind of problem.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order
Nicholas,
- Original Message -
From: Nicholas Elliott [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, July 11, 2003 6:04 PM
Subject: InnoDB Performance issues
--=_NextPart_000_003B_01C3479C.77A1AB60
Content-Type: text/plain;
charset=iso-8859-1
Steve,
- Original Message -
From: Steve [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, July 10, 2003 11:24 PM
Subject: Re: innodb file won't shrink
I found the following thread:
http://groups.google.com/groups?threadm=9dpadc%2412ag%241
Sorry,
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 12:39 AM
Subject: Re: InnoDb and fragmentation
Mike,
...
So how do I defrag the InnoDb file space so I can get it back
up to speed?
The simplest method is
ALTER
In the last episode (Jul 11), Nicholas Elliott said:
I've been experimenting with the best way to store a large (~100GB)
of data for retrieval. Essentially, I'm storing 9 variables for
approximately 1,000,000 locations a day for the last ten years. This
can work out at around 4MB a variable a
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 11:29 AM
Subject: Re: InnoDB Performance issues
In the last episode (Jul 11), Nicholas Elliott said:
I've been experimenting with the best way to store a large (~100GB)
of data for retrieval. Essentially, I'm storing 9 variables
Hi Nicholas,
How about storing the BLOBS outside of the DB and refering to them ?
Best regards
Nils Valentin
Tokyo/Japan
2003 7 12 00:06Nicholas Elliott :
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data
for retrieval. Essentially, I'm storing 9
The size is already set to 2000M, and I may be wrong, but the autoextend
feature is not support
in mysql version earlier that 4.
Nils Valentin wrote:
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set f.e in my.cnf.
Best regards
Nils Valentin
Tokyo/Japan
Hi Mixo,
How about adding a second innodb file and set the first one to a fixed size ?
...If the disk becomes full you may want to add another data file to another
disk, for example. Then you have to look the size of `ibdata1', round the
size downward to the closest multiple of 1024 * 1024
Mark Depenbrock [EMAIL PROTECTED] wrote:
Can not make mysql connection -
error log:
030708 08:53:48 mysqld started
030708 8:53:49 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means
Hello Egor,
You give me hope but...
I attempted to set up permissions but it appears that I need to start
up MySQL in order to do that.
That brings me right back to my original problem of not being able to
connect.
I am thinking of reinstalling MySQL to see if I missed something in the
Message-
From: Mark Depenbrock [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:35
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB: Operating system error number 13 in a file
operation
Hello Egor,
You give me hope but...
I attempted to set up permissions but it appears that I
' (again, see the man pages for help)
Cheers
/rudy
-Original Message-
From: Mark Depenbrock [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:35
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB: Operating system error number 13 in a file
operation
Hello Egor,
You give me hope
Hello Nick,
You and I are just about on the same page here.
However, I just turned the page you are now baffling over.
Let me ask, Did you removed the old Macintosh
HD/Library/Receipts/mysql-standard-4.0.13.pkg file
before you did the new install.
If I am not mistaken, this is what cinched it
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB: Operating system error number 13 in a file
operation.
mysql doesn't have permissions for this file.
It is probably owned
Yep, that was it, along with what Mark said.
On Wednesday, Jul 9, 2003, at 15:10 US/Central, gerald_clark wrote:
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB:
At 8:19 +0200 7/9/03, mixo wrote:
The size is already set to 2000M, and I may be wrong, but the
autoextend feature is not support
in mysql version earlier that 4.
3.23.50, actually.
Nils Valentin wrote:
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set f.e in my.cnf.
Best regards
Nils Valentin
Tokyo/Japan
2003 7 8 22:45mixo :
How can I avoid this:
DBD::mysql::st execute failed: The table 'Transactions' is full at
Benny,
- Original Message -
From: Bernhard Schmidt [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, July 07, 2003 6:33 PM
Subject: innodb transaction
--=_NextPart_000_0144_01C344AD.CB5B11C0
Content-Type: text/plain;
charset=iso-8859-1
hi
many thanks for that quick and precise answer - a big smile. i am very
impressed by this user group, especially regarding the speed and quality of
the answers.
regards
benny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Mike,
- Original Message -
From: mos [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, July 07, 2003 5:54 PM
Subject: InnoDb and fragmentation
Heikki,
Do InnoDb tables suffer from internal table fragmentation. (Is there any
way to measure it?) I only mention this
Nils,
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 02, 2003 12:04 PM
Subject: InnoDB logfile question
Hello Heikki other Mysql Fans ;-);
Does anybody know which requests or data the below logfils actually keep
Hi Heikki,
2003 7 2 18:10Heikki Tuuri :
Nils,
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, July 02, 2003 12:04 PM
Subject: InnoDB logfile question
Hello Heikki other Mysql Fans ;-);
Does anybody know which
: Transaction Processing, published
around 1992.
Regards,
Heikki
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 12:34 PM
Subject: Re: InnoDB logfile question
Hi Heikki,
2003 7 2 18:10Heikki
to
be logged.
Regards,
Heikki
- Alkuperinen viesti -
Lhettj: Nils Valentin [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Lhetetty: Wednesday, July 02, 2003 1:39 PM
Aihe: Re: InnoDB logfile question
Hi Heikki,
I trust your info. However, I am currently waiting
Ivan,
if you have already dumped all InnoDB tables, then there is no need to keep
ibdata files and ib_logfiles. You can delete them and recreate them from
scratch and reimport the tables.
But in the printout which you pasted below you do not have
innodb_force_recovery set to 4?
When I test
I.-A.,
- Original Message -
From: I-A.Kotopoulos [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 25, 2003 10:05 AM
Subject: InnoDB file...
--=_NextPart_000_00B5_01C33B01.642AD2C0
Content-Type: text/plain;
charset=Windows-1252
If possible, what is the syntax?
It's possible, but if you can't search, I'm not sure you can handle it. ;P
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
From the InnoDB manual:
Dropping a table or deleting all rows from it is guaranteed to release the space
to other users, but remember that deleted rows can be physically removed only in
a purge operation after they are no longer needed in transaction rollback or
consistent read.
Perhaps that
John,
what Linux kernel version you are running? Did the first crash occur because
of the same assertion failure?
The InnoDB tablespace is probably corrupt and it asserts in purge or insert
buffer merge.
You can try starting with
innodb_force_recovery=4
in the [mysqld] section of your my.cnf.
John,
actually, you should first try
innodb_force_recovery=2
and run CHECK TABLEs.
Regards,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 1:25 AM
Subject: Re: Innodb error
John,
what Linux kernel version you
Hi Edward,
Thank you for the reply. I really appreciate the response,but I was thinking
into a different direction.
I was hoping that perhaps additionally to the normal backup procedure that
there is a shortcut or a trick which would quickly allow you to fix that
specific issue (f.e. recover
I will let others give their opinions on which one is best, but it is
important to point out that you are not making a one-or-the-other
decision. One of the advantages of using MySQL is that you can choose
the right table handler on a table-by-table basis. This means that you
can have sales and
http://www.innodb.com/ibman.html#Backing_up
See the section on Forcing Recovery.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 01:40
Subject: InnoDB question(s)
http://www.innodb.com/ibman.html#InnoDB_transaction_model
Scroll down a bit to Section 8.5
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Miguel Perez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 18:44
Subject: INNODB
Alternatively, use InnoDB Hot Backup: http://www.innodb.com/hotbackup.html
This will let you take a real-time backup of your InnoDB tables without
taking the server down.
Chris
Rafal Jank wrote:
Dnia Wed, 28 May 2003 12:57:59 +0200
Jarek Jarzebowski [EMAIL PROTECTED] zezna/a co nastpuje:
Hi,
On Wed, May 28, 2003 at 09:53:02AM -0700, Chris Tucker wrote:
Alternatively, use InnoDB Hot Backup: http://www.innodb.com/hotbackup.html
This will let you take a real-time backup of your InnoDB tables without
taking the server down.
Agreed.
Aside from shutting down MySQL and backing it up
Dnia Wed, 28 May 2003 12:57:59 +0200
Jarek Jarzebowski [EMAIL PROTECTED] zezna/a co nastpuje:
Hi,
I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM
and InnoDB tables. MySQL docs shows what is the best way to backup
InnoDB tables but I don't want to shutdown db server
I should add that my test continually inserted and deleted records from a set of
tables. At no point did any table have more than 101 records, but the test ran 348
times, so there were 348 * 100 rows INSERTed and DELETEd.
-ms
-- Original Message --
Kaming,
please run SHOW INNODB STATUS to monitor the amount of memory allocated by
InnoDB. If you have very many tables, the dictionary cache can take quite a
lot of memory. But it should not grow indefinitely.
If the problem is memory fragmentation caused by the malloc() in FreeBSD,
you can
Those are binary log files used in replication.
If you are not running replication, remove the line
bin-log
from the config file.
Tiele Declercq wrote:
Hey guys,
Ii could not find an answer on the innodb website, i'm using InnoDB now for some months and i'm very happy since the constant
Hello,
This actually brings up a question I've been meaning to ask.
from the InnoDB documentations
To be able to recover your InnoDB database to the present from the
binary backup described above, you have to run your MySQL database with
the general logging and log archiving of MySQL switched
Hey, thanks fopr the tip. Indeed the line was in there. Can i now erase
those bin files that have been written before ?
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Tiele Declercq [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 6:39 PM
Subject: Re
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 6:39 PM
Subject: Re: InnoDB
Those are binary log files used in replication.
If you are not running replication, remove the line
bin-log
from the config file.
Tiele Declercq wrote:
Hey guys,
Ii could not find an answer
Christian,
- Original Message -
From: Christian Jaeger [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, March 27, 2003 1:42 PM
Subject: Innodb transactions and drop table
Hello
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the
Christian,
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this should be documented. (Or better yet, not
At 13:22 +0100 3/27/03, Stefan Hinz wrote:
Christian,
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this
# [EMAIL PROTECTED] / 2003-03-24 23:49:59 +0100:
this is what Mysql Reference Manual tells me about creating foreign
keys.
I understood how to use them, except for the restrict here ---\
|
[CONSTRAINT symbol] FOREIGN KEY
On Wednesday 19 March 2003 15:19, Thorsten Schmidt wrote:
how can I remove a foreign key in InnoDB?
ALTER TABLE DROP (FOREIGN) KEY `key`
isn't working (and also not specified in documentation)... : (
Currently you should recreate table to remove FOREIGN KEY CONSTRAINTS.
--
For technical
Dear all,
how can I remove a foreign key in InnoDB?
ALTER TABLE DROP (FOREIGN) KEY `key`
isn't working (and also not specified in documentation)... : (
It's not implemented yet. You can copy your data to another table without
the foreign key constraint, drop original one and
On Tuesday 18 March 2003 02:26, Custódio de Matos Lima wrote:
Im having some troubles when creating the foreign key
constraints in a InnoDB database. The problem is, i
can create the InnoDB table, but im having a little
difficult to make the connections with other tables.
The error that
Philip,
- Forwarded message from Philip Molter [EMAIL PROTECTED] -
Date: Mon, 10 Mar 2003 08:30:22 -0600
From: Philip Molter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: InnoDB Assertion Error
THE SITUATION:
We're running MySQL 3.23.51. We have a table which has a
MySQL must be compiled with support for InnoDB, if yours wasn't, you
wouldn't be able to use InnoDB tables. You can download a MySQL binary here:
http://www.mysql.com/downloads/mysql-3.23.html
According to the InnoDB quick start page
(http://www.innodb.com/howtouse.html), you'll want MySQL-max:
At 22:28 + 3/10/03, Paul Taylor wrote:
I have MySQL 3.23, running on Windows XP. I don't seem to be able to make my
tables Innodb type. Is there something I should install, or some script I
should configure. Looking on the MySQL site, I noticed there was a script I
should run. I'm so
On Thu, Mar 06, 2003 at 04:24:10PM -0800, Ask Bjoern Hansen wrote:
I am running RedHat 7.3, mostly using InnoDB's. I am using the
MySQL-Max rpms (4.0.11) from mysql.com.
Earlier today it crashed, and while trying to start up again it
crashed again. Now I can't start the server with the
]
To: Zak Greant [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]
Sent: Friday, March 07, 2003 3:12 AM
Subject: Re: InnoDB crash report; fatal failure on restarts too!
On Thu, 6 Mar 2003, Zak Greant wrote:
A quick update. The harddrive is crashing, so it's entirely likely
that the corruption
On Thu, 6 Mar 2003, Jeremy Zawodny wrote:
I am running RedHat 7.3, mostly using InnoDB's. I am using the
MySQL-Max rpms (4.0.11) from mysql.com.
Earlier today it crashed, and while trying to start up again it
crashed again. Now I can't start the server with the InnoDB tables.
I
to whom it may concern,
I need some help regarding transactions using innodb tables.
I am running MySQL 3.23.51-Max as database server and developing a web
front-end using ASP. Many of the tables used are of innodb format since it
is imperative for me to use transactions in most of my scripts.
, March 03, 2003 10:05 AM
Subject: Re: innodb deadlock leads to server crash
Hi!
A deadlock of threads is a bug. It is is not connected to transactions or
multiversioning.
Is the problem repeatable in your computer?
Can you compile a debug version of mysqld? Go to the source tree root
InnoDB.
Thank you,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:24 AM
Subject: Re: innodb deadlock leads to server crash
Hi!
Your email address gives the error:
DNS for host dev.noris.de is mis
the
result in smaller chunks. I could then release the S-latch always when the
program control leaves InnoDB.
Thank you,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:24 AM
Subject: Re: innodb deadlock leads to server crash
Hi!
A deadlock of threads is a bug. It is is not connected to transactions or
multiversioning.
Is the problem repeatable in your computer?
Can you compile a debug version of mysqld? Go to the source tree root
directory /mysql/ and do:
./BUILD/compile-pentium-debug-max
Then run the compiled
Michael T. Babcock wrote:
I've got a nice MySQL crash that happened during the night last night and I
can't seem to get it to come back online for me without --skip-innodb.
Follow-up with mysql's bug report:
MySQL support: none
Synopsis:InnoDB Crashing on Startup
Severity:critical
2.4.20.
Regards,
Heikki
Innobase Oy
sql query
- Original Message -
From: Michael T. Babcock [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, February 21, 2003 9:23 PM
Subject: Re: InnoDB Crash [more info]
Michael T. Babcock wrote:
I've got a nice MySQL crash
Michael,
how do I send you email? A 'Spamcop' seems to block email to you.
Regards,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Michael T. Babcock [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 21, 2003 10:33 PM
Subject: Re: InnoDB Crash [more
PM
Subject: Re: InnoDB Crash [more info]
Michael,
how do I send you email? A 'Spamcop' seems to block email to you.
Regards,
Heikki
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: Michael T. Babcock [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 21
On Wednesday 19 February 2003 13:21, Rusch (ext) Reiner wrote:
I have one question about InnoDB-tables especial the filesize of all
tables. In the past I took MyISAM but found out, some things in InnoDB make
the system more stable.
But I want to get more free space. In MyISAM the space grows
Assuming your server supports innodb, you can use:
Alter table table_name TYPE = InnoDB;
if it failed, simply create a table with the new type,
populate it with the data in your table (with the
wrong type), drop the old table and rename the new
table.
--- [EMAIL PROTECTED] wrote:
Are you
Scott Wong [EMAIL PROTECTED],
Do you think the following links may help?
* http://www.mysql.com/doc/en/example-Foreign_keys.html
* http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
* http://www.mysql.com/doc/en/ALTER_TABLE.html
*
Scott,
I would like to declare this as a 'feature'. You should not define multiple
foreign key constraints on the same foreign key/referenced key pair.
I could, of course, add an error message if someone tries to do that.
The algorithm in ON UPDATE CASCADE and ON DELETE CASCADE is this: InnoDB
Are you running mysql or mysql-max? InnoDB is not supported in standard
mysql. If you are running max then are there any error messages?
Extranet
[EMAIL PROTECTED] - 05/02/2003 17:17
To:mysql
cc:
Subject:innodb
I have a small probleme with MySQL in 3.23.55.
I do not manage to
Scott,
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Starting from version 3.23.50 you can also associate the ON DELETE CASCADE
or ON DELETE SET NULL clause with the foreign key constraint. Corresponding
ON UPDATE options are available starting from 4.0.8.
Regards,
Heikki
Innobase Oy
Davy,
DO I have been trying to get InnoDb to run on my windows XP machine.
DO (...)
DO #innodb_data_home_dir =
DO #innodb_log_group_home_dir =
DO #innodb_data_file_path = /ibdata/ibdata1:10M:autoextend
The remarks are in German, but I guess you will know what to do if
you look at the following
i see that you don't specify any path for
innodb_data_home_dir, innodb_log_group_home_dir and
innodb_data_file_path ... write down the correct path
and retry.
regards.
--- Davy Obdam [EMAIL PROTECTED] ha scritto: Hi
People,
I have been trying to get InnoDb to run on my
windows XP
In the last episode (Feb 04), Shomal Bafna said:
The box is running a MySQL 3.23-47 Max rpm based version on a
Mandrake 8.2 Linux with Duron processor and 256MB Ram. Thera are 10
InnoDb type tables created and several MyISAM types too (approx 30
more.). On adding the 11 table of InnoDb type
Shomal,
- Original Message -
From: Shomal Bafna [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, February 04, 2003 7:46 PM
Subject: Innodb: Limited creation of tables
The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2
Linux with Duron
On Tue, 4 Feb 2003, Shomal Bafna wrote:
The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2
Linux with Duron processor and 256MB Ram. Thera are 10 InnoDb type tables
created and several MyISAM types too (approx 30 more.). On adding the 11
table of InnoDb type the
It appears that the record has room out of room.
135 = No more room in record file
-Original Message-
From: Shomal Bafna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 9:56 AM
To: [EMAIL PROTECTED]
Subject: Innodb: Limited creation of tables
The box is running a MySQL
Matthias,
what have you done? Below you create table 'foo' but mysql answers that it
cannot create 'stundenliste.frm'.
mysql create table foo (id int auto_increment,unique key (id))
type=innodb;
ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121)
mysql create table
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to be happy.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 11:29 AM
To: Joe Stump
Subject: Re: InnoDB / MyISAM
Your message
Hi.
- Original Message -
InnoDB appears to be losing records.
The version I am using is 3.32.53 in Windows 2000.
Gaps are appearing in the autoincrement sequence when
the application does not permit record deletions.
Records disappear although they have been retrieved
for
magically disappear.
I am not fond of the REPLACE statement. It is 'implicit programming', which
can produce hard-to-find bugs in your application. Similar implicit bugs
arise from the use of ON DELETE/UPDATE CASCADE and triggers.
Regards,
Heikki
sql query
Subject: Re: InnoDB
Carlos,
- Original Message -
From: Carlos Proal [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, January 19, 2003 7:13 PM
Subject: Innodb enable/disable keys
Hi, i have a simple question:
The sql statement: alter table _table_name_ disable keys;
has any
Muhammed,
- Original Message -
From: Muhammed Syyid [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, January 16, 2003 3:06 PM
Subject: Re: InnoDB Foreign Key Questions
Second the same question :). What does the CONSTRAINT keyword
regarding FOREIGN KEYS do
Hi!
- Original Message -
From: My Deja [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, January 16, 2003 12:39 PM
Subject: InnoDB is losing records, there are gaps in autoincrement sequence
InnoDB appears to be losing records.
The version I am using is 3.32.53 in
Heikki Tuuri wrote:
In the future, MySQL might do the following: in
CREATE TABLE abbaguu (
...
FOREIGN KEY (column1) REFERENCES frobboz (column2)
) TYPE=InnoDB;
it could check if there is a suitable index in abbaguu. If not, it would
create the index automatically.
For what its worth, and
Harald Fuchs wrote:
You _did_ enter some data, namely a string which just happens to be
the empty string (which in turn is different from no data, i.e. NULL).
How should MySQL know that you don't want empty strings?
I think the user expects:
INSERT INTO table (bar) VALUES (text);
to behave
: Wednesday, January 15, 2003 1:23 AM
To: [EMAIL PROTECTED]
Subject: Re: InnoDB table, NOT NULL question
In article [EMAIL PROTECTED],
Adolfo Bello [EMAIL PROTECTED] writes:
This is wierd. If you define a field as not null is because you want
the user to enter some data, for example, First Name
On Monday 13 January 2003 23:38, Gabe Geisendorfer wrote:
Hello, I'm in the process of moving from Postgres to MySQL and I have a
question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id`
Hello, I'm in the process of moving from Postgres to MySQL and I have a
question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL auto_increment,
`somevalue1` varchar(35) NOT NULL,
.
Thanks,
Gabe
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 7:11 AM
To: [EMAIL PROTECTED]
Subject: re: InnoDB table, NOT NULL question
On Monday 13 January 2003 23:38, Gabe Geisendorfer wrote:
Hello, I'm in the process of moving from
]
Subject: Re: InnoDB table, NOT NULL question
Hello, I'm in the process of moving from Postgres to MySQL and I have
a question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL auto_increment,
`somevalue1` varchar(35) NOT NULL,
`somevalue2` varchar(35) NOT NULL,
PRIMARY KEY (`stuff_id`)
) TYPE=InnoDB COMMENT='stuff table';
I run the following
If this is going to hurt someone please when u
see mails from [EMAIL PROTECTED] do not
scroll down to the bottom
I won't. I've had enough of this, so I just set my mail program to erase any
mails from you. I do the same for anyone who repeatedly promotes religious
or political views on the
.
Sincerely,
Paul Magid, DBA
-Original Message-
From: Sameh Attia [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 1:54 AM
To: [EMAIL PROTECTED]
Subject: [OT] Re: InnoDB vs. MySQL performance Issue
Sam Przyswa wrote:
Septenber 11 2001, more than 3000 women, men, child, killed
PROTECTED]; [EMAIL PROTECTED]; 'Michael Widenius' [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 7:46 AM
Subject: RE: [OT] Re: InnoDB vs. MySQL performance Issue
To MySQL AB:
Your lists are being used to disseminate extremist muslim hate-speech.
As
such, this will reflect terribly negatively
Sam Przyswa wrote:
Septenber 11 2001, more than 3000 women, men, child, killed, Tel Aviv January 5
2003, 23 death and 100 injured by islamic terrorists, that's the islamic history
(small part).
Sam Apache-PHP-MySQL user.
--
Albert Einstein, Karl Marx, Jesus Christ,
and you Mohamed what have
1001 - 1100 of 1574 matches
Mail list logo