Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)

Deva, please post the complete output except the transaction data. Regards, Heikki - Original Message - From: Devananda [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, October 05, 2005 7:05 PM Subject: Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait

Re: daemon crash when shutting down large databases

David, man pthread_mutex_destroy says: ... pthread_mutex_destroy destroys a mutex object, freeing the resources it might hold. The mutex must be unlocked on entrance. In the LinuxThreads implementation, no resources areassociated with mutex objects,

Re: mysql bug 9670 OPTIMIZE TABLE crashes

Matthis, unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and later. Regards, Heikki - Alkuperäinen viesti - Lähettäjä: Matthijs van der Klip [EMAIL PROTECTED] Vastaanottaja: MySQL mailing list mysql@lists.mysql.com Kopio: [EMAIL PROTECTED]; [EMAIL PROTECTED]

MySQL/InnoDB-5.0.7 has been released

different values for the ENUM. * InnoDB Hot Backup 2.0.1 or earlier does not work with MySQL-5.0.3 or later. A new version 2.1 will. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

MySQL/InnoDB-5.0.6 has been released

of the ENUM is not latin1 or if there are more than about 100 different values for the ENUM. * InnoDB Hot Backup 2.0.1 or earlier does not work with MySQL-5.0.3 or later. A new version 2.1 will. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com -- MySQL General Mailing List For list

Re: Disappearing .frm files ?

symlinking? There might be a bug there. 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 Network from http://www.mysql.com

Re: Synchronizing InnoDB tables

/index.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.com/order.php Order MySQL Network from http://www.mysql.com/network/ -- MySQL General

Re: memory error innodb backup

process and not be uncovered until it was accessed on the new system? thanks, baba -- Baba Buehler - NetBotz, Inc. - [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

Re: Resetting lsn/trx for an .ibd file

data page. Not very difficult. But fast index build in 5.1 will come to your rescue earlier. -- Sam Sgro [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

Re: modifying InnoDB storage

Jigal, - Alkuperinen viesti - Lhettj: Jigal van Hemert [EMAIL PROTECTED] Vastaanottaja: mysql@lists.mysql.com Kopio: Gleb Paharenko [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED] Lhetetty: Tuesday, April 26, 2005 2:09 PM Aihe: Fw: modifying InnoDB storage Unfortunately no response

Re: crushed innodb table

, but without a solution please look in the .err log to see what is the problem. http://dev.mysql.com/doc/mysql/en/forcing-recovery.html Thanks in advance, iv iv at fnet dot pl Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup

Re: InnoDB Writes blocking Reads

like? How big is your table cache? 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 Network from http://www.mysql.com

Re: Why is this table lock?

in the table. I guess we will need to add a note about this to the manual, or even better, to the SHOW INNODB STATUS output. Intention locks are a standard implementation technique which is described in database literature, but they sometimes confuse users. Best regards, Heikki Tuuri Innobase Oy

Re: Using InnoDB on 2 OSes

/pl/m/intro/index.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.com/order.php Order MySQL Network from http://www.mysql.com/network

MySQL/InnoDB-5.0.4 is released

with MySQL-5.0.3 or later. A new version 2.1 will. 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]

Re: InnoDB Performance

tables will take about 60 % less disk space than normal tables. The downside is some more CPU usage in queries and inserts. Appears in 5.1. 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

Re: innodb, log_bin and ib_logfiles

a dump. =20 I would appreciate very much if someone can clarify this for me. =20 =20 Johanne Duhaime 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

Re: Out of memory, but plenty of swap space left

John, are you running on a 32-bit computer? Then, normally, the process size is limited to 2 GB. 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

MySQL/InnoDB-4.1.11 is released

altogether and just print an error to the .err log if this important consistency check fails. (Bug #8677) 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

Re: Innodb: Alter table progress

James, - Original Message - From: James Green [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, April 05, 2005 11:06 AM Subject: Re: Innodb: Alter table progress Heikki, See inline. Heikki Tuuri wrote: James, - Original Message - From: James Green [EMAIL

Re: Innodb: Alter table progress

, -- James Green Systems Administrator, StealthNET Ltd, www.stealthnet.co.uk Tel: 0870 800 1777 Intl: +44 1493 660066 Fax: 0870 135 1069 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

MySQL/InnoDB-5.0.3 has been released

and 4.1. * InnoDB Hot Backup 2.0.1 or earlier does not work with MySQL-5.0.3. A new version 2.1 will. 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

Re: Problem: Slow LOAD FILE performance with innodb

Andreas, - Original Message - From: Andreas Ahlenstorf [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, March 18, 2005 11:47 AM Subject: Re: Problem: Slow LOAD FILE performance with innodb Heikki Tuuri schrieb: Creating the indexes after the import will only slow down

Re: Problem: Slow LOAD FILE performance with innodb

have been doing. If you want to import 132 million rows, and the speed is 2000 rows / second, then the import takes 64 000 seconds = 18 hours. Why not wait over the night? Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot

Re: compilation problems with 4.1.10a on Tru64 5.1

/mysql-4.1.10a' gmake: *** [all] Error 2 The file, MYSQLDIR/sql/lex_hash.h is zero bytes. Any idea where I should go from here? Thanks! try deleting that zero-byte lex_hash.h. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot

MySQL/InnoDB-4.0.24 is released

for a lock to check a FOREIGN KEY constraint, then an assertion would fail in lock_reset_all_on_table(), since that operation assumes no waiting locks on the table or its records. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com -- MySQL General Mailing List For list archives: http

Re: Lock timeout problem

that was running in that transaction? I Think it may not be inside the binary log as we had to stop the server and start it again . Question #2. What does the 225 lock struct(s) mean It means appromately that the transaction has locks on 225 pages or 225 tables. Thanks Mauricio Best regards, Heikki Tuuri

Re: mysql crash - innodb not starting

is better? I would prefer to repair the existing installation, but have no idea where to begin Thanks a lot for your time. From: Heikki Tuuri [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: mysql crash - innodb not starting Date: Thu, 3 Mar 2005 23:20:56 +0200 Hi! Error 11 means that you

Re: Correct way to use innodb_file_per_table?

Mike, - Alkuperäinen viesti - Lähettäjä: Mike Debnam [EMAIL PROTECTED] Vastaanottaja: mysql@lists.mysql.com Kopio: [EMAIL PROTECTED] Lähetetty: Friday, March 04, 2005 2:49 PM Aihe: Re: Correct way to use innodb_file_per_table? Heikki, the best way would be to symlink whole database

Re: mysql crash - innodb not starting

backs up MyISAM tables http://www.innodb.com/order.php Order MySQL Network from http://www.mysql.com/network/ From: Heikki Tuuri [EMAIL PROTECTED] To: mel list_php [EMAIL PROTECTED], mysql@lists.mysql.com Subject: Re: mysql crash - innodb not starting Date: Fri, 4 Mar 2005 15:50:26 +0200 Mel, do ps

Re: Questions regarding INNODB

companies restrict MyISAM database sizes by setting limits on individual database directory sizes. With the my.cnf option in MySQL-4.1: innodb_file_per_table they can now do the same for InnoDB type tables. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking

Re: mysql crash - innodb not starting

Hi! Error 11 means that you already have a mysqld process running on the same files. 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

Re: mysql 4.0.18 crashing on startup

Baba, an undo log seems to be corrupt. He should restart mysqld with: innodb_force_recovery=4 dump all tables, and recreate the whole InnoDB installation. Did the .err log contain any hint what could be behind the corruption? Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions

Re: Correct way to use innodb_file_per_table?

different MySQL instances. System is FreeBSD 5.3, MySQL 4.10, current ibdata file is about 25 gb. Thanks for any pointers. Mike 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

Innobase Oy declares MySQL/InnoDB-4.1 stable

/InnoDB-4.1 was the bug http://bugs.mysql.com/bug.php?id=7496 in the my.cnf option innodb_file_per_table. Best regards, Heikki Tuuri Innobase Oy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Switching to InnoDB turns out dissapointing

hours to complete. The top command says mysqld is using about 8% of CPU, so it must be a disk= problem. Funny thing is, it did not show when the tables were MyISAM. Thank you and regards. Alfredo J. Cole Grupo ACyC www.acyc.com - www.clshonduras.com - SolCom - www.acycdomains.com Best regards, Heikki

Re: innodb.status.#### files

Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F 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

Re: Switching to InnoDB turns out dissapointing

. Is there a performance penalty associated with making the log buffer size too large, or is just not beneficial? it is not beneficial beyond 8 MB. In this case, the big log buffer is eating valuable RAM from the buffer pool where the memory would be more useful. -JF Best regards, Heikki Tuuri Innobase Oy Foreign

Re: Mysql tuning - server Crash 1

. They wanted me to send you some of the benchmarks comparing Fedora, Suse, and some of the other distros using mysql. But the site they sent me which shows fedora beating all of them is currently down. Oh well. Donny Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking

Re: Mysql tuning - server Crash 1

. An upgrade to a more recent Fedora Core might also help. 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

Re: Mysql tuning - server Crash 1

Have you seen my variables. I had 8M? Can this be the bottle neck? yes it may be. Please see: http://dev.mysql.com/doc/mysql/en/innodb-configuration.html --Heikki On Mon, 28 Feb 2005 11:34:31 +0200, Heikki Tuuri [EMAIL PROTECTED] wrote: Max, maybe the 640 connection piled up because mysqld was hung

Re: InnoDB Rollback - 162 hrs remaining!?

John, Marko will add a commit at every 10 000 rows to CREATE INDEX in 4.1.11. Then this kind of a runaway rollback can not happen any more. 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

Re: Mysql tuning - server Crash 1

stable. Thank you. I appreciate your help!! Max 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 list

Re: InnoDB Rollback - 162 hrs remaining!?

, 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 list archives: http://lists.mysql.com/mysql To unsubscribe

Re: InnoDB Rollback - 162 hrs remaining!?

InnoDB with killall -9 mysqld It never gets corrupt. Unfortunately the server.err file is not giving me any output, nor .log and I don't have a .status file either. Thanks, John. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup

Re: Mysql tuning - server Crash 1

Max, please post all the relevant contents of the .err log. What MySQL version is this? What Linux version? 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

Re: Innodb - raw partition vs filesystem store?

good discussion can come from this? Greg -- [EMAIL PROTECTED] Meetup.com 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

Re: set auto_increment does not work?

Hi! For InnoDB, CREATE TABLE ... AUTO_INCREMENT=... works starting from 5.0.3. Until then, you have to use the 'insert + delete a dummy row' method to init the counter. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot

Re: Lost InnoDB Data

Henrik, the most probable reason is that someone has edited my.cnf meanwhile, and you are now reading ibdata files from somewhere else. 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

Re: Merging / Moving InnoDB Databases

installations. But presently, you must dump the tables and import them to the other installation. 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

Re: wikipedia down, slashdot covering, mysql mentioned

, 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 Network from http://www.mysql.com/network/ - Original Message - From: Peter

Re: wikipedia down, slashdot covering, mysql mentioned

. Is it still problematic in 2.6 series? Greg -- [EMAIL PROTECTED] Meetup.com Heikki Tuuri wrote: Peter, a buggy fsync() in Linux is one of the possible reasons here. If an InnoDB tablespace gets corrupt in a power outage, it is most probably caused by a bad fsync() implementation or configuration

Re: wikipedia down, slashdot covering, mysql mentioned

Hi! If I understood correctly, Wikipedia did have an UPS at their data center. But the problem cut also that off. Regards, Heikki - Original Message - From: Daniel Kasak [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, February 23, 2005 12:56 AM Subject: Re:

Re: wikipedia down, slashdot covering, mysql mentioned

Jochem, - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, February 23, 2005 1:01 AM Subject: Re: wikipedia down, slashdot covering, mysql mentioned On Wed, 23 Feb 2005 00:22:55 +0200, Heikki Tuuri wrote: a buggy fsync

Re: Problems with LOAD DATA INFILE

John, please print a detailed description of the latest foreign key error with SHOW INNODB STATUS and post it here. 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

Re: InnoDB Files

bugs. My InnoDB free space is ~800Mb. Thanks in advance. -- Ivan Cachicatari http://www.latindevelopers.com 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

Re: Can't get table lock (4.0.23 and InnoDB)

Nick, http://dev.mysql.com/doc/mysql/en/innodb-monitor.html you can use innodb_lock_monitor to find out who is locking the row. 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

Re: InnoDB: Problem with innobackup

James, page number 22357 is corrupt. InnoDB Hot Backup notices these checksum errors, and refuses to do the backup. Sometimes it happens that an unused (i.e., freed) page in an ibdata file becomes corrupt. Then it would be nice to have some tool to reset the checksums on that page, so that

Re: Server fails to start up after upgrade to 4.1.10

Schnee, you have probably mixed ibdata files. It is trying to apply a log record to a page that is full of zeros. And, in an upgrade you should shut down mysqld gracefully. It is not a good sign if InnoDB has to do a crash recovery after an upgrade. Regards, Heikki . Hi, I just

Re: Server fails to start up after upgrade to 4.1.10

Schnee, - Alkuperäinen viesti - Lähettäjä: Schneelocke [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: mysql@lists.mysql.com Lähetetty: Wednesday, February 16, 2005 5:07 PM Aihe: Re: Server fails to start up after upgrade to 4.1.10 Hi Heikki, you have probably

Re: innodb error 995

13th ST Dept. of Computer Science and Eng. phone: (402) 472-2340 University of Nebraska-Lincoln fax: (402) 472-3135 Lincoln NE 68588-0115 email: [EMAIL PROTECTED] http://nadss.unl.edu Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level

MySQL/InnoDB-4.1.10 is released

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]

Re: MySQL/InnoDB-4.1.10 is released

application logic? - Asad On Tue, 15 Feb 2005, Heikki Tuuri wrote: Hi! InnoDB is the MySQL table type that supports foreign keys, transactions, non-escalating row-level locking, all SQL-92 transaction isolation levels, multiversion concurrency control, savepoints, multiple tablespaces, and a non-free online

Re: slow query, how can i imporve it?

://www.innodb.com/todo.php Note that most transactional databases do not keep a row count. There are performance reasons and technical problems in it. -- Chris Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool

Re: InnoDB crash and runaway rollback - help pls

the rows is much slower. Your buffer pool is extremely small, only 8 MB. Below you are confusing it to the log buffer. 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

Re: InnoDB crash and runaway rollback - help pls

Tobias, - Alkuperäinen viesti - Lähettäjä: Tobias Asplund [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: mysql@lists.mysql.com Lähetetty: Tuesday, February 08, 2005 7:46 PM Aihe: Re: InnoDB crash and runaway rollback - help pls On Tue, 8 Feb 2005, Heikki Tuuri

Re: Multiple Tablespace

the table dumps to MySQL. Note that importing big tables to InnoDB can take days. As a sidenote: Jan and Jani are working on a fast index build algorithm. In 2006, the import may be quite fast. Thanks Sabeer Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking

Re: innodb problem

? an upgrade to 4.1.9, and reading http://dev.mysql.com/doc/mysql/en/multiple-tablespaces.html will help. When you DROP a table, the .ibd file will be deleted, and the disk space is released to the operating system. Many thanks if someone can help me!!! Best regards, Matteo Best regards, Heikki

Re: Premature InnoDB conversion.

/en/error-creating-innodb.html, and recreate the whole InnoDB installation. Tablespace corruption on Windows is rare. It could be an unknown InnoDB bug, an OS bug, or a hardware fault. New MySQL versions have better diagnostics. An upgrade to 4.0.23 would be good. Best regards, Heikki Tuuri

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

, this is going to be in my top 10 list. g we have found a sponsor. http://www.innodb.com/todo.php We are trying to hire a new developer for this. Mike Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB

Re: Why MySQL is very slow in dropping indexes?

All, slow index DROP and CREATE is a top complaint among MySQL users. Jan and Jani are now working to fix this. I guess in 2006 this problem has been removed. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool

Re: mysqld restarts with no apparent reason

All, the InnoDB prints below reveal nothing of the problem. They just show mysqld crashing and starting uo again. You are not using InnoDB tables, since the log sequence number does not grow. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL

Re: Serious bug (or my foolishness) with alter table and InnoDB

Karam, - Original Message - From: Karam Chand [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, January 25, 2005 8:58 PM Subject: RE: Serious bug (or my foolishness) with alter table and InnoDB Hello, I just checked with the same version at home and it works. Dont

Re: Out of tablespace when using innodb_file_per_table

.MYD-file has reached the maximum filesize of my filesystem and i have to add a new tablespace. .MYD file? That is a MyISAM type table. Can someone tell me how? http://dev.mysql.com/doc/mysql/en/adding-and-removing.html Thanks in advance for your help Carsten Best regards, Heikki Tuuri Innobase Oy

Re: MySQL Losing database information

Christopher, InnoDB tables are in ibdata files. I hope that you have not deleted them inadvertently. 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

Re: innodb tablespaces

Sirisha, you cannot remove just a single ibdata file: http://dev.mysql.com/doc/mysql/en/Adding_and_removing.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

Re: MySQL quota problem

be rolled back. I do not think it will make other databases useless. 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

Workaround for Windows bug in 4.1.9 in innodb_file_per_table: operating system error number 87

Hi! If you have put: innodb_file_per_table in your my.cnf or my.ini in Windows, and try to run MySQL-4.1.9, the mysqld server exits and prints: 050117 3:07:59 InnoDB: Operating system error number 87 in a file operation. to the .err log. You can work around the bug in 4.1.9 by putting:

Re: 4.0.20 - 4.1.9 Can't open file: 'Autor.ibd'

in a central file at 4.0.20 maybe and now individual table-files with 4.1.x? How can this happen? I hope that you have not destroyed the ibdata file. The tables are there. Did you edit the my.cnf in the upgrade? What does mysqld print to the .err log? Regards Marten Best regards, Heikki Tuuri Innobase Oy

Re: MySQL 4.1.8 InnoDB: data unavailability among different connections

: Heikki Tuuri [EMAIL PROTECTED] Lähetetty: Monday, January 17, 2005 11:11 AM Aihe: Re: MySQL 4.1.8 InnoDB: data unavailability among different connections Thank you all for the hints. What will be then the best solution to always get the latest data? - Use commits (e.g. 'COMMIT; SELECT . ) before

Re: MySQL 4.1.8 InnoDB: data unavailability among different connections

Jose, you must commit also the read transaction. http://dev.mysql.com/doc/mysql/en/InnoDB_consistent_read.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

MySQL/InnoDB-4.1.9 is released

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]

Re: Upgrade correpted InnoDB tables

Mattias, please use innodb_table_monitor to print the contents of the InnoDB internal data dictionary. http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html Regards, Heikki - Original Message - From: Mattias J [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, January

Re: Upgrade correpted InnoDB tables

Mattias, this is very strange. Have you used MySQL-5.0.x to create those tables? Or which MySQL version did you use when you created those tables? Regards, Heikki - Original Message - From: Mattias J [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, January 14, 2005

Re: Upgrade correpted InnoDB tables

Mattias, was it so that you RECREATED those tables with 4.0.21, and you STILL got the error in 4.1.8? Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, January 14, 2005 7:02 PM Subject: Re: Upgrade correpted InnoDB tables

Re: MySQL/InnoDB-4.1.9 is released

Nick, - Original Message - From: Nick Arnett [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, January 14, 2005 7:39 PM Subject: Re: MySQL/InnoDB-4.1.9 is released Heikki Tuuri wrote: * Do not acquire an internal InnoDB table lock in LOCK TABLES if AUTOCOMMIT=1

Re: MySQL/InnoDB-4.1.9 is released

Nick, - Original Message - From: Nick Arnett [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, January 14, 2005 9:28 PM Subject: Re: MySQL/InnoDB-4.1.9 is released Heikki Tuuri wrote: http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html The correct way to use LOCK

Re: Upgrade correpted InnoDB tables

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/ -- MySQL General Mailing List

Re: Upgrade correpted InnoDB tables

Mattias, have you observed these: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html Do you have table names containing accent characters like ? Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool

Re: MySQL Memory Issue

as the stack of each thread. 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: [EMAIL PROTECTED

Re: InnoDB files corrupt after copy to another disk???

ibdata files in the wrong order, or have copied an ibdata file over another, or some ibdata files are mentioned more than once in the innodb_data_file_path? ... Richard F. Rebel Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup

Re: BIG InnoDB problems!

Andy, - Alkuperäinen viesti - Lähettäjä: Andy Davidson [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lähetetty: Tuesday, January 04, 2005 5:02 PM Aihe: Re: BIG InnoDB problems! ...¨ On Mon, 3 Jan 2005, Heikki Tuuri wrote: the problem you had was serious corruption

Re: InnoDB: Error: tablespace size stored in header is 17024 pages,

+0200 Heikki Tuuri [EMAIL PROTECTED] wrote: are you sure that you copied the complete ibdata1 file to the new place? It is strange how 7 MB can be missing from the file end. I have just checked the tar file I used to do the transfer and sure enough, the file length is right there, but not in my database

Re: BIG InnoDB problems!

http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html - Alkuperäinen viesti - Lähettäjä: jsf [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: mysql@lists.mysql.com Lähetetty: Friday, December 31, 2004 5:21 PM Aihe: Re: BIG

Re: BIG InnoDB problems!

. Regards, Heikki - Alkuperäinen viesti - Lähettäjä: jsf [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Kopio: mysql@lists.mysql.com Lähetetty: Monday, January 03, 2005 4:31 PM Aihe: Re: BIG InnoDB problems! Hi Heikki, Please see below... On Mon, 3 Jan 2005 15:14:12 +0200, Heikki

Re: BIG InnoDB problems!

in InnoDB. If this happens again, please make a very detailed bug report, with the complete .err log, all the way from the birth of the installation up to the corruption. Regards, Heikki - Alkuperäinen viesti - Lähettäjä: jsf [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED

Re: InnoDB: Error: tablespace size stored in header is 17024 pages, but

that to the tablespace. Look from http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html how to edit my.cnf then. 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

Re: big table corruption

to bugs.mysql.com, if you are willing to upload the corrupt files via ftp for further analysis. What does CHECK TABLE print about the corruption? What MySQL version? What is SHOW CREATE TABLE like? What OS? Thanks, - Mark Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row

Re: BIG InnoDB problems!

stack trace is much more helpful in diagnosing the problem, so please do resolve it 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

Re: Fixing the worst InnoDB corruption bug in 3 years - when

Bruce, 5.0.3 is the next in line. I am not sure whether 4.0.9 comes after that. You should consider buying a MySQL support contract. MySQL Gold and Platinum Premier Support customers are entitled to custom builds: http://www.mysql.com/support/premier.html Best regards, Heikki Tuuri Innobase Oy

<    1   2   3   4   5   6   7   8   9   10   >