Re: Performance Problems with InnoDB Row Level Locking...

Alexander, - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: 'Heikki Tuuri' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 10:08 AM Subject: RE: Performance Problems with InnoDB Row Level Locking... Hi Heikki, one more question please

Re: Performance Problems with InnoDB Row Level Locking...

Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent: Friday, September 06, 2002 2:13 AM Subject: Re: Performance Problems with InnoDB Row Level Locking... Hi, On a side note, are there any plans to backport the spurious insert deadlock

Re: lost connection when modifying indexes

using InnoDB tables on Linux 2.4.3 SMP (Intel libc6) (I should probably upgrade to 4.0.3) yes, this bug was fixed in 4.0.2 I think. You may still get warnings to the error log, but they are not fatal. Amy Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https

Re: innodb questions about message board apps

of. Thx. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Before posting, please

Re: Performance Problems with InnoDB Row Level Locking...

Alex, - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 11:49 AM Subject: Re: Performance Problems with InnoDB Row Level Locking... Heikki, thank you for the answer. So

Re: InnoDB locks disappear

Wouter, the Lock Monitor output tells that trx 370099 has been committed or rolled back by the user. That is why the locks have disappeared. Have you taken into account the following: 8.5 When does MySQL implicitly commit or rollback a transaction? a.. MySQL has the autocommit mode switched

Re: InnoDB locks disappear

Query SELECT [t0.columns] FROM REQUEST t0 WHERE t0.STATUS = 'ReadyForProcessing' ORDER BY t0.CREATION DATE ASC 14:47:09 22 Query commit 23 Quit 14:47:283 Query DROP TABLE innodb lock monitor ---End Query Log - Original Message - From: Heikki Tuuri [EMAIL PROTECTED

Re: Fail to run version 4.0.3

mysqld.exe from an MS-DOS prompt: C:\mysql\bin mysqld --console What does it print? Use mysql.exe and mysqladmin.exe from an MS-DOS prompt to query and administer the server. These have better diagnostics than graphical tools. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB

Re: Innodb error on windows ME platform

*/ FALSE, /* Initial state nonsignaled */ name); ut_a(event); return(event); Thanks, Neil Malkani Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL

Re: InnoDB autoextend question

Duane, yes, you can change the last data file as auto-extending. Shut down mysqld, edit the my.cnf file, and start mysqld again. Another solution is just to add another file ibdata2: innodb_data_file_path = ibdata1:1000M;ibdata2:10M:autoextend Best regards, Heikki Innobase Oy Copied

Re: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?

? Or anything in the mysql logs? Don't see any cores... here is the error log entry mysqld got signal 10; I think that in the manual, in the changelog of 4.0.4, it says that this bug is fixed. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https

Re: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...

Rafa, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 10, 2002 1:46 PM Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT... Hello, I am working with mysqld-max-nt under windows 2000 and unsing

Re: Schema changes affect regular select?

Yuri, ADD COLUMN should not affect a SELECT concurrently running on the table. I tested this with a 3 million row InnoDB table. Can you repeat that unexpected behavior? Regards, Heikki Innobase Oy Copied message: ... Subject: Schema changes affect regular select? From: Yuri Date:

Re: HP-UX problem

mysqld ended Any idea of what could be causing this? Shouldn´t that library be statically linked? please download the latest MySQL-4.0.3. That should have the libraries statically linked. Many thanks and best regards, Richard. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL

Re: About the 4.1 release

about the first official 4.1 release? Any estimates? My guess is December 15, 2002. My previous guesses in the past 4 months have been 3 weeks too optimistic, on the average :). Best regards, Iikka Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking

Re: InnoDB Win2k Service doesn't start

-max-nt.exe as a service. M@ Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query

Re: The my.cnf and InnoDB tables

limit 2 GB. key_buffer is global, not per-thread. - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - Best regards, Heikki Tuuri

Re: Marketing materials ??

- Original Message - From: Yuri [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, September 18, 2002 12:37 AM Subject: Marketing materials ?? Hi, I may get in position to protect my choice of MySQL being confronted by completely non-technical management.

Re: Interesting innodb activity with 3.23.52

) thread schedulers may solve this problem. Adrian Liang Em: [EMAIL PROTECTED] Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query

