Re: Mysqld is keep crashing

: set-variable = innodb_force_recovery = 4 and dump your tables and recreate your ibdata files and ib_logfiles. I am using my-huge.cnf . I have 4 450Mhz with 4 gig ram -- Asif Iqbal Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool

Re: innodb data file of different size

Asif, since you did not have any my.cnf, ibdata1 is an auto-extending data file (initially 10 MB) in the datadir of MySQL. And there are two 5 MB ib_logfiles in the datadir. If you specify the last data file with the autoextend option, InnoDB will extend the last data file if it runs out of

Re: TRUNCATE problem ...

there is an foreign key on each self. Is this a Bug in MySQL? TRUNCATE is still implemented as DELETE FROM ... It is in the TODO list to implement it as DROP + CREATE. Workarounds: put ON DELETE CASCADE to the definition. Or SET FOREIGN_KEY_CHECKS=0 before the TRUNCATE. Regards, Rafal Best regards, Heikki

Re: mysql BUG, again ;)

Dyego, but now it works right. [EMAIL PROTECTED]:~/mysql-standard-4.0.8-gamma-pc-linux-i686/bin perror 139 Error code 139: Unknown error 139 139 = Too big row (= 16 M) The error message text above is wrong, though :). This has nothing to do with 16 MB. You should not put THAT many BLOBs in

Re: Really slow shutdown with Innodb, db not accessible?

Nick, - Original Message - From: Nick Arnett [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 29, 2003 8:54 PM Subject: Really slow shutdown with Innodb, db not accessible? For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K) to complete

Re: Really slow shutdown with Innodb, db not accessible?

