Bruce,
it is the bug "innodb_file_per_table corrupts secondary indexes".
I fixed it with several changesets on Sunday:
http://lists.mysql.com/internals
Thus, it is fixed in the current 4.1 bk tree.
This is indeed the worst InnoDB corruption bug since the BLOB update bug of
summer 2001. Fortunately
Frank,
CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB;
causes the output to be written to the .err file untruncated. DROP the table
to stop the printouts.
There is a limit in the mysql client that restricts the output length to 64
kB.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys
backup may be severely corrupt.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https
,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: "
Hi!
http://bugs.mysql.com/bug.php?id=7496
A critical bug found: if one uses the 4.1 my.cnf option
innodb_file_per_table
to create tables, and some of the secondary index records are inserted to
the InnoDB 'insert buffer', then after a normal mysqld shutdown InnoDB loses
all those secondary index
EIGN_KEY_CHECKS=0;
automatically to the dump file.
Grateful for and ideas ...
Thanks
Best regards and Season's Greetings,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
h
Daniel,
- Original Message -
From: "Daniel Andersen" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, December 21, 2004 1:04 AM
Subject: Re: Weird load issues
On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote:
Daniel,
it is simply processing bi
ple if had just done a SELECT FOR UPDATE),
then executed a non-transactional update, that update automatically
committed the transaction (thus releasing InnoDB's row-level locks etc).
(Bug #5714)
Best regards,
Heikki Tuuri
http://www.innodb.com
--
MySQL General Mailing List
For list
Daniel,
it is simply processing big SELECT queries. Maybe their optimization changed
lately? You should tune your queries.
You should also tune InnoDB, because you are running with the default 8 MB
buffer pool size, and it is reading in 6000 pages per second!
Best regards,
Heikki Tuuri
) waiting for 4.0.23 to be released;
or
C) upgrading to innobackup-1.1 and MySQL-4.0.22.
If the problem is that the internal data dictionary in the slave is
out-of-sync of the .frm files in the slave, you can fix it by the advice at:
http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.ht
be causing it?
please post the complete outputs of
SHOW PROCESSLIST;
and
SHOW INNODB STATUS
during such CPU peak.
Daniel
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISA
ies, Inc.
[EMAIL PROTECTED]
206.902.2027
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
--
MySQL General Mailing List
For lis
rade to 4.1 directly, because 4.1 uses UTF-8 to store metadata names. Use
RENAME TABLE to overcome this if the accent character is in the table name
or the database name, or rebuild the table.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
--
MySQL General Mailing List
For
NNODB STATUS, the "list of transactions for each
sessions" part shows queries that are only related to MyISAM tables.
Is it the expected behavior?
yes, it prints
thd->query_str
which is the latest query on the connection.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions,
l in the 'gap'.
Note that the 'next-key' locking information in InnoDB is carried by
existing records in the index. You cannot lock just some subinterval of a
'gap'.
Regards,
Heikki
- Alkuperäinen viesti -
Lähettäjä: "Emmett Bishop" <[EMAI
NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;
Josh
Best regards,
Heikki Tuuri
Innobase Oy
For
hat removes almost all gap locking.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: "Emmet
date NOT NULL default '-00-00',
`sort_id` int(11) NOT NULL default '0',
`log_type` int(11) NOT NULL default '0',
KEY `idx_session_guid` (`session_guid`),
KEY `idx_session_label` (`session_guid`,`label`),
CONSTRAINT `s_contact_log_ibfk_1` FOREIGN KEY
(`session_guid`)
id;
After the failing create, run
SHOW INNODB STATUS;
and post the output.
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
master is: 4.0.17
slave: 4.1.7
Trying to insert the dump on another 4.0.17 fails too.
Any hints out there?
Regards
Jochen
Best regards,
Heikki Tuuri
Innob
DB.
Or recreate everything from scratch.
bye, Paul.
--
Paul Mallach
ARIVA.DE AG
Ostseekai 2
D - 24103 Kiel
Tel: +49 (0)431/97108-24 E-Mail: [EMAIL PROTECTED]
Fax: +49 (0)431/97108-29 Internet: http://www.ariva.de
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, tran
rong? Please?
Yes, I know we should upgrade to 4.1.7, and we will - soon.
try tuning InnoDB. Your workload may be seriously disk-bound.
Cheers
Terry Riley
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for
PROTECTED]
Fax: +49 (0)431/97108-29 Internet: http://www.ariva.de
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
--
Alejandro,
please search the bugs.mysql.com database about known --tmpdir bugs.
If TMPDIR works, it is a fine workaround.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
OREIGN KEY error.
Since you are running 4.0.22, MySQL does not automatically create indexes on
FOREIGN KEYs, and your command sequence is indeed expected to fail.
Steve
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot
K, 0 rows affected (0.12 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table person_address
-> add constraint address_person_address_FK1
-> foreign key (address_id) references address (address_id);
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0
mys
RY and VARBINARY are MySQL data types now.
http://dev.mysql.com/doc/mysql/en/BINARY_VARBINARY.html
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.
14:04:56 [Note] /usr/sbin/mysqld: Shutdown complete
041203 14:04:56 mysqld ended
The only way to do work innodb is chmod 777 /root and /root/tmp, =(
Alejandro
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool f
ndex on last_name, an index on first_name, and a combo
index of (last_name, first_name). We cut the run time from 1min 57sec to
3seconds.
I do not know if ROR works for that query. You have to test.
walt
Best regards,
Heikki
Heikki Tuuri wrote:
Hi!
InnoDB is the MySQL table type that supports FO
Hristo,
if you are doing INSERTs, UPDATEs, or DELETEs, try setting
innodb_flush_log_at_trx_commit=2
But read the caveats in the manual. You can also set innodb_buffer_pool_size
bigger.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot
BLE to overcome this if the accent character is in the table
name or the database name, or rebuild the table.
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://lists.mysql.com/[EMAIL PROTECTED]
map at http://www.innodb.com/todo.php
If someone sponsors the implementation, it could be available by the end of
2005. Otherwise, I am afraid it will take to 2006 or 2007.
indexable data in that inthe past, but one of fields has a one to many
relationship in the table of
Best regards,
Heikki Tuuri
Joakim,
please post the FULL .err log, the full output of SHOW PROCESSLIST and SHOW
INNODB STATUS, as well as your my.cnf.
Please also post the output of the Unix 'top'.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Back
Here is the reference table
CREATE TABLE `t_client` (
`client_id` int(11) NOT NULL default '0',
`client_desc` varchar(255) NOT NULL default '',
PRIMARY KEY (`client_id`)
) TYPE=InnoDB;
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locki
me people had to abandon it
because of too many problems. Linux developers are working to fix the bugs.
Thanks
Lynn Bender
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyI
ght
consider placing on SSD?
Placing logs on a solid state disk sounds a good idea. If the Linux (?)
kernel is advanced enough, fsync() may run much faster when we flush the log
files to the disk.
Any input is appreciated. Thanks,
Richard
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transa
re? Can it create
problems in future?
you can mix InnoDB and MyISAM with no problems. Just remember that MyISAM
does not support FOREIGN KEY constraints.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for
able type switch
--- Heikki Tuuri <[EMAIL PROTECTED]> wrote:
Stuart,
you probably have
skip-innodb
in my.cnf.
Best regards,
Heikki Tuuri
Heikki - Nope , doesn't seem so. My.cnf is below.
Also, I'm guessing that if it was set to skip-innodb,
I wouldn't not have had the ability to chang
Stuart,
you probably have
skip-innodb
in my.cnf.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message
e structure from the output. Then you can create
the .frm files manually.
See
http://www.innodb.com/ibmanold.php#InnoDB.Monitor
about how to start and stop InnoDB monitors.
Thank you very much for helping me. Saved my life! lol
[=B4z]
Carlos
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, tran
MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Alkuperäinen viesti -
Lähettäjä: "Carlos Augusto" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[
Filippo,
you used a FOREIGN KEY syntax that MySQL/InnoDB does not support.
Look at the correct syntax here:
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a
7M
innodb_flush_log_at_trx_commit=3D1
innodb_log_buffer_size=3D4M
innodb_buffer_pool_size=3D305M
innodb_log_file_size=3D61M
innodb_thread_concurrency=3D10
---end my.ini---
On Thu, 25 Nov 2004 20:15:43 +0200, Heikki Tuuri
<[EMAIL PROTECTED]> wrote:
Carlos,
=20
when filing bug reports for any soft
Carlos,
when filing bug reports for any software, not just MySQL, you should provide
the full information. You should not try to pick the relevant material
yourself.
What do you have in your my.cnf file? What does the '/data' directory
contain?
The errors below look like you would have at leas
ste the full error log for you.
Thanks for the help.
[=B4z]
=20
On Mon, 22 Nov 2004 23:09:41 +0200, Heikki Tuuri
=20
=20
<[EMAIL PROTECTED]> wrote:
> Carlos,
>
> - Original Message -
> From: "Carlos Augusto" <[EMAIL PROTECTED]>
> Newsgroups: mailing
ree)
mysqlhotcopy is free, but it works only for MyISAM.
See:
http://dev.mysql.com/doc/mysql/en/Backing_up.html
and=20
mysqldump.. This is assuming your not coping the entire db directory
tree..
Maybe someone else knows of another.
Jeff
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions
Hi!
The size limit in InnoDB is 64 TB.
You have probably mixed up ibdata files or ib_logfiles. The ib_logfiles that
you are using are probably completely zero-filled. No checkpoint info in
them.
What does
mysqld-nt --console
print if you move the ib_logfiles away?
When creating new ibdata files,
ES will become deprecated for
pure InnoDB transactions.
We will update the MySQL manual to include the above text. LOCK TABLES has
caused a lot of confusion lately.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a h
you try to start it?
Which MySQL version this is, and what operating system?
The following section:
http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
contains instructions how you can start mysqld, even though the ibdata file
is corrupt.
Thanks
Carlos
Best regards,
Heikki Tuuri
Innobase
Then we do not need locks on the SELECT table ever,
because execution does not need to be serializable.
All innodb tables, MySQL 4.1.7 for both master and slaves.
Thanks.
Mike
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a ho
ql.com
We will see how common the history list corruption is. My tests did not
produce any corruption.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://w
(a VARCHAR(100) NOT NULL PRIMARY KEY, b INT) TYPE =
INNODB;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> CREATE TABLE t1(a1 INT NOT NULL PRIMARY KEY, b1 VARCHAR(50), FOREIGN
KEY
(b1) REFERENCES t(a)) TYPE=INNODB;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql>
regards
daya
Chuck,
demand for spatial features for InnoDB has been extremely low. They will
probably never be implemented unless someone sponsors them. FULLTEXT is much
more asked for.
Why not use the spatial extension of MyISAM, or some dedicated GIS database?
Best regards,
Heikki Tuuri
Innobase Oy
ase address these general MySQL questions to [EMAIL PROTECTED]
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MyS
regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
- Original Message
Hristo,
thank you for the bug report. I broke the
:autoextend:max:2000M
feature when I added multiple tablespaces in 4.1.1.
The bug is fixed in 4.1.8.
Unfortunately, InnoDB does not automatically add 2000 MB files if you
specify the max. You have to add additional ibdata files manually, as
explai
ash? Is that true? Which 4.1.x version you are running?
Yes, initially I had thought that there was an issue with the
installation itself, so I upgraded to v4.1.7-0.
Please send the FULL .err log to me [EMAIL PROTECTED] for
more detailed analysis. Do not cut anything off.
Your lsn is only 300 MB. Hig
Hi!
In the thread "Re: mysqld-nt error 23. Urgent pls" you stated that the file
system is corrupt. Thus, the error 995 might result from that.
There are two or three 995 reports from this year. I have suspected a bug in
some disk driver in Windows, but maybe they are caused by file system
corru
ff.
Unfortunately the mailing list stripped your domain off. Please send an
email to spam at cjs226.com and I'll send you the err log.
Your lsn is only 300 MB. High-end users of InnoDB on a stable Linux
computer can easily reach 300 GB without any corruption.
Best regards,
Heikki Tuuri
Innobas
of a directory.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
- O
Naveen,
the size of the mysqld process is only 1.7 GB, and you have plenty of free
memory. Swap usage is zero.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
indows bug.
Try copy:ing ibdata1 to another file. Does it succeed?
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL
ng off.
Your lsn is only 300 MB. High-end users of InnoDB on a stable Linux computer
can easily reach 300 GB without any corruption.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also back
h-end server, and 600 - 4000 physical disk drives.
The following link describes a system with 512 GB of memory, and 2000 disk
drives:
http://www.tpc.org/results/individual_results/IBM/IBM_690_040217_es.pdf
The system costs 5.6 million US dollars.
Best regards,
Jacek Becla
Stanford University
Best
ppercase letters in their name. For that, we need a MySQL
function that looks from the .frm file name and directory what is the
'canonical' case of the letters in the database name and the table name.
Best Regards,
Boyd E. Hemphill
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, trans
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 11, 2004 8:17 PM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
Heikki,
Heikki Tuuri wrote:
hmm... could it be that segments 0 1, 0 2, 0 3, etc. were printed close
to the end of the output? The print routi
Sasha,
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 11, 2004 8:05 PM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
Heikki Tuuri wrote:
Ivan,
hmm... could it be that s
are there.
Anyway, if we get the ibdata files, it should be relatively easy to find out
what is wrong.
Regards,
Heikki
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 11, 2004 2:17 PM
Subject: Re:
em
with ftp to
support.mysql.com/pub/mysql/secret
My guess is that if you rebuild the tablespace, the leak problem will go
away.
Regards,
Heikki
- Original Message -
From: ""Heikki Tuuri"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 1
oad.
Please use also innodb_table_monitor, and send the output to me.
Thanks for the advice.
Good luck,
Ivan
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://w
ages 1; free extents 0; not full extents 0: pages 0
NUMBER of file segments: 35
Validating tablespace
Validation ok
---
END OF INNODB TABLESPACE MONITOR OUTPUT
===
Regards,
Heikki
- Original Message -
From: "&q
Message -
From: ""John B. Ivski"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 10, 2004 4:25 AM
Subject: Re: InnoDB data files keep growing with innodb_file_per_table
Heikki,
Heikki Tuuri wrote:
> John,
>
> please pos
John,
please post what SHOW INNODB STATUS says. The probable reason is that there
are long transactions, or that purge is falling behind.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also
fault, or the OS
version in that computer is buggy.
You can try running memtestx86 or memburn:
http://v.iki.fi/~vherva/memburn.c
You can also try upgrading the kernel.
Thanks,
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot
e.
"
Also the behavior of LOCK TABLES with InnoDB has changed since 4.0.14. See
http://dev.mysql.com/doc/mysql/en/News-4.1.7.html.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
ese errors?
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
filesort.cc
sertion failure in row_build_row_ref().
(Bug #5180)
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://lists.mysql.com/[EMAIL PROTECTED]
ume that you are using two DIFFERENT connections for the threads? That
is the correct way.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.
s. Use
RENAME TABLE to overcome this if the accent character is in the table name
or the database name, or rebuild the table.
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://lists.mysql.com/[EMAIL PROTECTED]
1019 13:05:25 Can't init databases
041019 13:05:25 Aborting
TIA,
Paul W
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Or
be that InnoDB is not able to create its
ibdata and ib_logfiles. Look what mysqld prints when it starts.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http
Gary,
- Alkuperäinen viesti -
Lähettäjä: "Gary Richardson" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Thursday, October 21, 2004 4:49 AM
Aihe: Re: Char to Varchar on Innodb
> I
quez, Ste 6 http://www.predict.com
Santa Fe, NM 87505
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https:/
Martijn,
- Alkuperäinen viesti -
Lähettäjä: "Martijn Tonies" <[EMAIL PROTECTED]>
Vastaanottaja: <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Wednesday, October 20, 2004 11:34 AM
Aihe: Re: Innodb foreign keys names
> Hello Heikki,
>
...
> Thank you for your reply.
>
> One qu
David,
- Alkuperäinen viesti -
Lähettäjä: "David Griffiths" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Tuesday, October 19, 2004 9:33 PM
Aihe: Re: MySQL Database Corruption (InnoDB),
to reduce
fragmentation if there are lots of updates to that column. A CHAR column
takes a fixed space. Silent column specification changes in many cases
defeat this optimization which would otherwise be available to users.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and
on. (Bug #2167)
"
I agree that in the future, we have to try to make less changes to stable
versions of MySQL, and put new features only in new major versions.
The good thing: this is an addition, unlike renaming a column returned
from SHOW TABLES :-/
Thanks for pointing this out.
With rega
Elim,
- Alkuperäinen viesti -
Lähettäjä: "Elim Qiu" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Lähetetty: Tuesday, October 19, 2004 8:07 PM
Aihe: Re: Chinese
> > you can use MySQL-4.1.6 and t
Ian,
FILE I/O
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio w
Hi!
Guilhem has now fixed this bug to 4.0.22.
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL support from http://
David,
I am sorry for a late reply.
The corruption clearly is in the ibdata file of the production database.
InnoDB Hot Backup checks the page checksums when it copies the ibdata files.
Since CHECK TABLE fails, the corruption probably is in that table. You can
try to repair the corruption by dum
Boyd,
sorry, only the output of innodb_monitor can be accessed through an SQL
statement. The other monitors contain information mostly for special error
situations.
But it is in the TODO to implement
SHOW LOCKS ...
That would be useful for application developers.
Best regards,
Heikki
Innobase
Adolfo,
the following patch in the 4.0 tree may fix the misleading error message:
D 1.222 04/10/12 18:11:50+03:00 [EMAIL PROTECTED] 357 356 1/1/5101
P sql/ha_innodb.cc
C Change error code to HA_ERR_ROW_IS_REFERENCED if we cannot DROP a parent
table
Martijn,
List: mysql
Subject:Re: Innodb foreign keys names
From: "Martijn Tonies"
Date: 2004-10-19 9:53:28
Message-ID: <01ad01c4b5c1$7c1e69a0$0a02a8c0 () martijn>
[Download message RAW]
>Heikki,
>
>> you have to use a fairly recent 4.0 or 4.1 version of MySQL.
>
>Does a new
David,
next-key locks are purely inhibitive. Even though transaction (2) has an
X-lock on the 'supremum' of the index, it cannot insert because also
transaction (1) has an X-lock on the 'supremum'.
Why is it allowed that two transactions can both have an X-lock on a 'gap'
in the index (the suprem
the tablespace bounds.
Look, it says that page number 142 000 is outside the tablespace data files,
though above you had over 5 million pages in data files! You have probably
forgotten some data files when you restarted mysqld.
Thanks,
baba
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, tr
Richard,
you have to use a fairly recent 4.0 or 4.1 version of MySQL.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL
ou can use MySQL-4.1.6 and the UTF-8 character set for both Chinese and
European languages.
Thanks.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.inno
use 4.1.6 with the my.cnf option
innodb_file_per_table
then each table goes into its own .ibd file, and you can free unused space
in individual tables with
OPTIMIZE TABLE t;
Beware that the table rebuild that OPTIMIZE does can last very long if the
table is bigger than your buffer pool.
Massimo
ir of MySQL. Actually, I do not know why
MySQL does not fetch the creation date from there. We will look at this.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backu
system to choose..
ext3? ReiserFS? XFS?
What's your experience?
my impression is that all three have the same performance and reliability.
Opteron + Linux as a platform, on the other hand, still seems to have quite
a few unexplained hardware faults or OS bugs.
Thanks
chris
Best regards,
Hei
201 - 300 of 1646 matches
Mail list logo