Re: Assertion failure with MySQL 4.0.3/InnoDB

Jose, if this occurs in an SQL query of type ... ORDER BY primarykey DESC then this is probably the bug which is fixed in upcoming 4.0.4. I hope 4.0.4 will be released in a few days. Best regards, Heikki Innobase Oy - Original Message - From: jesus [EMAIL PROTECTED] Newsgroups:

Re: optimizer bug in selecting fields that dont belong to the index used by mysql/innodb

Rafa, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, September 23, 2002 10:54 AM Subject: optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb Description: Hello, I wrote the following text in my

Re: Mysql/Innodb bug

Joe, this is a serious bug, because it can also spoil recovery from a backup. What MySQL version and Linux kernel you are running? Do you use RAID or NFS? How much RAM, how much swap partition of Linux? What do the corrupt binlog file names look like? Please show us all binlog files names, and

Re: mysql magically restarts of its own accord

Rich, 06 13:38:46 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 5 778892274 InnoDB: Doing recovery: scanned up to log sequence number 5 778957312 InnoDB:

Re: mysql magically restarts of its own accord

Stephen, the manual erroneously states that CHECK TABLE only works for MyISAM tables. I will update the manual. Thanks for pointing out! Run CHECK TABLE on your tables to check if they are corrupt. Does CHECK TABLE work on INNODB tables? According to the docs it only work for the MyISAM type.

Re: database slow down

Hi! This is a followup to my previous messages indicating database slow down. After noticing the queries start to slow down earlier i decided to try and get some debug info. a show table status had one interesting thing. | raw| InnoDB | Fixed | 169681 | 1030 |

Re: database slow down

rows than before and pagehits_hr contains at most 20K rows. Any ideas would be really welcome. Maybe I should change the delete from to a drop and create. Rich - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 19, 2001 8:10 AM Subject

Re: innodb locks