Nick, - Original Message - From: Nick Arnett [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 1:24 AM Subject: RE: Really slow shutdown with Innodb, db not accessible? FYI, as I looked at the code that led up to this, I have

Re: Error with foreign key constraint when updating

; mysql use mydb mysql SHOW CREATE TABLE product; ? I am suspecting you printed these from wrong databases. 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

Re: Error with foreign key constraint when updating

it is possible the table really did not exist at the time you got the error. Can you repeat the error manually by trying an insert? Regards, Heikki - Original Message - From: Jeremiah Jacks [EMAIL PROTECTED] To: 'Heikki Tuuri' [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:08 AM

Re: MySQL 4.013 - How to set innodb_fast_shutdown?

] (Heikki Tuuri) wrote in message news:[EMAIL PROTECTED]... Eddy, - Original Message - From: Eddy Muljono [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, July 25, 2003 11:48 AM Subject: MySQL 4.013 - How to set innodb_fast_shutdown? I am using MySQL

Re: MySQL 4.013 - How to set innodb_fast_shutdown?

Eddy, - Original Message - From: Eddy Muljono [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, July 25, 2003 11:48 AM Subject: MySQL 4.013 - How to set innodb_fast_shutdown? I am using MySQL 4.013 (Win2000 Prof). How to set innodb_fast_shutdown to OFF in My.ini ? I

Re: Poor InnoDB Performance

with innodb_flush_log_at_trx_commit=0. Your log files are too small compared to the buffer pool size. 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/ - Original Message - From: DuffMan

Re: mysql stops processing

to find the problem with it. Regards, Heikki - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 24, 2003 9:57 PM Subject: Re: mysql stops processing Attached to this are two show innodb status reports from

Re: mysql stops processing

Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 24, 2003 11:33 PM Subject: Re: mysql stops processing We do not use LOCK TABLES anywhere. Are there any other commands that could cause a LOCK

Re: InnoDB locking: Different behavior on 3.23.55 and 4.0.13

Mikhail, I just tested this. You are probably using the query cache in 4.0. Then SELECT can return immediately without acquiring any locks. Of course, it can be discussed if the query cache, too, should respect LOCK TABLES. I am forwarding this to Sanja. Thank you, Heikki - Original

Re: mysql stops processing

Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or

Re: mysql stops processing

Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:03 PM Subject: Re: mysql stops processing Unfortunately, we haven't been able to connect to the database because of the maxed out

Re: mysql stops processing

Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:23 PM Subject: Re: mysql stops processing On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote: Joe, - Original Message

Re: mysql crashing regularly

David, - Original Message - From: David Bernick [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 22, 2003 8:02 PM Subject: mysql crashing regularly -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 your database is corrupt. It is trying to access a page at 8 TB.

Re: The MySQL Bug ?

Dyego, thank you for an excellent bug report. You probably tested the 4.0.14 tree? That was where I was able to repeat the bug. The bug was that InnoDB first deleted the old record and only after that tested if the new record is too long (table handler error 139). You have lots of BLOBs in the

Re: Frequent Table Corruption - Please Help

Message - From: Tom Roos [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:59 AM Subject: RE: Frequent Table Corruption - Please Help hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i

Re: 4.1.0 Roadmap ?

believe better than trust labels is to test your own application. Also a 'stable' version can contain a bug which stops your application. Regards Andy Jarrett www.thebluefrogcompany.net Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup

Re: alter table 'table' auto_increment = # doesn't work

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/ - Original Message - From: Ittay Freiman [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15

Re: Frequent Table Corruption - Please Help

Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. 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/ - Original

Re: 4.0.13 or 4.0.14

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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Frequent Table Corruption - Please Help

Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small

Re: innodb file won't shrink

Alvaro, - Original Message - From: Alvaro Avello [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL 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

Re: innodb file won't shrink

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

Re: innodb file won't shrink

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

Re: Adding FK via Alter Table not working

refer to http://sourcepost.sytes.net/sourceview.aspx?source_id=6332 the column type is tinyint in one table and int in another. = David L. Corsaut [EMAIL PROTECTED] mobile: 206.790.0969 Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot

Re: InnoDB Performance issues

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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: innodb file won't shrink

15th, 2003 you will be able to put every InnoDB table into its own file. That should alleviate this kind of problem. -Steve 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

Re: MySql Rollback in PHP within a website

rolls back the current uncommitted transaction. Regards, Bruce [EMAIL PROTECTED] (925) 866-2790 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/ -- MySQL

Re: InnoDb and fragmentation

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

Re: Can mysql handle this load?

Rudy, - Original Message - From: Rudy Metzger [EMAIL PROTECTED] To: Mike Hillyer [EMAIL PROTECTED]; Adam Gerson [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 6:47 PM Subject: RE: Can mysql handle this load? ... What the

Re: dropping foreign key constraint (version 4.1.0-alpha-max-nt)

in April. That is why the feature is not yet in 4.1.0. Version 4.1.1 will have DROP FOREIGN KEY. My guess is that 4.1.1 will be released August 31st, 2003. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL

Re: AUTOEXTEND

. This is a known weakness, and should be fixed some time in the future. 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/ - Original Message - From

Re: Benchmarking

to recover the database. Delete then the old log files from the log file directory, edit my.cnf, and start MySQL again. InnoDB will tell you at the startup that it is creating new log files. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup

RE: AUTOEXTEND

Subhakar, it is a bug which was fixed in 3.23.57: http://www.mysql.com/doc/en/News-3.23.57.html D.4.2 Changes in release 3.23.57 (06 Jun 2003) ... SHOW VARIABLES LIKE 'innodb_data_file_path' displayed only the name of the first datafile (bug #468). ... Regards, Heikki

Re: 4.0.14 Date?

/doc/en/InnoDB_news-4.0.14.html says it should be released in June... it's now July 8th. When can we expect 4.0.14 to be released? my guess is between July 15th and July 25th. Thanks in advance... Christian Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign

Re: innodb transaction

This level is like the previous one, but all plain SELECTs are implicitly converted to SELECT ... LOCK IN SHARE MODE. best regards benny 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

Re: 3.23.x to 4.0.x INNODB

beforehand anyway... 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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: AUTOEXTEND

STATUS FROM yourdatabasename; Thankx in advance, SB 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/ -- MySQL General Mailing List For list archives: http

Re: InnoDb and fragmentation

of maintenance be done on a regular basis? TIA My feeling is that no defragmentation is normally needed unless you tend to run out of disk space. I'm using Win2k with NTFS volumes. Mike Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool

Re: mysqld crashes during long index build

Emile, thank you for sending the whole .err log directly to me. This is probably the file i/o starvation bug which I have fixed in 4.0.14. In this case a big insert buffer merge causes sequential reads which seem to make requests by other threads to starve. I hope 4.0.14 will be out in two

Re: Unexpected empty table performance problem with MySQL and InnoDB

Alex, ---TRANSACTION 0 125987852, ACTIVE 1217449 sec, OS thread id 1712 you have transactions which have been active 1.2 million seconds, that is, 15 days! You should commit those transactions. You can also use SHOW PROCESSLIST to show those open sessions. Regards, Heikki - Original

Re: Inconsistent replication of a DELETE in InnoDB

Chris, thank you for the bug report. I was able to repeat the bug. It is indeed a bug if MySQL does not roll back the whole SQL statement if the statement provokes a foreign key constraint error. And it should not be written to the binlog. The fix is to change in /sql/sql_delete.cc the line 148

Re: InnoDB logfile question

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

Re: InnoDB logfile question

: 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

Re: Unexpected empty table performance problem with MySQL and InnoDB

Alex, why you do not look with SHOW INNODB STATUS if there are dangling transactions which could still see the delete-marked rows? Purge cannot remove them then. The main InnoDB thread tries to run a full purge even when the server is active. This snippet is from srv0srv.c of 4.0.14:

Re: Delete from InnoDB

Taylor, SHOW TABLE STATUS reports an estimate of the number of rows. What do you mean that you cannot access any data from the table? All SELECTs hang? What OS, what MySQL version? What does SHOW INNODB STATUS\G print? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com

Re: Delete from InnoDB

Taylor, you are running a very old alpha version of MySQL. Lots of bugs have been fixed since. Please upgrade to 4.0.13, or if you use replication, then 4.0.12 is a safer choice. Regards, Heikki - Original Message - From: Taylor Lewick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: ERROR 2013:Lost connection to MySQL server

Miguel, what exact MySQL version you are running? Have you created FOREIGN KEY constraints to those tables? Have you downgraded to a lower MySQL version? Regards, Heikki - Original Message - From: Miguel Perez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday,

Re: ERROR 2013:Lost connection to MySQL server

', FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00', FIDIASSERV smallint(6) NOT NULL default '0' ) TYPE=InnoDB; And I haven't tried to downgrade my version. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: ERROR 2013:Lost connection

Re: ERROR 2013:Lost connection to MySQL server

Heikki: The only thing that I did with those tables is that I renamed both of them. And I didn't drop anything. Do you think that the renamed thing did affect my tables?.. Greetings From: Heikki Tuuri [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re

Re: ERROR 2013:Lost connection to MySQL server

Pete, INSERT ... SELECT ... does not replicate properly with AUTO_INCREMENTs. Regards, Heikki - Original Message - From: Pete Harlan [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 1:10 AM Subject: Re: ERROR 2013:Lost

Re: InnoDB table recovery problem - not beeing able to start database server

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

Re: InnoDB file...

delete-marked rows if there are old transactions which could still see them. thank you friends aik_b p.s. MySQL doesn't seem to do a good usage of the disk space and the = InnoDB file size and its density..anyway Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions

MySQL/InnoDB-3.23.57 is released

(). * An outstanding bug: InnoDB could in rare cases return an extraneous row if a rollback, purge, and a SELECT coincided. 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

Re: MySQL/InnoDB-3.23.57 is released

much slower with this new release, it is because the value 1 causes a log flush to disk at each transaction commit. Best regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:49 AM Subject: MySQL

Re: Innodb error

, 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/ ... /* Copy records from the original page to the new page */ sup = page_get_supremum_rec(page); while

Re: Innodb error

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

Re: ERROR 1005: Can't create table './db/table.frm' (errno: 150)

Ben, please print with SHOW INNODB STATUS what kind of foreign key error InnoDB complains about in the import. Can you produce a repeatable test case with table dumps that shows the error? Are you sure you are importing all the tables within the same connection where you have set

Re: MySQL 4.0.13 Memory leakage?

Michael, in the case the memory leak would be in InnoDB, you can monitor its memory allocation with SHOW INNODB STATUS\G Total memory allocated 50738427; in additional pool allocated 1762432 Regards, Heikki - Original Message - From: Michael Loftis [EMAIL PROTECTED] Newsgroups:

Re: free table memory shrinks when data deleted

', and if lost, how can I regain it short of dumping and recreating the table. Thanks Ethan Joffe CTO Nami Media Inc. 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

Re: Can't delete on cascade

Miguel, if you are running MySQL-4.0.13, please use SHOW INNODB STATUS to look at a detailed error message of the latest foreign key error. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support

Re: deadlock problem?

with id = 0 713888581, sees 0 713875612 Remember to commit your transactions. 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/ - Original Message - From

Re: ON DELETE CASCADE ON UPDATE CASCADE

corrupt because a fixed length field is shorter than it should be! The fix will be in 4.0.14. Thank you, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL - Original Message - From: vinita Vigine Murugiah [EMAIL PROTECTED] Newsgroups

Re: Install on RH9

-A that you do not have mysqld's running after that. Thanks! -Alex Big Al Behrens 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

Re: ADD CONSTRAINT on InnoDB tables

is that RESTRICT is the default if you do not specify an 'action'. That is why SHOW CREATE TABLE does not explicitly print the RESTRICT. =0AMarco Barbato=0D=0A=0D=0A-= Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys

Re: Maximum statements per connection problem

to dbExpress. Since Borland is marketing their own database Interbase, they have somewhat conflicting interests here. I believe feedback to Borland or their newsgroups can speed things up. -- John A. Sullivan III Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign

Re: start innodb without transactions

the whole tablespace. Carlos 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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: error

John, what do SHOW CREATE TABLE user_new; and explain select count(*) from user_new where list_code = 18; and CHECK TABLE user_new; (this may last hours and will also print to the .err log) say? Which MySQL version you are running and on what Linux distro? Best regards, Heikki

Re: start innodb without transactions

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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: mysqld CPU usage is almost 100% !!!

Nino, are you using InnoDB tables? InnoDB does background purge and insert buffer merge. What does SHOW INNODB STATUS say during that spike? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support

Re: start innodb without transactions

, for example, a table import, and crash mysqld artificially by killall -9 mysqld Look then if InnoDB is able to scan the log in crash recovery. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support

Re: Mysql language

Hi! InnoDB is totally C, MySQL half C++ and half C, with a few hundred lines of x86 Assembler. Regards, Heikki - Original Message - From: electroteque [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, June 06, 2003 3:16 PM Subject: RE: Mysql language c++ ?

Re: distributed transaction management in MySQL

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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: debuggine 1205 / LOCK wait timeout exceeded errors

cache of MySQL-4.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/ - Original Message - From: Roman Neuhauser [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

Nils, most probably you have some other difference in the my.cnf files. Regards, Heikki - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 6:22 PM Subject: Re: Can't open privilege tables

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477

, 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/ .. Subject: RH 8.0 InnoDB: Assertion failure in thread 122911 in file mem0pool.c line 477 From: Richard F. Rebel Date

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477

Richard, - Original Message - From: Richard F. Rebel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 7:50 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911 in filemem0pool.c line 477 Hello Heikki, Sorry, last

Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477

Richard, - Original Message - From: Richard F. Rebel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 8:38 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911 infilemem0pool.c line 477 Hello Heikki, On Wed, 2003

Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477

Richard, - Original Message - From: Richard F. Rebel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 10:28 PM Subject: Re: RH 8.0 InnoDB: Assertion failure in thread 122911infilemem0pool.c line 477 Hello Heikki, On Wed

Re: debuggine 1205 / LOCK wait timeout exceeded errors

Roman, you can use SHOW INNODB STATUS to look what active transactions you have and how many lock structs they have. Also innodb_lock_monitor helps. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical

Re: malloc'ing 2GB+ of memory in mysql

. The memory crunch is getting so severe that I believe some 64-bit processor must become common by 2005. 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/ - Original

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

my.cnf or the access rights of the person running mysqld. The error means mysqld cannot access the file host.frm in the mysql subdir under the datadir. I suggest specifying the datadir explicitly in your my.cnf. Best regards Nils Valentin Best regards, Heikki Tuuri Innobase Oy http

Re: malloc'ing 2GB+ of memory in mysql

Owen, - Original Message - From: Owen Scott Medd [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:13 PM Subject: Re: malloc'ing 2GB+ of memory in mysql I know we are facing this same question right now (I have 8 way servers

Re: ALTER TABLE

. 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/ - Original Message - From: Becoming Digital [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent

Re: MySQL/InnoDB-4.0.13 is released

Rainer, - Original Message - From: Rainer Collet [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, May 31, 2003 5:49 PM Subject: Re: MySQL/InnoDB-4.0.13 is released [EMAIL PROTECTED] (Heikki Tuuri) wrote in message news:[EMAIL PROTECTED]... Hi! InnoDB

Re: Unable to install from source due to crash

. 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/ - Original Message - From: Dennis van der Meer [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent

Re: Maximum precision for DECIMAL column in MySQL

To: [EMAIL PROTECTED] ; Heikki Tuuri Sent: Friday, May 30, 2003 8:02 PM Subject: Maximum precision for DECIMAL column in MySQL It looks like the maximum precision for a DECIMAL column is 17 in MySQL. Is this documented anywhere? I get the following results: mysql CREATE TABLE `scale_test6` (`a_dec

Re: Recovering table structures from .frm files?

by the .frm file you want to read. This fools mysqld and it allows you to call SHOW CREATE TABLE ... Is the file format documented anywhere? Mark Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support

Re: Query log/binlog inconsistency

query log excerpt. Jeremy 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/ -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED

Re: Innodb memory problem

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

Re: Innodb transactions and drop table

. Christian. Best regards, Heikki Tuuri Innobase Oy --- MySQL Users Conference, San Jose, California, April 10-12 Register at http://www.mysql.com/events/uc2003/attendee.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Error: The table is full

Dyego, - Original Message - From: Dyego Souza do Carmo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 2:33 PM Subject: Error: The table is full i'm running the command: update contratante,pessoa set contratante.endereco =

Re: Question

Luis, a sneak peek of MySQL-4.0.13: mysql show innodb status; ... LATEST FOREIGN KEY ERROR 030324 16:14:01 Error in foreign key constraint of table test/tab3: There is no index in the table test/tab3 where the columns appear as the first

Re: fulltext search

Wynne, - Original Message - From: Wynne Crisman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'Heikki Tuuri' [EMAIL PROTECTED] Sent: Friday, March 21, 2003 5:18 AM Subject: Re: fulltext search Since InnoDB tables don't support fulltext searching yet, what is the recommended way to work

Re: Stopping InnoDb recovery and fixed columns

of that, instead of having fixed format rows I have dynamic ones. In a table with a few millions rows, it can make a big difference! tia filter: mysql, sql, table, database = - Benoit St-Jean Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot

Re: RedHat 8 SRC RPM 4.0.12 Build

Hat has a Bugzilla database, but it did not work through my IExplorer browser. Maybe it works with Mozilla? Can someone test? Thanks! Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-4.0 from

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