Aaron,
I've currently got a project to migrate a LARGE (3.5TB) MySQL data set from
a Sun SPARC machine to a Sun x86 machine, both running Solaris 10 (though
obviously one is x86 and the other is SPARC). Is it possible to simply copy
the data files from one host to the other or is a full
Mariella,
Mariella Petrini wrote:
Hi All,
I have been using MySQL 5.1.x with InnoDB and Raw
Devices.
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=/dev/hdd1:3Gnewraw;/dev/hdd2:2Gnewraw
...
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=/dev/hdd1:5Graw;/dev/hdd2:2Graw
Is
Juan,
InnoDB Hot Backup is non-free. A 1-year license costs 390 euros + VAT,
and a perpetual license 990 euros + VAT.
http://www.innodb.com/order.php
The Perl script innobackup can be used to make consistent backups of
MyISAM tables also, but those backup require the locking of MyISAM
Mungbeans,
I do not understand how you get error 152 from the ALTER.
./include/my_base.h:355:#define HA_ERR_ROW_IS_REFERENCED 152
Please print SHOW INNODB STATUS\G after you get that error.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign
get access. Lastly, there
were no errors printed to the .err log prior to the errors I sent.
Thank you so much for writing back. I do truly appreciate it! It is
very relieving to know it is not dangerous.
Best Regards,
Jason
Regards,
Heikki
On 12/30/06, Heikki Tuuri [EMAIL PROTECTED] wrote
Leo,
Leo Huang wrote:
Heikki,
Thanks for you help!
I also read the comment in file of innodbase/lock/lock0lock.c in which
you said Different transaction can have conflicting locks set on the
gap at the same time.. I think that the innodb gap lock's behavior
just like an IX lock's behavior.
Leo,
'gap' locks in InnoDB are purely 'inhibitive': they block inserts to the
locked gap. But they do not give the holder of the lock any right to
insert. Several transactions can own X-lock on the same gap. The reason
why we let 'conflicting' locks of different transactions on a gap is
that
Ratheesh,
if the database otherwise looks ok (no crashes, no corrupt tables), then
the easiest way to fix the wrong log sequence number (lsn) is to
artificially inflate the log sequence number. If your log sequence
number is 4 GB too small, then inserting and deleting 4 GB worth of rows
will
David,
please send the entire .err file to me, zipped.
Please tell the exact MySQL version you are using.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
Curtis,
the reason why innodb.com was unreachable for some time on Friday was
that Oracle web administrators moved the DNS records to an Oracle domain
server. The registrar of innodb.com is Tucows, and I believe the admins
made some error which caused Tucows to set renewyourname.net as the
Bill,
we are moving the DNS of innodb.com from Capnova to Oracle Corp.
I can now view http://www.innodb.com through my ISP, Elisa. Does anyone
still have problems accessing http://www.innodb.com?
If you cannot see some web page, you can resort to Google's cache to
view it. I hope that we
Tim,
we hired Osku in August 2005 to work on the fulltext project. Osku has
done also lots of other work during the past 15 months. His fulltext
project is progressing slowly but steadily. I cannot give any promises
when/if Osku's work will be ready.
A factor that also affects this is that
Giorgio,
InnoDB only implements MATCH SIMPLE. MySQL/InnoDB ignores the MATCH
clause that you specify in the foreign key constraint definition.
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
A referential constraint is satisfied if one of the following con-
Dominik,
what does SHOW TABLE STATUS show for other tables?
Are you using innodb_file_per_table?
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
MyISAM
regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
MyISAM tables
http://www.innodb.com/order.php
Heikki Tuuri wrote:
FYI:
http://lists.mysql.com/mysql/202574
what does
Mike,
Oracle Corp. and MySQL AB renewed the InnoDB OEM contract in spring
2006. The licensing of InnoDB is the same as before and it is
distributed in the official MySQL distros.
Best regards,
Heikki Tuuri
CEO of Innobase Oy
VP of Oracle Corporation
Has Oracle placed any
Nico,
please post more output. Maybe the SELECT from H.albero is just entering
InnoDB, and therefore the associated transaction has not yet started.
The output shows lots of file reads. There should be running queries visible
in other printouts.
Best regards,
Heikki
Oracle Corp./Innobase
Vitaliy,
- Original Message -
From: Vitaliy Okulov [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, May 26, 2006 5:28 PM
Subject: innodb database crash
Hi all. I have some InooDB mysql crush logs, can somebody explain what
they mean?
Quote:
060525 18:09:43
Andrew,
a possible reason for the corruption is that you have enabled write caching
in the disk controller or in the disk, but those caches are not
battery-backed. Then a hard reboot may destroy the contents, and the
database becomes corrupt.
What kind of hardware are you using? Do you have
Dobromir,
you are running a 32-bit operating system. Then the size of the mysqld
process is limited to 2 GB, or at most to 4 GB. The amount of total RAM 8 GB
does not help here, since 2^32 = 4 G.
You should reduce the key_buffer_size or innodb_buffer_pool_size in my.cnf.
Best regards,
Sheeri, Gu Lei,
SHOW PROCESSLIST only knows about MySQL table locks.
To list row locks, you need to use innodb_lock_monitor:
http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys
Mohammed,
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
If your last data file was defined with the keyword autoextend, the
procedure for reconfiguring the tablespace must take into account the size
to which the last data file has grown. Obtain the size of the data file,
Marten,
Marten Lehmann wrote:
Hello Heikki,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
the complete log is about 50 mb, since a lot of errors occur.
I am interested in what caused the very first crash in the server. Now
your
database seems to be seriously
Marten,
- Original Message -
From: Marten Lehmann [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 29, 2006 7:52 PM
Subject: Re: innodb errors on startup
Well,
ok, we need to stress this more in the manual. A few users have
misunderstood that ibdata
Marten,
I replied today to your earlier email with the message pasted below.
Regards,
Heikki
Marten,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously
Sheeri,
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 28, 2006 9:29 PM
Subject: problems/feature request ideas
2 weeks ago we had a server crashing, and while I was checking it out
(before, during and after
Gordon,
what does mysqld write to the .err log?
InnoDB should be included in all 5.1 binaries.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
Marten,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously corrupt, since the log sequence number in the
log files is only 14 MB, while it is = 153 MB in a data
Ubaidul,
ok, there is nothing in my.cnf that can explain why memory runs out.
What kind of query are you running when the memory runs out? Does 'top' show
that the mysqld process size grows uncontrollably?
If you are using the C client interface, do you use 'mysql_store_result()'
or
Mike,
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 22, 2006 3:42 AM
Subject: Problem restarting server
Hello,
we had to reboot our server and now we can't get MySQL started, in the
error log
it states:
Rithish,
- Original Message -
From: Rithish Saralaya [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, March 20, 2006 10:02 AM
Subject: deadlock - further information
--=_NextPart_000_0059_01C64C23.16088020
Content-Type: text/plain;
charset=iso-8859-1
Ubaidul,
- Original Message -
From: Ubaidul Khan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, March 20, 2006 8:31 PM
Subject: MySQL malloc error on Solaris
Hello,
We are running MySQL 4.0.13 on Solaris 8 UltrSPARC with 2048 MB of RAM.
This machine has plenty
David,
- Original Message -
From: David Felio [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 16, 2006 11:31 PM
Subject: Errors 1005 and 1025 - but not foreign keys
I got an error 1025 trying to rename an InnoDB table. When I go to
look in the database
Hi!
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 16, 2006 8:59 PM
Subject: Re: NULL columns
When doing an insert using NULL in the insert request,
what really is being written in the column?
Is the word
Rob,
- Original Message -
From: Rob Brooks [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, March 12, 2006 6:02 PM
Subject: InnoDB Commit question
--=_NextPart_000_0033_01C645BC.03223720
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding:
Robert,
actually, InnoDB always internally adds the PRIMARY KEY to every secondary
index record:
http://dev.mysql.com/doc/refman/5.0/en/innodb-table-and-index.html
If a column has just four different values, then in most cases an index on
that column does not help at all. And every index
Alan,
- Original Message -
From: Alan Fisher [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 09, 2006 8:38 PM
Subject: InnoiDB Backups
All,
I would like to knew if anyone knows of a way to automate innoDB Hot
Backups
of several databases that can be
to the disks.
Osvaldo Sommer
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
MyISAM tables
http://www.innodb.com/order.php
-Original Message-
From: Heikki
Osvaldo,
- Original Message -
From: Osvaldo Sommer [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 07, 2006 12:58 AM
Subject: Problem INNODB error 995
--Boundary_(ID_PMYElD1sU13Il0ENO4J+aw)
Content-Type: text/plain;
charset=us-ascii
Daevid,
- Original Message -
From: Daevid Vincent [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 07, 2006 5:54 AM
Subject: RE: Boolean searches on InnoDB tables?
Osku is working on FULLTEXT for InnoDB.
So, despite what the documentation says:
Ady,
- Original Message -
From: Ady Wicaksono [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, March 06, 2006 5:32 PM
Subject: MySQL InnoDB Row insert Calculation
With autocommit=1, anybody could give calculation on how many rows could
be inserted in 1 seconds?
Daevid,
- Original Message -
From: Daevid Vincent [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, March 04, 2006 9:54 AM
Subject: Boolean searches on InnoDB tables?
I just discovered this:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
Which
Vinay,
- Original Message -
From: Vinay [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 02, 2006 12:20 AM
Subject: Enforcing Isolation in MySQL database
--=_NextPart_000_002C_01C63D51.B51315D0
Content-Type: text/plain;
charset=iso-8859-1
Robert,
- Original Message -
From: Robert DiFalco [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 26, 2006 8:27 PM
Subject: RE: Why do these transactions show table locks?
It might be important to note that I have a delete trigger on the ELEMS
table,
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 25, 2006 4:05 PM
To: mysql@lists.mysql.com
Subject: Re: error 1016 : cant open ibd file
: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Friday, February 24, 2006 3:55 PM
To: mysql@lists.mysql.com
Subject: Re: error 1016 : cant open ibd file even though it exists
Rithish,
from the .err log we see that mysqld was shut down for 12 hours on Feb
19th.
What did the sysadmins do during that time
-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 7:52 PM
To: mysql@lists.mysql.com
Subject: Re: error 1016 : cant open ibd file even though it exists
Rithish,
the table definition does not exist in the ibdata file. You have the
.frm file and the .ibd file
Rithish,
the table definition does not exist in the ibdata file. You have the
.frm file and the .ibd file, but that does not help if the table
definition is not stored in the ibdata file.
How did you end up in this situation? Did you move .frm and .ibd files
around? Did you recreate the
Luke,
if you do not have ANY valuable InnoDB tables in the installation, you can
simply delete the ibdata files and ib_logfiles. Be very careful if you have
several MySQL instances in the same computer.
As Sheeri wrote, MySQL's system tables 'user.MYD' etc. are MyISAM tables in
the 'mysql'
Robert,
please post SHOW INNODB STATUS\G during such lock wait, so that we see what
lock it is waiting for.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs
that I was inserting into.
R.=20
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, February 20, 2006 1:18 PM
To: mysql@lists.mysql.com
Subject: Re: Lock wait timeout exceeded during concurrent inserts on an
InnoDB table
Robert,
please post SHOW INNODB STATUS\G
Hi!
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, February 14, 2006 5:50 PM
Subject: MySql InnoDB
Hi,
I'v installed MySql on my machine and created a new tables.
when i open some table to alter it,i see in the COMMENT textbox:
Ady,
I replied to the bug report.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message
Brandon,
sorry, you cannot move .ibd files between installations. The ability to do
so is in the TODO, but I cannot promise any release date.
Currently, the only way to move individual InnoDB tables between
installations is the dump + import method.
Best regards,
Heikki
Oracle
Patrick,
it should work. You have only shown a fragment of the application code.
Maybe there is a bug somewhere else. If you write a very simple test program
to test this, do you still get the duplicate values?
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level
Shaun,
the my.cnf looks ok. You might be able to raise the InnoDB buffer pool size
to 3G, but beware swapping.
SHOW INNODB STATUS looks ok, though it would be more informative if it were
taken during a typical workload.
Free buffers 0
Having free buffers 0 is very normal. Buffers
Ji-Haw,
if the OS crashes do not corrupt files, then InnoDB tables would survive an
OS crash without a problem.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also
Jan,
if you make the InnoDB buffer pool big enough to hold all your data, or at
least all the 'hot data', and set ib_logfiles large as recommended at
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html, then
InnoDB performance should be quite close to MEMORY/HEAP performance for
Hi!
All this was already mentioned in the discussion thread, but I summarize it.
To make the InnoDB inserts to run as fast as possible:
1) Tune the buffer pool size and ib_logfile size as recommended at:
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
2) Set:
Patrick,
people have created files at least up to 500 GB using InnoDB's auto-extend
feature.
What does:
ulimit -a
say about the 'file size' of the user running mysqld?
Have you put some disk space quotas on the directories of the MySQL datadir?
Please correct me if I am wrong, but I think
Ravi,
please open a bug report at http://bugs.mysql.com and attach the COMPLETE
UNEDITED .err log to that bug report.
Looks like InnoDB accesses a page filled with zeros. This might be a
hardware fault or an OS bug, as well as an InnoDB bug.
Best regards,
Heikki
Oracle Corp./Innobase Oy
George,
- Original Message -
From: George Law [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, January 08, 2006 10:10 PM
Subject: allocate space for innodb innodb_file_per_table
Hi All,
I am running mysql 5.0.18 with a innodb table of 9 GB (plus several
others)
John,
this SQL statement:
INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT (
CUID
) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID
FROM `TV_LOG_ALL`
group by 2,3;
sets locks on all the records it scans in TV_LOG_ALL. If you have a small
buffer pool, then the InnoDB lock table may indeed
Carl,
InnoDB does purge deleted rows from the ibdata files. Certain PostgreSQL
advocates have been spreading a claim that InnoDB would not do that, but the
claim is false.
If your ibdata file keeps growing indefinitely, please check with SHOW
INNODB STATUS that you do commit all your
);
if (dyn_str)
{
my_free(dyn_str, MYF(0));
}
...
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 16, 2005 3:46 PM
Subject: Re: CPU 100% + crashes
Dilipan,
thank you.
I think there indeed is a slight unprotected access in:
0x8158a17 innobase_mysql_print_thd + 471
We will investigate if it has been fixed in 4.1.xx.
Again, SHOW INNODB STATUS\G shows a very light load inside InnoDB. You
would get more informative output if you would
Dilipan,
can you please post the complete .err log that also contains information
about the crashes. If there are stack traces, please resolve them.
The workload inside InnoDB does not look that big if what you have posted is
a typical SHOW INNODB STATUS\G. Is that the case?
What does
Mike,
thank you for the bug report. I have now opened:
http://bugs.mysql.com/bug.php?id=15758
Please add your comments there when you are able to determine the query that
is causing the error print.
Maybe enabling the MySQL General Query log would help?
Best regards,
Heikki
Oracle
Nathan,
you can use SHOW INNODB STATUS\G to monitor how many rows per second it is
inserting to the new, reorganized table.
If the workload is disk-bound, it may be as low as 100 rows per second. Then
inserting 20 million rows will take 2 days.
Best regards,
Heikki
Oracle Corp./Innobase
Jaime,
please post the COMPLETE UNEDITED .err log.
The log sequence number would mean that your InnoDB tablespace has not been
used after it was created:
051130 19:01:26 InnoDB: Started; log sequence number 0 43634
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row
Hi!
InnoDB does not work on a read-only file system. It needs to write to data
files and ib_logfiles. For example, the transaction id advances also with
SELECT queries, and we need to write it to the files.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level
on the nature of JBoss-MySQL transaction management will be
most helpful to us.
Thank you much in advance -
Noga
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Friday, November 18, 2005 2:56 PM
To: Noga Woronoff
Cc: Heikki Tuuri
Subject: Re: Regarding SET
of the file I assume that
when the MySQL-client session ends - the FK's checks is set back to 1.
I am turning my attention now to JBoss-MySQL EJB session management and
any advice will be greatly appreciated.
Regards -
Noga
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent
Hi!
Also look at
SHOW INNODB STATUS\G
during the slow phase.
What does it say about the 'Main thread ... state'?
What does it say about transactions?
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a
Aru,
Gleb is right. Best to upgrade to 4.0 or 4.1. In those versions InnoDB will
print the operating system error number and better diagnostics of the error.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup
Lee,
Gleb is right. Conceptually, MySQL 'locks' every table that it uses in a
SELECT query. The functions are ::store_lock() and ::external_lock(). But in
the case of InnoDB, those table locks are very weak, they do not block
anything.
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions,
Ed,
when I type 'make', it prints the text
make all-recursive
on the next line. I did not type that keyword 'all-recursive'. I guess it
means that gmake will recurse through certain directories and run make in
each of them, but I do not know.
Can some gmake expert please explain us what
Mike,
the opinions below are my personal opinions. They do not reflect the
official standpoint of Oracle Corporation.
- Original Message -
From: mos [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, November 07, 2005 12:51 AM
Subject: Re: Heikki: What will become
Ed,
what does
gcc --version
say? I am able to compile with gcc-3.3.1.
in ut0dbg.h we have:
#if defined(__GNUC__) (__GNUC__ 2)
# define UT_DBG_FAIL(EXPR) UNIV_UNLIKELY(!((ulint)(EXPR)))
#else
extern ulintut_dbg_zero; /* This is used to eliminate
compiler
Executive Vice President in charge of Database and Middleware Technology
says: Oracle intends to continue developing the InnoDB technology and
expand our commitment to open source software.
TIA
Mike
Regards,
Heikki Tuuri
Vice President, server technology
Oracle Corporation
--
MySQL General
Harry,
you have to commit your transaction. Otherwise it is rolled back when the
connection ends.
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: Harry Hoffman [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 02, 2005 10:48 PM
Subject:
All,
a fast COUNT(*) is in the TODO of InnoDB. But it is relatively difficult to
implement without reducing INSERT performance.
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: Jigal van Hemert [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday,
George,
is the utilization of both CPUs only 10 %? How big it is in the test with MS
SQL Server?
The workload is very much disk-bound if CPU usage is only 10 %.
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: yanghaifeng [EMAIL PROTECTED]
Newsgroups:
George,
there seem to be two bottlenecks:
1) InnoDB has contention on the buffer pool mutex;
2) the workload is also disk-read-bound.
For 1), we might have an improvement available in the future. We must let
the threads leave the 'wait array' in sync0arr.c without reserving the wait
array
Ady,
NO ACTION actually means the same as RESTRICT. That is, the foreign key
constraint is still enforced. The name 'NO ACTION' is from the SQL standard.
I agree that the name is confusing, but I cannot help it, because it is in
the standard.
Regards,
Heikki
Oracle/Innobase
- Original
Sunil,
in InnoDB, the maximum indexed column length is 767 bytes.
Osku is improving the error message:
http://bugs.mysql.com/bug.php?id=13315
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: Sunil Vishwas [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent:
George,
can you please post a few typical
SHOW INNODB STATUS\G
outputs during the stress test.
Best regards,
Heikki
Oracle/Innobase
- Original Message -
From: yang george [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, October 24, 2005 1:50 PM
Subject: How Can
Andrew,
how about using triggers to recompute materialized views? A challenge is to
write an automatic program that can compute the required triggers based on
the view definition. The materialized view would be a normal table. Triggers
would update it.
Regards,
Heikki
Oracle/Innobase
Shuming,
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
you have to specify the right size for:
innodb_log_file_size=14M
in your my.cnf or my.ini.
Please also check from:
C:\Program Files\MySQL\MySQL Server 4.1\data
how many ib_logfiles you have. If you have more than 2,
]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]; mysql@lists.mysql.com
mailto:mysql@lists.mysql.com
Lähetetty: Tuesday, October 18, 2005 4:39 AM
Aihe: RE: Non-linear degradation in bulk loads?
Side question: If I use a 64-bit MySQL build on a 64-bit kernel, is it
safe
Jon,
I do not know. Why not install a 64-bit Linux in your computer?
Regards,
Heikki
Oracle/Innobase
- Alkuperäinen viesti -
Lähettäjä: Jon Frisby [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED];
mysql@lists.mysql.com
Lähetetty: Monday, October 17, 2005 8:46 PM
Aihe
programs that occupy a few GB of
memory.
Regards,
Heikki
Oracle/Innobase
- Alkuperäinen viesti -
Lähettäjä: Jon Frisby [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED];
mysql@lists.mysql.com
Lähetetty: Monday, October 17, 2005 8:49 PM
Aihe: RE: Non-linear degradation
on the same =
box (from a local filesystem other than the one the InnoDB data pool was =
on, to NFS) caused MySQL to become COMPLETELY backlogged (we went from =
~15-20 connections at any given instant to 750 (our max_connections =
setting)).
-JF
-Original Message-
From: Heikki Tuuri
Jonathan,
http://dev.mysql.com/doc/refman/5.0/en/innodb-start.html
innodb_open_files
This option is relevant only if you use multiple tablespaces in InnoDB. It
specifies the maximum number of .ibd files that InnoDB can keep open at one
time. The minimum value is 10. The default is 300.
The
: Heikki Tuuri [EMAIL PROTECTED];
mysql@lists.mysql.com
Lähetetty: Wednesday, October 12, 2005 3:08 AM
Aihe: RE: Non-linear degradation in bulk loads?
Two solutions: 1) sort the rows to be inserted on the key
'email' before inserting.
2) Or:
http://dev.mysql.com/doc/mysql/en/innodb
Jon,
my guess is that the inserts to the UNIQUE secondary index cause the
workload to be seriously disk-bound.
Two solutions: 1) sort the rows to be inserted on the key 'email' before
inserting.
2) Or:
http://dev.mysql.com/doc/mysql/en/innodb-tuning.html
If you have UNIQUE constraints on
Fredrik,
- Original Message -
From: Fredrik Carlsson [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, October 10, 2005 9:57 PM
Subject: Question about innodb, ibdata1
Hi,
I'm using InnoDB with tablespaces for almost all tables. The last few
week the file ibdata1
Deva,
hmm... this is mysterious. This might also be an OS bug. If you have the
.err log from other crashes, please send it to [EMAIL PROTECTED]
Best regards,
Heikki Tuuri
Vice President, server technology
Oracle Corp.
- Original Message -
From: Devananda [EMAIL PROTECTED
-
From: Devananda [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 06, 2005 11:02 PM
Subject: Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)
Heikki Tuuri wrote:
Deva,
please post those transactions which have been active more than 800
seconds
, October 06, 2005 10:14 AM
Subject: Re: crashes in InnoDB with MySQL 4.1.14 (semaphore wait timeout)
Heikki Tuuri wrote:
Deva,
please post the complete output except the transaction data.
Regards,
Heikki
Please let me know if there is any additional data I can provide to help
resolve
1 - 100 of 1597 matches
Mail list logo