Eduardo,
to make the user interface simple, I decided to take the table per file
approach. Each .ibd file is internally a 'tablespace'.
The simple approach I chose is similar to how MyISAM now works. I thought it
would be nice for current MySQL users.
In Oracle, one can store several tables into
Chris,
1. Peter Zaitsev ran some tests which suggested that multiple .ibd files are
not slower than one ibdata file. But it will depend on the OS version. Some
OS'es may have bad fsync() implementation, which can cause slowdown with a
large number of files.
2. Clustering? If you mean the fact tha
All,
the VACUUM in PostgreSQL removes delete-marked records from the database.
In InnoDB, the VACUUM is called the purge. In InnoDB purge happens
automatically in the background, the user does not need to explicitly run
VACUUM, like in PostgreSQL. Also in Oracle purge is automatic.
The way to co
Chris,
for MyISAM and InnoDB, ALTER TABLE normally locks the table to be altered in
a read-only mode.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyI
ictionary().
* There are several outstanding non-critical bugs reported in the MySQL bugs
database. Their fixing has been delayed, because resources are allocated to
the upcoming 4.1.1 release.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
--
MySQL General Mailing List
For list
- a hot backup tool for InnoDB which also backs up
MyISAM tables
- Alkuperäinen viesti -
Lähettäjä: "Varshavchick Alexander" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Tuesday, Octobe
Martijn,
are you now aware that MySQL supports transactions and foreign key
constraints? In January you still claimed the contrary in an InterBase
newsgroup.
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot
Alex,
in FreeBSD user process memory space is often restricted to 512 MB. You have
to reconfigure or recompile the FreeBSD kernel to increase that limit.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup
Hi!
Mark Matthews, the author of Connector/J commented on the speed improvements
of JDBC since the eWeek benchmark.
Best regards,
Heikki
- Alkuperäinen viesti -
Lähettäjä: "Mark Matthews"
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Lähetetty: Thursday
Venu has improved also ODBC.
> Lastly, looking at the MS SQL Server benchmarks on a .NET setup, what
would
> everyone speculate about MySQL's performance in that setup? Is .NET really
> that much more efficient for this sort of application?
Can a .NET user comment on this?
> R
Mike,
MySQL AB charges U.S. $1650 per day:
http://www.mysql.com/consulting/migration.html
"
The cost of MySQL Migration Assistance starts at 3.300 euros + taxes
(Europe) or 3.300 dollars + taxes (US), with the following terms
minimum duration two days
daily rate based at 7,5 working hours a day
ttäjä: "Adam Hardy" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Lähetetty: Monday, October 06, 2003 1:14 PM
Aihe: Re: can NOT drop the database
> Thanks Heikki.
>
> In the output of innodb_table_monitor I can't actually see the
double quotes " ")
#sqlfrm
to
rsql..._recover_innodb_tmp_table.frm
Then you should be able to access the table
rsql..._recover_innodb_tmp_table
Best regards,
Heikki
- Original Message -
From: "Adam Hardy" <[EMAIL PROTECTED]>
To: "Heikki Tuuri"
Thomas,
- Original Message -
From: "Thomas Gusenleitner" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 9:24 AM
Subject: Re: mysql 4.0.15 and latest redhat enterprise AS Beta - segmention
fault
> Heikki,
&g
Thomas,
the current mysqld-standard does not work with the Red Hat AS beta (Taroon).
We are looking into solving this issue. The problem seems to be connected to
statical linking.
You can try mysqld-max, as it is dynamically linked.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: "Richard Runds" <[EM
M. Dee,
yes, this is a known bug. I already fixed it in spring, but then
inadvertently wiped out the changes :(. Let us try to keep this bug in mind
so that it gets fixed soon.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for
Feng,
- Alkuperäinen viesti -
Lähettäjä: "Wang Feng" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Lähetetty: Wednesday, October 01, 2003 11:26 AM
Aihe: Re: can NOT drop the database
>
> > > BTW, how can I rename
, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL support from http://www.mysql.com/support/index.html
- Alkuperäinen viesti -
Lähettäjä: "Adam Hardy" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECT
Wang,
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 01, 2003 10:30 AM
Subject: Re: can NOT drop the database
> Awesome
>
> I did create
Feng,
do you have some non-MySQL file in that database directory under the datadir
of MySQL?
Naturally, MySQL will not drop the directory if it contains something more
than just MySQL tables.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level
restart the mysqld server.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: <[EM
they already worked in February 2003.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Original Message
of mysqld. We will see if the support
makes it to 4.1.1.
This also means that if you have created tables with 4.1.0, then you must
not change the default charset later, because InnoDB does not remember the
charset in the table yet. Let us hope InnoDB-4.1.1 will.
Best regards,
Heikki Tu
Ed,
I was able to repeat the error in MySQL-4.1.0 on XP, with the default latin1
charset. But 4.0.15a works ok. The bug fixes of 4.0.xx will be in 4.1.1,
which will be out around Nov 15th.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level
Tim,
please post the whole contents of the .err log.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: "tortoise" <[EM
be included in MySQL-4.1.1. I guess 4.1.1 will be
released around November 15th, 2003.
People often start using MySQL in production when it is labeled beta. Either
4.1.1 or 4.1.2 will get that label.
> Thank you!
>
> Eduardo
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.c
Roman,
- Alkuperäinen viesti -
Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Friday, September 26, 2003 12:02 PM
Aihe: Re: innodb: storage requirements
>
Bo,
- Alkuperäinen viesti -
Lähettäjä: "Bo Lorentsen" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Friday, September 26, 2003 9:41 AM
Aihe: Re: REFERENCES question in mySQL 4.1 - Take 2
Rob, Spyros,
you can simply copy .frm, .MYI, .MYD, ibdata files, and ib_logfiles between
Windows and Linux. The binary formats on disk are the same.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot
ed to tune it in any way, and it
takes much less space than in Oracle.
> Any pointer appreciated
> Thanks
> Fareeda
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
-
il then you have to use the 'long' syntax:
> CREATE TABLE `phone` (
> `id` char(5) NOT NULL default '',
> `num` char(10) NOT NULL default '',
> PRIMARY KEY (`id`,`num`),
> FOREIGN KEY (`id`) REFERENCES `person` (`id`)
> ) TYPE=InnoDB
Best re
Roman,
- Original Message -
From: "Roman Neuhauser" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 11:46 PM
Subject: Re: innodb: storage requirements
> # [EMAIL PROTECTED]
Hi!
Resending this, because this did not show up at
http://lists.mysql.com/list.php?list=mysql#b
Heikki
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 23, 2003 10:04 PM
Subject: Re: Innodb &a
. They
should reveal if there is a bug which lowers the log sequence number
sometimes.
I have seen lsn's up to 2 TB. The bug, if it exists, cannot repeat very
often.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoD
Roman,
the row count in SHOW TABLE STATUS is only an estimate based on 8 dives into
the index tree.
You had a typical symptom of a fragmented table: space usage much bigger
than you would expect.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row
Roman,
the table is probably very fragmented. The command
ALTER TABLE pmsystem2.editor_competence_product TYPE=InnoDB;
will defragment it.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup
uched the log or the data files before or after I upgraded
mysqld...
Well, now I recreated the log files and so far that error didn't show up
again. let's pray :)
thank you very much
Heikki Tuuri wrote:
> Harald,
>
>
>> 030923 15:10:14 InnoDB: Error: page 53 log sequence
Harald,
>030923 15:10:14 InnoDB: Error: page 53 log sequence number 6 190415140
>InnoDB: is in the future! Current system log sequence number 1
3864837242.
>InnoDB: Your database may be corrupt.
what do you think is the correct log sequence number? How much do you have
data?
The pag
MessageNext Message »
From: Harald FuchsDate: September 23 2003 11:45am
Subject: Re: innodb
In article <[EMAIL PROTECTED]>,
"Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> Gustavo,
> - Original Message -
> From: ""Gustavo A. Baratto"" <[EMAIL PR
ke less than an hour. You can monitor the lsn with
SHOW INNODB STATUS.
After that run CHECK TABLE on all your tables. Wrong log sequence numbers
can cause corruption.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MyS
ll come out?
my guess is, before Nov 15th, 2003. In July I believed 4.1.1 would arrive in
August, but I forgot the amount of work needed to merge all changes from 4.0
to 4.1.
> Thanks
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for
3:40:22 InnoDB: Error creating file ./test/#sql-15f_3.ibd.
030919 3:40:22 InnoDB: Operating system error number 17 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: Error number 17 means 'File exists'.
ALTER TABLE apparently does not work b
n it will take some 12 hours to lift the log sequence number high enough
again.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.
Irwin,
DROP FOREIGN KEY was implemented after 4.1.0.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com
size
yes
> table_cache
yes
> thread_concurrency
yes
> Thanks in advance,
> Mikhail.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical sup
ailed in a FOREIGN KEY error or a 'Table is full error',
MySQL did not roll back the whole SQL statement as it should.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
red jdbc) =
> that can do it for x number of machines running any jdbc compatible db's =
> (and they don't even need to be the same type...)
that is extremely hard to implement :). Think about deadlocks, serialization
differences, SQL dialects, etc.
Best regards,
Heikki Tu
Irwin,
do you have in my.cnf
default-character-set=...
set to something else than latin1?
Can you make a small test case which demonstrates the problem?
Can you test with MySQL-4.0.15, and if the error happens also there, please
post the output of SHOW INNODB STATUS after that unsuccessful ALT
the Unix file locking! The performance will be extremely bad.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: ""Mike Hillyer
Daevid,
CONSTRAINT `0_359` FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`)
you do not have ON UPDATE CASCADE in your constraint. MySQL versions < 4.0.8
ignored it.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and
Hmm... I may improve the B-tree search algorithm to avoid this. Or relax
lock wait conditions on 'supremums'.
Thank you for the bug report,
Heikki
- Original Message -
From: "Joe Shear" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
possible.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: "Joe Shear&quo
ng
ON UPDATE options are available starting from 4.0.8.
"
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: ""Daevid Vincent
, the log sequence number is only 2.6 GB.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Original Message
r InnoDB type tables.
> Bill
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
--
MySQL General Mailing List
For
ength CHAR column, InnoDB would
crash even in a simple SELECT. CHECK TABLE would report the table as
corrupt, also in the case where the created key was not PRIMARY.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
--
MySQL General Mailing List
For list archives: http://lists.mysql
---+
| 25 | 0 | NULL |NULL |
NULL
| NULL |NULL |NULL | NULL | 1 |
++---+--+-+-----
----
+--+-+-+--++
1 row in set (0.00 sec)
mysql>
Best regards,
Heikki Tuuri
Innobase
Rafa,
is this the server you suspected to have some hardware problem?
Please send me the whole .err log for analysis.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order
ngineer mention that this is now fixed in
a beta release of the driver. Is this so?
> Bill
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support f
ch
Any idea what SQL query might be causing the above warning? Do you use LIKE
'abcd%' ?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical suppo
Sean,
I am at this very moment programming them :). The deadline is Sept 15th,
2003.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL support from http://www.mys
?
> We hope indeed yours help.
> Thank you very much.
>
> Yours truly.
>
> KINH QUOC NGYEN
> TUAN TRAN KIM
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
pessimistic locking methods. In an
optimistic method you cannot avoid transaction rollbacks due to
serialization conflicts. If you use pessimistic locks and design your
transactions carefully, then you can ensure no deadlocks occur, and you will
not get any unexpected rollbacks.
> Please note:
stablished a new connection for each
individual SQL statement. Transactions and several other MySQL features did
not work because of that.
I saw some 4 weeks ago a Borland engineer mention that this is now fixed in
a beta release of the driver. Is it so?
> Bill
Best regards,
Heikk
valuable if you can write a script which repeats the warning.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com
ound drop queue.
030904 10:32:54 InnoDB: Dropped table research/#sql2-4a4-1a8 in
background drop queue.
<>
MySQL database engine is still behaving badly but InnoDB engine is able
to overcome or prevent this.
Has anyone any
drives (3x2).
>
> Any suggestions?
>
> --steve-
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lock in share mode;
> ...
COMMIT and ROLLBACK release all InnoDB locks of a transaction. They do not
release MySQL's manual table level locks, which you set with the statement
LOCK TABLES ... {READ | WRITE}.
> Thanks,
> Chris
Best regards,
Heikki Tuuri
Innobase Oy
http://www.inno
e that InnoDB really maps
fdatasync() -> fsync()
O_DSYNC -> O_SYNC
This is because in 2001 there was some evidence that fdatasync() caused file
corruption both in Linux and Solaris.
> > Mikhail Entaltsev wrote:
> >
> >Paul,
> >
> >if your MySQL server is runnign under Linux th
on lasts long,
say for hours or days, you might run out of space in the tablespace.
> Thanks all!
>
> Regards,
>
> Chris
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for
seems inconsistent.
The idea is that a plain SELECT is a consistent non-locking read which reads
a historical snapshot of the database. But, of course, an UPDATE must not
read a historical snapshot. An UPDATE must get the latest data, and lock the
rows.
If you make a locking SELECT, then you see
Sergey,
I replied to the Linux kernel mailing list 10 min ago :). Below my reply.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https
version < 4.0.14 then in the first startup(s) InnoDB
will print warnings:
InnoDB: Warning: an inconsistent page in the doublewrite buffer
InnoDB: space id 2552202359 page number 8245, 127'th page in dblwr buf.
but that is not dangerous and can be ignored.
"
Best regards,
Heikki T
orm. ibbackup, on the other
hand, takes a binary backup of your database. Even if you use ibbackup, you
should sometimes make logical dumps because you can easier check that data
in a human-readable file is not corrupt.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, t
ey_locking
http://www.innodb.com/ibman.html#Cope_with_deadlocks
> Am I misconfiguring something, or does InnoDB simply only support row
> level locking when you are selecting indexed rows?
>
> Thanks in advance,
>
> Steve McWilliams
> Software Engineer
> Emprisa Networks
, 98.3% idle
> Mem: 5318292K av, 4571076K used, 747216K free, 0K shrd, 261444K
> buff
> Swap: 2096220K av, 123060K used, 1973160K free 3284376K
> cached
>
> Kernel 2.6.0 definitely makes mention of PAE and support for large amounts
> of memory.
Andi Kleen
Andi,
- Original Message -
From: "Andi Kleen" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 1:37 AM
Subject: Re: 64-Bit and INNODB
> "Heikki Tuuri" <[EMAIL PROTECTED]> writes:
> >
Hi!
We have only 2 GB of RAM in our SuSE Linux server, and I can allocate 1400
MB to the buffer pool.
Have you checked what
ulimit -a
says for the user running mysqld?
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
pretty hefty.
We are waiting to see if 64-bit Linux computers take off.
Adding the 32-bit Intel "AWE" support into InnoDB on Linux would be rather
easy if someone wants to sponsor the project. I recall "AWE" itself can be
used with the Red Hat Linux Advanced Server, if I r
y.cnf, and start
MySQL again. InnoDB will tell you at the startup that it is creating new log
files.
"
Note above that you must make sure mysqld shuts down without errors. Only
then you can change the size of the log files.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Fo
ent. If the
computer really badly 'freezes' for 600 seconds, then a file read might take
that long.
I do not see how queries waiting for table locks on the MERGE table could
cause context switches inside mysqld. They should just sit and wait.
Best regards,
Heikki Tuuri
Inn
Hi!
Many people have complained over years that Borland's dbExpress driver does
not work with MySQL and transactions, because it disconnects from mysqld
after each SQL statement. The postings below suggests that this problem
might now be fixed by Borland.
Best regards,
Heikki Tuuri
Innoba
Hans,
the problem is partially fixed in 4.1.1. You get a warning from inserting a
nonsensical date. But it still accepts '1996-02-31' without a warning,
though there are max 29 days in February. I have now notified the developers
about this bug.
Best regards,
Heikki Tuuri
Innoba
Asif,
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, August 24, 2003 8:47 AM
Subject: Re: innodb doc in mysql.com
> On Sun, 24 Aug 2003, Heikki Tuuri wrote:
>
> > Asif,
> >
> >
.
Just in case something goes wrong with the steps 1 - 5 above. And, of
course, you should regularly take backups of your valuable database anyway.
> Please help/suggest
> --
> Asif Iqbal
> http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
> There's no pl
bal
> http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
> There's no place like 127.0.0.1
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
BLE (in MySQL versions
> 4.0.13, I think) on all InnoDB tables. That can help in optimization of
some joins if your tables have changed a lot during the lifetime of the
mysqld process.
> jeff
Regards,
Heikki
> Heikki Tuuri wrote:
> >
> > Per,
> >
> > I think a '
separate transaction that read this data is committed?
>
> 5. sometime, no guarantee? This would seem to violate transactional
> integrity of the new transaction if it had a foreign key reference.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, a
Per,
I think a 'null' alter table operation:
ALTER TABLE innodbtable TYPE=INNODB;
does the defragmentation with just one build of the table. And I think it
also preserves FOREIGN KEY constraints.
Please test it!
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, fo
u can also open a volume by referring to its volume name. For more
information, see Naming a Volume.
"
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
warning is about.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
...
if (key_ptr > key_
use ordering it manually isn't an option at
> this moment with so periodically transfers and so many tables :(
please upgrade to a recent version of MySQL and add
SET FOREIGN_KEY_CHECKS=0;
to the start of your dump file(s).
> Eddie
Best regards,
Heikki Tuuri
Innobase Oy
http://www
ing stack trace!
> Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
> follow instructions on how to resolve the stack trace.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support fro
h_plan_for_table + 742
> 0x816c2be opt_search_plan_for_table + 1594
> 0x815e77f row_upd_clust_step + 431
> 0x8178c60 btr_compress + 3852
> 0x810f8e8 srv_master_thread + 172
> 0x8112a15 innobase_start_or_create_for_mysql + 1297
> 0x810db3d srv_sprintf_innodb_monitor + 425
> 0x810d6cc
rder MySQL support from http://www.mysql.com/support/index.html
- Alkuperäinen viesti -
Lähettäjä: "Richard Gabriel" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Monday, August 11, 2003 6:2
t
before the import. Creating indexes afterwards is slow, because MySQL
recreates the whole table for each index you add.
Greetings to Marko and Pekka in New Mexico!
> jeff
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MyS
ting from
cascaded updates. A self-referential ON DELETE SET NULL, on the other hand,
works starting from 4.0.13. A self-referential ON DELETE CASCADE has always
worked.
"
InnoDB does not check what rows it has already updated during the SQL
statement. To prevent infinite recursions I let it simp
e newsgroup mailing.database.mysql. That is
only a mirror of the mailing list [EMAIL PROTECTED], where you should
send your postings.
> Thanks,
> Susan
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL
racle. But, contrary to Oracle, you do not need to configure it in any way.
InnoDB uses the rollback segment both to implement transaction rollback and
read consistency.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
501 - 600 of 1646 matches
Mail list logo