Hi! Copied message: .. Hi, I'm a regular mysql user, and a very newbie to innodb. :) I would like to use innodb because of its row-level locking feature. Presently I have to use table locks, and they're causing lots of speed problems. (I've tried Gemini tables, but mysql always crashed

Re: innodb and use of indices

and reimport them. That can give a significant performance boost. Regards, Heikki -Original Message- From: nsabbi [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, November 21, 2001 11:37 AM Subject: innodb and use of indices HI, I

Re: innodb and use of indices

Hi! On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote: The way to defragment InnoDB tables, or tables in any database, is from time to time to dump and reimport them. That can give a significant performance boost. That is actually not entirely true. For MyISAM tables, one simply needs

Re: insert/delete locking with innodb

Hi! If I have a process inserting into an innodb table in 200 insert chunks. i.e. it commits after every 200 inserts, must another process, which wants to delete data from this table, wait for the next commit on the insert end? If not is there any reason why my process is doing this. Do you

Re: InnoDB Compiler error (as well)

Ashley, Okay, so seeing Gemini failing, it was InnoDB's turn: gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:187: impossible

RE: Need to repair InnoDb tables

to be a bug related to CREATE TABLE and DROP TABLE. I have found it a good idea to commit and reconnect after creating an InnoDB table. Erik Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ -Original Message- From: Heikki Tuuri [mailto

InnoDB in the release MySQL-3.23.45

big estimates for the rowcount in SHOW TABLE STATUS. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re:Another Lack of InnoDB ...... comparing to MyISAM

Ady, what version of MySQL you are running? In 3.23.44 there was a bug which could cause an assertion failure in trx0trx.c, line 178. Please test with 3.23.45 or .46. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ After having

Re: InnoDB select slow too

Chris, what is your my.cnf or my.ini like? Do you have a big enough innodb_buffer_pool_size? Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either

RE: MySQL v.s. Oracle

Hi! Look at the InnoDB/MySQL user stories at http://www.innodb.com 1200 queries per second on a single processor Intel box is easy to attain. A terabyte of data is handled at an InnoDB/MySQL site. InnoDB is close to Oracle in architecture. Regards, Heikki http://www.innodb.com -- Order

Re:mysql_insert_id and transactions

-{'mysql_insertid'}. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ At 01:12 PM 12/3/01 +0200, you wrote: Hi Jason and Heikki, Heikki Tuuri writes: Jason, SELECT LAST_INSERT_ID() seemed to work from the mysql client

Re: Crash Replication Server

Raffaella, try to compile the latest version 3.23.46 on your system with the gcc -g flag. MySQL AB does not have a ready binary on Tru64, so you have to compile yourself. If it still crashes, run the slave inside gdb and do bt full, so that we see where it crashes. Regards, Heikki

Re:Creating MySQL table w/2 primary keys

Hi! CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) ) Type=InnoDB; I guess the following

Re: A bug or problem

Leonardo, Hello there. I just found something that I couldn't exactly call a bug. Certainly it is a problem. If I have a InnoDB table with an auto_increment field and try to insert a row in this table, it will increment the field in question normally. The problem happens when the query used

Re: innodb won't allocate the memory i ask it to

Rich, I have a system with 1gig of ram and i am trying to get the innodb buffer to be about 750megs. Whenever I set the value in the database config file it won't start with an error along the lines of, 011207 21:02:42 mysqld started InnoDB: Fatal error: cannot allocate 67108864 bytes of

[PERFORMANCE] Wrong flags in recent MySQL/InnoDB binaries on Windows cause slow performance

Hi! We just found out that recent MySQL AB binaries on Windows have UNIV_SYNC_DEBUG defined in univ.i. That makes InnoDB a lot, maybe 10 times, slower than the normal version. Miguel is right now compiling new binaries where the flag is set right. Thus if you have seen high CPU usage on

[PERFORMANCE] MySQL/InnoDB-3.23.46a for Windows available now, fixes the slowness in .44 - .46

Hi! Windows binaries of MySQL-3.23.44 - .46 were accidentally compiled with UNIV_SYNC_DEBUG defined in the project file. That makes some InnoDB queries up to 10 times slower than they should be on Windows. Fixed binaries, named 3.23.46a, are now available for download at

Re: MySQL error

Hi! Table handler error 100 used to mean a deadlock or a lock wait timeout in InnoDB. Starting from version 3.23.44 these have been replaced by native MySQL error codes 1213 and 1205. Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/

Re: Upgrading from MySQL to MySQL max on a production server

Hi! I do not understand how replacing just the executable mysqld can make your 'mysql start' (or is it 'mysql.server start'?) script or safe_mysqld script to search the executable from a different directory than it did before. Are you sure you did not change anything else in the system? Anyway,

Re: Bug in Foreign key constraint

Hi! Foreign keys do not work if you do an ALTER TABLE. I have to add a note to the manual that they do not work even if you do an ALTER TABLE to the referenced table. Workaround: use DROP TABLE + CREATE TABLE to alter your table, whether it is the referring table or the referenced table. If

Re: Bug in Foreign key constraint

Hi! At 04:10 PM 12/13/01 -0200, you wrote: Heikki Tuuri wrote: Hi! Foreign keys do not work if you do an ALTER TABLE. I have to add a note to the manual that they do not work even if you do an ALTER TABLE to the referenced table. Workaround: use DROP TABLE + CREATE TABLE to alter your

Re: Bug in Foreign key constraint

Hi! At 12:24 PM 12/13/01 -0800, you wrote: Heikki Tuuri wrote: Foreign keys do not work if you do an ALTER TABLE. I have to add a note to the manual that they do not work even if you do an ALTER TABLE to the referenced table. Are you saying that you can't add columns to a table (to grow

RE: MySQL v.s. Oracle

Robert, -Original Message- From: Robert Sundstrvm [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 13 de Dezembro de 2001 11:55To: [EMAIL PROTECTED] Subject: RE: MySQL v.s. Oracle At 04:23 2001-12-02 , you wrote: Not sure that total users is a good metric; queries per second may bebetter.

Re: Troubles with Mysql + InnoDB

Hi! I tried with 3.23.47, and the script did not fail. The assertion failure means that adding of a foreign key constraint fails because of some error number which should not happen. You could modify and recompile MySQL so that mysql/innobase/dict0crea.c, line 1237, would print the error code:

Re: Error 139

Hi! I received a table handler error 139 on several occasions while trying to convert a table to type InnoDB (alter table data type=InnoDB). I ran a check table and optimize table on it, and converted it from MyISAM to BDB successfully. Today, when I tried it again to get the exact error

Re: UNIQUE in InnoDB

Hi! I will change InnoDB so that it allows several NULL values in secondary indexes even if that index would have been declared UNIQUE. Oracle has a similar convention. In the case of foreign keys, I advise against using NULL values, because in SQL NULL really means 'an unknown value'.

Re: Installation problem Windows98

Gitta, in Windows the error number 32 means: 32 The process cannot access the file because it is being used by another process. ERROR_SHARING_VIOLATION Maybe the installation left the MySQL server mysqld running in your system? When you try to start another mysqld instance, it rightfully

RE: Innodb Win2000 error

Forwarded message: Return-Path: [EMAIL PROTECTED] From: Mehalick, Richard RE SITI-ITPSCA [EMAIL PROTECTED] To: 'Heikki Tuuri' [EMAIL PROTECTED] Subject: RE: Innodb Win2000 error Date: Tue, 18 Dec 2001 11:41:45 -0600 Thank you for responding. I was just going to post again that I solved

Re: InnoDB still gives poor analysis to the optimizer

Philip, I recommend using the MySQL STRAIGHT JOIN and USE INDEX clauses to manually force the best plan. You could also use innodb_table_monitor to check that the key value set cardinality estimates are approximately right for the tables h, pt, and p. But to put it the other way, how could the

Re: Can't connect to SERVER MYSQL localhost

Daniel, see the online manual at http://www.innodb.com It contains a list of Windows and Linux operating system error codes. Error 3 in Windows means 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND Check that the directory path c:\mysql\data\ibdata exists. Regards,

Re: deleting from an InnoDB table with a composite PK 500 chars crashes mysqld

Hi! I was able to repeat this in our computer. mysqld crashes inside the MySQL code. It did not crash if the primary key length was 500 bytes. This looks like a memory overrun bug. I have forwarded this bug report for Monty to check. Regards, Heikki Tuuri Innobase Oy --- Order commercial

Re: deleting from an InnoDB table with a composite PK 500 chars crashes mysqld

in unireg.h to 4000 bytes and let myisam etc. table handlers return their specific values (= 500 bytes) in their max_key_length() function. Regards, Heikki Tuuri Innobase Oy --- Order commercial MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest

Re: Problems in Foreign Key Syntax

is in the parser put also on other columns. Regards, Heikki Tuuri Innobase Oy --- Order commercial MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hi!! I am trying create the following tables:- CREATE TABLE Scenario ( Scenario

Re: Problems in Foreign Key Syntax

to decide this. To avoid that this feature prevents creation of foreign key constraints, I will allow a VARCHAR column to reference a CHAR column, and vice versa, in 3.23.47. Regards, Heikki Tuuri Innobase Oy --- Order commercial MySQL/InnoDB support at https://order.mysql.com/ See http

Re: Problems in Foreign Key Syntax

before without the foreign key constraint and dropped it. I have read that there might be some problems there too, but if I take out the Foreign Key constraint it creates the wishlish table which leads me to believe this isn't that problem. Thanks, Patrick Burleson Regards, Heikki Tuuri

Re: Problems in Foreign Key Syntax

you a char column can refer a varchar column and vice versa. Regards, Heikki Tuuri Innobase Oy --- Order commercial MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hi!! I have been trying to create the following tables:- 1

Re: Problems in Foreign Key Syntax

many people write table and column names in quotes? What is the origin of that convention? Avoiding reserved words? I may change the InnoDB parser so that it removes quotes from table and column names when it parses the FOREIGN KEY clause. Thanks, Patrick Regards, Heikki Tuuri Innobase Oy

Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

contention. But I decided to keep a single latch, because when running InnoDB in a multiprocessor Xeon computer the memory bus gets saturated before any latch contention. Thanks much, --Walt Weaver Bozeman, Montana Regards, Heikki Tuuri Innobase Oy http://www.innodb.com

Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

Philip, On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote: : The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts : per second would not be possible. Did the table fit in the buffer pool of : InnoDB or the SGA of Oracle? Did you commit each insert individually

InnoDB in MySQL-4.0.1

restricted to 500 bytes. The MySQL interpreter is not able to handle longer keys. Best regards and a Happy New Year! Heikki Tuuri Innobase Oy [EMAIL PROTECTED] http://www.innodb.com - Before posting, please check: http

InnoDB in MySQL-3.23.47

the primary key. This will save a sort in some ORDER BY queries. * The maximum key length of InnoDB tables is again restricted to 500 bytes. The MySQL interpreter is not able to handle longer keys. Best regards and a Happy New Year! Heikki Tuuri Innobase Oy [EMAIL PROTECTED] http://www.innodb.com

Re: Multiples instances of MySQL

give the path would help in many situations. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hello Tony, Thank you for your note and assistance. However, I'm stuck

RE: UNIQUE in InnoDB

Jose, thank you for the bug report. You are right: if there are several NULLs in a unique secondary index, CHECK TABLE will report table corruption because of a duplicate key in the index. I forgot to ease the check in CHECK TABLE. I have now fixed this for 3.23.48. Regards, Heikki Innobase

Re: InnoDB in MySQL-4.0.1

Hi! Sorry, I think there is no row-level privilege setting in MySQL. You have to code the logic in your application. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Re: Multiples instances of MySQL

Hi! Ok, the appropriate parameter mysqld --defaults-file=your_path_to_my_cnf already exists with which you can explicitly specify what my.cnf file mysqld reads in. Regards, Heikki Date: Sun, 30 Dec 2001 23:23:18 To: [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re

Re: InnoDB in MySQL-4.0.1

Hi! On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote: * Recovery has been made more resilient to corruption of log files. Can I ask what you mean here? If the log files are corrupt, is recovery still possible then? Or are the log files themselves less likely to get corrupted

Re: FOREIGN KEYs and ALTER TABLE

Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Re: FOREIGN KEYs and ALTER TABLE

Hi! -Original Message- From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, January 03, 2002 3:21 PM Subject: Re: FOREIGN KEYs and ALTER TABLE On Thu, Jan 03, 2002 at 01:48:21PM +0200, Heikki Tuuri wrote: : Hi

Re: FOREIGN KEYs and ALTER TABLE

Hi! Use SELECT INTO OUTFILE + READ DATA INFILE Do not rename tables. Regards, Heikki -Original Message- From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, January 03, 2002 5:54 PM Subject: Re: FOREIGN KEYs

Re: Mysql, innodb, linux problems

Bernard, please upgrade to 3.23.47. There were several hang bugs in 3.23.39. Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Hello, Hope it is a good place

Re: Innodb/Replication problems.

(2.65 sec) -- Best regards, Peter mailto:[EMAIL PROTECTED] Regards, Heikki Tuuri Innobase Oy --- MySQL/InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

Re: help with innodb my.ini config

Hi! Your my.ini looks ok, except that you should set innodb_data_home_dir equal to an empty string if you give absolute paths in innodb_data_file_path Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com

Re: help with innodb my.ini config

-Original Message- From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Sunday, January 06, 2002 7:54 AM Subject: Re: help with innodb my.ini config Hi! MySQL does not find your my.ini. Try renaming it to my.cnf and put it to the root directory of the C

Re: Mysql, innodb, linux problems

Prabhu, 4.0.x is the development version. 3.23.xx is better tested. But 4.0.1 looks good now that it has been out a couple of weeks. Upgrading to 4.0.1 is another possibility. Regards, Heikki Tuuri Innobase Oy --- MySQL/InnoDB - transactions, row level locking, and foreign key support

Re: Lost connection, C API

Hi! Are you running mysqld under the safe_mysqld script, which automatically restarts mysqld after a crash? If yes, look at the 'hostname'.err file and send its contents to me. Or, if you run mysqld from the command prompt, capture what mysqld prints to the command prompt window. If mysqld

Re: variable descriptions missing in the documentation

Jean-Luc, for InnoDB variables look at section 2 of http://www.innodb.com/ibman.html Regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB . I would need those

Re: Make fails building innodb - btr_search_check_guess

from www.mysql.com Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ... Description: Make failed with the following errors: gcc -O3 -DDBUG_OFF -O3 -felide

Re: Lost connection, C API

several client threads, are you sure you create one connection to each thread, and issue the C API commands in the right order? Sometimes people try to use a single connection for several client threads, and get the error above. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL

Re: Assertion failure in thread 54 in file trx0undo.c line 1316

Alex, looks like a memory overwrite. A trx undo log object contains a random field. Did you do anything special with the database when this happened? Regards, Heikki Innobase Oy . Bonjour, Any idea ? I will try to make the server crash one more time and tell you if

Re: Installation of mySQL on a Win2000 Pro machine

Andrew, please do not send attachments to the mailing list. They do not come through. I have copied parts from the InnoDB online manual, section 2, below. I hope they help in installation. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https

Re: MySQL + InnoDB + fereign keys

Ivan, currently InnoDB allows a NULL in the child column only if there is a NULL in the parent column. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction

sets table level locks. You can use innodb_lock_monitor to make the mysqld server program print (somewhat cryptic) information about who has locks and where. See the InnoDB manual at http://www.innodb.com/ibman.html Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level

Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction

John, MySQL runs by default in the auto-commit mode. In the auto-commit mode you do not need to write the COMMIT after each statement. But if you do SET AUTOCOMMIT=0, then you have to call commit explicitly. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support

Re: InnoDB : Lock wait timeout exceeded; Try restarting transaction

Hi! It is a bug if the sleeping connection is in the auto-commit mode. But we need more information of the problem. If you encounter it, please send the exact sequence of SQL commands which leads to the problem. You may also test SET AUTOCOMMIT=1 explicitly in your program. Note that LOCK

Re: MySQL on Linux 2.4 question

Walt, a possible reason is that fsync is much faster in Linux-2.4 than in 2.2. Check that the combined size of your log files is 50 % - 100% of the buffer pool size. Small log files cause more disk i/o and more fsyncs. The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer.

Re: Input Needed: Replication issues...

be solved with the above trick. - Transactions might help a little bit if you want to make several changes to the database as one atomic operation (= transaction). Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com

Re: Database Size Limit

. InnoDB reuses the space in its tablespace (tablespace = all the data files concatenated). Thus space which is freed from one table is available for other tables to use. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http

Re: Official State of Mysql-Max

/InnoDB from the InnoDB website http://www.innodb.com. It contains also a bug list. Thanks in advance. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

Re: Altering InnoDB tables

will introduce the my.cnf option innodb_no_unique_checks in 3.23.4x. Thank you for bringing this up :). About Robert Ricci's question: SHOW TABLE STATUS FROM ... reports FOREIGN KEY constraints in the table comment section. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL

Re: innoDB confusion

Aaron, please look at http://www.innodb.com/features.html, http://www.innodb.com/division.html, and http://www.innodb.com/ibman.html Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual

Re: innoDB confusion

Aaron, -Original Message- From: Rutledge, Aaron [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Date: Tuesday, January 15, 2002 7:13 PM Subject: RE: innoDB confusion Thank You Heikki, That information helps a lot. A couple quick questions if you dont mind: In regards

Re: Foreign keys

with SHOW TABLE STATUS that the table FIRST was really created in your test. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Pierre Radulescu wrote in message ... Hi

Re: innoDB confusion

regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB --Walt Weaver Bozeman, Montana -Original Message- From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]] Sent: Tuesday

Re: innoDB confusion

Hi! -Original Message- From: Philip Molter [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, January 15, 2002 8:24 PM Subject: Re: innoDB confusion On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote: : Hi! : : Weaver

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