goto funct_exit; when
dict_table_rename_in_cache failed.
3.2 test innodb work and result could be refered to modified innodb plugin
just like innobase behavior, add err = DB_ERROR; before exit
3905 if (!dict_table_rename_in_cache(table, new_name,
3906
yet just another multi-national gupling up its competitors, i stumbled
across this blog
http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
innodb.html and had no idea, its just as bad the the latest Eola patent
case against microsoft and others its getting out of hand. What
Dan Rossi [EMAIL PROTECTED] wrote on 03/07/2006 05:47:41 AM:
yet just another multi-national gupling up its competitors, i stumbled
across this blog
http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
innodb.html and had no idea, its just as bad the the latest Eola patent
Hi MySQL fans,
I just read in the news about Innobase being sold to Oracle.
Does anybody know whats going on with Innobase and what impact the selling out
to Oracle might have on MySQL ?
http://www.infoworld.com/article/05/10/12/HNnewmysql_1.html?source=rssurl=http://www.infoworld.com/article/05
Hi Valentin, all!
[EMAIL PROTECTED] wrote:
Hi MySQL fans,
I just read in the news about Innobase being sold to Oracle.
Correct.
Does anybody know whats going on with Innobase and what impact the selling out
to Oracle might have on MySQL ?
What Oracle will do with Innobase is Oracle's
What Oracle will do with Innobase is Oracle's matter, not much use in
speculating about that IMO.
Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED how the
environment around Innobase / Innodb will change - and with it any support
options and other impacts that might have
[EMAIL PROTECTED] wrote:
speculating about that IMO.
What Oracle will do with Innobase is Oracle's matter, not much use in
Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED
how the
environment around Innobase / Innodb will change - and with it any
support
options
PROTECTED]:
[EMAIL PROTECTED] wrote:
speculating about that IMO.
What Oracle will do with Innobase is Oracle's matter, not much use in
Sorry, I am going to disagree with that ;-), I am VERY WELL INTERESTED
how the
environment around Innobase / Innodb will change - and with it any
support
options
Innobase Oy declares MySQL/InnoDB-4.1 stable
Innobase Oy has decided to declare MySQL/InnoDB-4.1 stable and recommended
for all production use, starting from version 4.1.10. MySQL/InnoDB-4.1 has
been out for almost two years now, there have been millions of downloads of
the software
Description:
If configuring with --with-innobase and non-standard configure flags (like
--enable-maintainer-mode), those flags are not passed to the configure
run in the innobase subdirectory. Since the sub-configure is run with many
variables in the environment (see innobase/config.status sub
Description:
Performing a VPATH build on Solaris 8/SPARC with innobase support and
the previously reported VPATH build problem (no -I options for $srcdir) fixed
by editing the generated innobase Makefiles adding -I$(srcdir)/../../include
-I$(srcdir)/../include to INCLUDES proceeds, but fails
Description:
Performing a VPATH build with innobase support included fails since the
innobase headers in $(top_srcdir)/innobase/include are not found:
gcc -DHAVE_CONFIG_H -I. -I/vol/mysql/src/mysql/dist/mysql-3.23.55/innobase/os -I..
-I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF
)
After that we want configure the downloaded version from our bulid
and configure environment. (for example directory/mysql/obj/mysql-3.23.55).
We take the ./configure from the obj-Directory-Path:
directory/mysql/src/mysql-3.23.55/configure --with-innodb (to have Innobase
DB support).
After we take
Nicholas,
- Original Message -
From: Nicholas Gaugler [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 09, 2002 8:22 AM
Subject: mysqld Threads with Innobase
I know it's not very important in normal day to day operations, but does
anyone know what each
stupid question ]
Owen
On Wed, 2002-10-09 at 02:55, Heikki Tuuri wrote:
Nicholas,
- Original Message -
From: Nicholas Gaugler [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 09, 2002 8:22 AM
Subject: mysqld Threads with Innobase
I know it's not very
Owen,
- Original Message -
From: Owen Scott Medd [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Nicholas Gaugler [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 5:44 PM
Subject: Re: mysqld Threads with Innobase
[ start stupid question ]
Does setting
I know it's not very important in normal day to day operations, but does
anyone know what each thread does within mysqld with Innobase installed?
It'd be nice to know what Innobase is doing when a process is pinned at 100%
of the cpu..if it's doing cleanup from a huge update, etc.
1655 ttyp1
the generated code from the archives.
An easy way to fix the problem is to add
#define UNIV_MUST_NOT_INLINE
to /mysql/innobase/include/univ.i
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
Description:
While attempting to build mysql with Innobase, the final link step
encounters hundreds (thousands?) of undefined references such as:
../innobase/srv/libsrv.a(srv0srv.o): In function `srv_get_n_threads':
/home/wbarber/flow/contrib/mysql-3.23.51
Does anyone know how Innobase would handle this query? If it would lock all
of the rows within the table, or attempt to find all of the rows within the
table instead of just finding the first X in my LIMIT and locking those and
updating those? I have a table with 1 million rows as my example
Innobase Oy declares MySQL/InnoDB-3.23 stable starting from version 3.23.49.
Helsinki, February 28, 2002
Innobase Oy has decided to declare MySQL/InnoDB-3.23 officially stable
starting from the version 3.23.49. InnoDB tables are included in the
MySQL-Max-3.23 distribution which is available
. It is
completely new bugs which are introduced into the source
code when new code is written. Randomized stress tests will
catch some of new bugs.
There is a lot of validation and assertion code when you compile
InnoDB with the debug options switched on in
/innobase/include/univ.i. Then InnoDB spends
Description:
Using the following statement on empyt innobase tables crashes the
MySQL-Server:
select MAX(col3) from crashTable where col1 = 1 and col2 = 7;
How-To-Repeat:
CREATE TABLE IF NOT EXISTS crashTable (
col1 SMALLINT UNSIGNED NOT NULL
innobase tables crashes the
MySQL-Server:
select MAX(col3) from crashTable where col1 = 1 and col2 =7;
How-To-Repeat:
CREATE TABLE IF NOT EXISTS crashTable (
col1 SMALLINT UNSIGNED NOT NULL, col2 SMALLINT
UNSIGNED NOT
NULL,
col3
On Tue, Oct 23, 2001 at 01:43:32PM +0300, Heikki Tuuri wrote:
Hi!
Thank you for a detailed bug report. This bug is already fixed in
the source release 3.23.43b available from http://www.innodb.com
Is there now a test case for it in the MySQL test suite, too?
Jeremy
--
Jeremy D. Zawodny,
Hello,
I am using Innobase with MySql version 3.23.39 under Linux
and want to run WITHOUT autocommit mode
(= autocommit=0 for using commit/roolback instructions)
I have made a test whith 2 INTERACTIVE MySql sessions and this works fine.
BUT, when I use the C API (mysql_real_query), it DOESN't
As stated on the bugs and fixes page on http://www.innodb.com/bugfixes.html
there is a problem with the latest innodb code that causes corruption when
doing updates... I believe I have run into that problem... First mysql would
hang.. and do nothing. After killing it and restarting it the error
that inserts have not been
done to either table in a while (a while being a day or so). Below are the
create table definitions just in case you need to take a look at them. Do
you have any idea what could be causing this? Under the non-large blob
support innobase code this worked without any problems
Hi,
I can't *link* MySql on my HP-UX box due a linkage problem:
../innobase/lock/liblock.a ../innobase/mtr/libmtr.a
../innobase/page/libpage.a
../innobase/rem/librem.a ../innobase/thr/libthr.a
../innobase/com/libcom.a ../innobase/sync/libsync.a
../innobase/data/libdata.a ../innobase/mach
Andre,
I have not seen that problem before. Maybe you could
try to add
export CFLAGS=+Z
to your configure lines. Look that it actually compiles
InnoDB files with the +Z option, whatever it means.
Actually it may be enough
to do the configure only in mysql/innobase directory
(InnoDB has its
support of InnoBase DB files. During the build process I must use the
HP/ANSI compilers. This causes an error while building the mach0data.c file
in the mach directory in the InnoBase directory structure.
Has anyone on HP-UX 11.0.0 been able to build the MySQL server with both
Berkeley DB
I have had problems building the MySQL database server when I include
support of InnoBase DB files. During the build process I must use the
HP/ANSI compilers. This causes an error while building the mach0data.c file
in the mach directory in the InnoBase directory structure.
Has anyone on HP-UX
at once.
Regards,
Heikki
http://www.innodb.com
Copied message:
.
On Sat, Jul 14, 2001 at 11:12:21PM -0500, ryc wrote:
I have a table that were created using innobase compiled with 64kb
page tables. Now I want to upgrade to the newer version of innobase
that supports
Note that the new BLOB code is not well tested yet, though
I have not received any bug reports for it. It may be best to
experiment first with pieces of your table instead of doing
the whole, maybe several hours long, conversion at once.
Can you tell us a bit more about the BLOB code?
I have a table that were created using innobase compiled with 64kb page
tables. Now I want to upgrade to the newer version of innobase that supports
the larger row sizes but as it mentions on the innobase .39b download page
( http://www.innodb.com/download.html ) I must export the tables
On Sat, Jul 14, 2001 at 11:12:21PM -0500, ryc wrote:
I have a table that were created using innobase compiled with 64kb
page tables. Now I want to upgrade to the newer version of innobase
that supports the larger row sizes but as it mentions on the
innobase .39b download page ( http
Keep in mind the version of innobase that I am using is compiled with a page
size of 64k.
I have a table of 10million rows (give or take, select count(*) from
tablename is slow for innobase tables so I dont do it often). Everyday I
need to run a query that selects rows that are marked
Got the following message after starting mysqld on WinME:
Innobase: Assertion failure in thread 4294849841 in file
M:\mysql-3.23\innobase\
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED]
010517 9:07:55 C:\MYSQL\BIN
to track the insert buffer bug.
Regards,
Heikki Tuuri
Innobase Oy
--=-jUldtxkxbNmI4+gJVNJEContent-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,
I'm trying to load a large table with 7 million records, 50 columns and
27 indexes into an innodb table. Works fine
:
Innobase: Assertion failure in thread 4294849841 in file
M:\mysql-3.23\innobase\
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED]
010517 9:07:55 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting!
010517 9:07:55 Aborting
INTO innodbtable SELECT myisamtable WHERE yourkey something
AND yourkey something-else;
If you could email me the CREATE TABLE you use for the InnoDB table,
it would be easier for me to track the insert buffer bug.
Regards,
Heikki Tuuri
Innobase Oy
a 1.5GB.
From /etc/my.cnf:
#
# Innobase options
#
innodb_data_file_path =
vol1/ibdata/ibdata00:1024M;vol2/ibdata/ibdata01:1024M;vol1/ibdata/ibdata02:1024M;vol2/ibdata/ibdata03:1024M;vol1/ibdata/ibdata04:1024M;vol2/ibdata/ibdata05:1024M
innodb_data_home_dir = /
set-variable
On Wed, May 16, 2001 at 10:58:18PM +0200, Frank Schroeder wrote:
Is there a way of turning the transactional logging off during the
load of a table? I know that I'm out on my own then but this table
is loaded only every once in a while.
Am I running out of space on the log/or data files?
On Sun, May 13, 2001 at 06:09:12PM +0300, Heikki Tuuri wrote:
Suggested improvements would be the addition of COALESCE TABLESPACE
Do you mean reorganization and compaction of a tablespace? The way to
do it is to dump and reload all tables in the tablespace.
During my tests I've
Dan,
At 03:02 PM 5/11/01 -0500, you wrote:
In the last episode (May 11), Heikki Tuuri said:
Dan Nelson wrote:
No ANALYZE TABLE - correct key and subkey cardinality counts work
wonders for complex queries (probably easy to add).
InnoDB does the estimation of cardinalities required by
Hi!
In the last episode (May 10), Eric J. Schwertfeger said:
Also, my initial testing shows that INNOBASE tables are even faster
than MyISAM, at least for insertions, though the same tupples in a
similar table seem to take up more room. Aside from the restrictions
InnoDB tables are faster
In the last episode (May 11), Heikki Tuuri said:
Dan Nelson wrote:
No ANALYZE TABLE - correct key and subkey cardinality counts work
wonders for complex queries (probably easy to add).
InnoDB does the estimation of cardinalities required by the MySQL
optimizer. But the counts are not
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and I've
run into something unusual.
Basically, when I create a table with type = innobase then do a stat on
the table, it returns a table type of MyISAM. I've verified that this is
what the table really is by looking
On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote:
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and
I've run into something unusual.
Basically, when I create a table with type = innobase then do a
stat on the table, it returns a table type of MyISAM
On Thu, 10 May 2001, Jeremy Zawodny wrote:
On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote:
I'm trying to get INNOBASE tables working with MySQL on FreeBSD and
I've run into something unusual.
Basically, when I create a table with type = innobase then do
On Thu, 10 May 2001, Dan Nelson wrote:
The first two are as expected, the third isn't. However, this is
with a mysqld that was configured with --with-innobase. So why is
have_innodb=NO?
The name of the option changed in 3.23.37. Use --with-innodb instead.
Never trust printed
In the last episode (May 10), Eric J. Schwertfeger said:
Also, my initial testing shows that INNOBASE tables are even faster
than MyISAM, at least for insertions, though the same tupples in a
similar table seem to take up more room. Aside from the restrictions
mentioned in 8.7.4
datetime NOT NULL default '-00-00 00:00:00',
data text,
PRIMARY KEY (id),
KEY id_bourse (bourse),
KEY id_date (date)
) TYPE=Innobase;
mysql desc mybuffer;
+-+--+--+-+-++
| Field | Type | Null | Key
mybuffer (
id int(10) unsigned NOT NULL auto_increment,
bourse char(3) NOT NULL default '',
service varchar(10) NOT NULL default '',
date datetime NOT NULL default '-00-00 00:00:00',
data text,
PRIMARY KEY (id),
KEY id_bourse (bourse),
KEY id_date (date)
) TYPE=Innobase;
mysql desc
Heikki,
HT can you print the EXPLAIN SELECT ... for the count(*) and the other query?
mysql explain select count(*) from mybuffer where bourse='NAS';
+--+--+---+---+-+---+--+-+
| table| type | possible_keys | key
[EMAIL PROTECTED], 2001-05-09 23:06:52+03:00, [EMAIL PROTECTED]
row0sel.c Fix a bug in consistent read through secondary key
innobase/row/row0sel.c
1.6 01/05/09 23:06:34 [EMAIL PROTECTED] +4 -2
Fix a bug in consistent read through secondary key
Description:
My disc was full when I tried to restart mysql. The error log filled up
with:
Innobase encountered a problem with file /var/lib/mysql/ib_logfile0.
Disk is full. Try to clean the disk to free space
before answering the following: How
Hi,
I'm using two Mysql 3.23.36 with Innobase tables on two machines running
Redhat 7.0.
I'm trying to use replication in a simple master/slave configuration,
but while it works
when I use MyIsam tables, if one of the two machines tries to use
Innobase tables
the replication doesn't work
Nico,
does the table you are trying to replicate contain rows
with more than 8000 bytes of data?
InnoDB (= Innobase) cannot store longer rows. Arbitrary length BLOB and TEXT
fields are on the TODO list for June 2001.
Does the slave hang also for other queries you try to do
on the slave's
. The Wisconsin bug and also other bugs
in connection with signal handling and setting of thread priorities
have been fixed there.
Regards,
Heikki
Nico,
does the table you are trying to replicate contain rows
with more than 8000 bytes of data?
InnoDB (= Innobase) cannot store longer rows
3.23.34 on Win NT, where I was able
to get replication working for InnoDB, but 'load table from master'
failed.
.
Innobase: Started
mysqld: ready for connections
010419 20:46:21 Slave thread initialized
010419 20:46:22 Slave: connected to master 'repl@localhost:3306', replication
Easter,
Heikki Tuuri
Innobase Oy
(Bait for the mailing list spam filter: SQL, MySQL)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Hi!
To avoid mixing to a German company Innobase AG, we are changing the
name of the product Innobase to InnoDB in 3.23.37.
- In my.cnf you have to change the parameter names innobase_...
to innodb_...
- The SQL parser in 3.23.37 will still know the table type innobase, but
before July 15
Bonjour,
We found a bug in INNOBASE tables with col_name(length) indexes.
Here is the table :
create table test (
symbole char(20) not null primary key,
libelle char(100) not null,
index id_lib (libelle(1))
) TYPE=INNOBASE;
For the test I insert one row but there can be many
))
- ) TYPE=INNOBASE;
Query OK, 0 rows affected (0.06 sec)
mysql insert into test values('A','ABCDEF');
Query OK, 1 row affected (0.03 sec)
mysql select * from test;
+-+-+
| symbole | libelle |
+-+-+
| A | ABCDEF |
+-+-+
1 row in set (0.00
Bonjour,
Sorry I mistyped the version of Mysql with which we have the bug.
It's Mysql-3.23.36 with patch correcting Solaris and other non Linux
Unix problem.
We found a bug in INNOBASE tables with col_name(length) indexes.
Here is the table :
create table test (
symbole
Hi!
Innobase does not support partial-field indexes. We have to block their
usage in the SQL parser. Miguel's query on Win NT perhaps worked because the
optimizer there chose another access path and did not use the partial-field
index.
But thank you Alex, we have to block them in the parser
Heikki,
Could you please tell me (and add in the manual perhaps) if this is
a planned enhancement or not and if it's planned, if it will be
added in a long or a short delay.
Thanks,
Alex.
HT Innobase does not support partial-field indexes. We have to block their
HT usage
does mysql binary win32 dist support innobase and bdb tables.
if yes how ?
if not when will you implement?
database.
Yusuf Incekara
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
this is a stupid robot :)
my message was not off topic
- Original Message -
From: [EMAIL PROTECTED]
To: Avukatpro Limited Sirketi [EMAIL PROTECTED]
Sent: Tuesday, April 10, 2001 12:09 AM
Subject: Re: About BDB and INNOBASE
Your message cannot be posted because it appears to be either
Hi!
We are working on a binary release of MySQL -MAX with BDB and
Innobase. At least on Linux and Win NT.
I would not be surprised if it comes this week, though
I am not responsible for building it :).
Regards,
Heikki Tuuri
Innobase Oy
On Tue, Apr 10, 2001 at 12:37:10PM +0300, Yusuf Incekara wrote:
does mysql binary win32 dist support innobase and bdb tables. if
yes how ? if not when will you implement?
I don't think Innobase is availabe on Windows yet.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo
Hi!
The MySQL manual says that INSERT DELAYED only works for MyISAM
and ISAM tables, but the parser does not check that the table type
is correct. We have to block this in the parser.
If you use it on Innobase tables, that can cause several database
corruption!
Regards,
Heikki Tuuri
Innobase
Hi!
The MySQL manual says that INSERT DELAYED only works for MyISAM
and ISAM tables, but the parser does not check that the table type
is correct. We have to block this in the parser.
If you use it on Innobase tables, that can cause severe database
corruption!
Regards,
Heikki Tuuri
Innobase
On Fri, Apr 06, 2001 at 07:26:14PM +0300, Heikki Tuuri wrote:
Hi!
The MySQL manual says that INSERT DELAYED only works for MyISAM
and ISAM tables, but the parser does not check that the table type
is correct. We have to block this in the parser.
If you use it on Innobase tables, that can
to modify and redistribute it under the GPL license
Starts the MySQL server
Usage: /opt/mysql/libexec/mysqld [OPTIONS]
--ansiUse ANSI SQL s.
snip
After removing the /etc/my.cnf file the server starts sucessfully, but without
initializing the innobase stuff because the necessary
the /etc/my.cnf file the server starts sucessfully, but without
initializing the innobase stuff because the necessary pathes/variables are not
set.
Okay, second I tried, sucessfully, to start mysqld manually with the
following commandline
/opt/mysql/libexec/mysqld --user=mysql --basedir
-variable = innobase_lock_wait_timeout=50
After first starting mysql with the start.server script innobase create the
necessary files in the /opt/mysql/var directory but than it ends up with a
memory fault.
.err:
010405 16:45:39 mysqld started
Innobase: The first specified data file /opt/mysql/var
Andre,
innobase_log_arch_dir should be the same as innobase_log_group_home_dir.
Now there is an extra 'mysql' in the path. You probably do not
have that directory existing, and Innobase asserts a failure.
I am sorry, I will change the assert to an error message in the next release,
but have
Hi,
I dowloaded and installed the source distr 3-23-36 for Solaris, and tested
the BDB+INNOBASE features.
I tried to do the same for NT-Win2000, but the source 3-23-36 seems not
include the BDB+INNOBASE sources!
if (this si true)
How we can bypass that?
else
where the sources
executing pthread_mutex_trylock on a
reserved pthread mutex.
In long operations in Innobase these pthread mutex collisions occurred,
and the spinning started.
The fix is the following. Edit mysql/innobase/sync/sync0sync.c and
add line
i++;
on line 369 in the file. I.e., just before the line
'if (i
Paolo Michetti writes:
Hi,
I dowloaded and installed the source distr 3-23-36 for Solaris, and tested
the BDB+INNOBASE features.
I tried to do the same for NT-Win2000, but the source 3-23-36 seems not
include the BDB+INNOBASE sources!
if (this si true)
How we can
Hi!
Alex Baumeister reported a couple of days ago that Innobase is
slow when a big DELETE is concurrent with UPDATES.
The bug can cause slowing down several database operations
on non-Linux platforms.
You have to edit mysql/innobase/os/os0thread.c.
About on line 140 it is now
SHAREDIR="\"/usr/local/mysql/share/mysql\""
-DHAVE_CONFIG_H -I../bdb/build_unix
-I../innobase/include
-I./../include -I./../regex-I.
-I../include -I.. -I.-O3 -DDBUG_OFF -O3 -fomit-frame-pointer
-fno-implicit-template
In the last episode (Apr 02), Leonard Coonan said:
I am trying to install Mysql (3.23.36) on windows NT. I have
installed the software, but cannot find how to use the Innobase table
structure. Can someone please point me in the right direction (apart
from installing it on something else
Leonard Coonan writes:
I am trying to install Mysql (3.23.36) on windows NT. I have installed the
software, but cannot find how to use the Innobase table structure. Can
someone please point me in the right direction (apart from installing it on
something else). I have tried putting
try to update more than
~250 records at a time, it hangs, consuming 100% cpu. gdb'ing a corefile of
the process, it looks like a mutex/spinlock problem of some sort.
Deleting records dies if I delete between 100 and 150 records in one
go. Does innobase create a mutex for each record processed
;
-DSHAREDIR="\"/usr/local/mysql/share/mysql\""
-DHAVE_CONFIG_H -I../bdb/build_unix
-I../innobase/include
-I./../include -I./../regex-I.
-I../include -I.. -I.-O3 -DD
commit
after the insert batch, or a few commits along the way.
I understand you measured several times, doing DELETE FROM TABLE in between.
Innobase uses some CPU to physically remove the delete marked records in
a purge operation. DROP TABLE and TRUNCATE TABLE (in MySQL-4.0) are faster.
I
if I delete between 100 and 150 records in one
go. Does innobase create a mutex for each record processed? Maybe
there's a limit on 256 held mutices per thread on FreeBSD or something.
-- mysqld hung on "insert into temp (value) select ip from iptable limit 300":
(gdb) thread apply all bt
SHAREDIR="\"/usr/local/mysql/share/mysql\""
-DHAVE_CONFIG_H -I../bdb/build_unix
-I../innobase/include
-I./../include -I./../regex-I.
-I../include -I.. -I.-O3 -DDBUG_OFF -O3 -fomit-frame-pointer
-fno-implicit-templa
Hi everybody, I have run a few test for innobase tables on linux and BSD
1. It seems that 'innobase' table was slower than 'bdb' table for 'insert' command,
which is surprising(or not? o_O)
2. It may be due to that fact that I dont' know much about optimazing the 'innobase'
table
Sorry to keep harping on this, but back when 3.23.34 was released, there was
a line in the release notes that claimed that binary distributions with BDB
and InnoBase would be tackled "next week".
Has there been any progress on this front? I'm most interested in the Win32
binary di
laassen" [EMAIL PROTECTED]; "Heikki Tuuri"
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 26, 2001 4:05 PM
Subject: Re: Signal 11 on Innobase table range queries
Hi!
"Jeremy" == Jeremy D Zawodny [EMAIL PROTECTED] writes:
Jeremy On Sun, Mar 25, 2001
signal 11 death in mysqld using Innobase
tables and range queries (at least reproducable on my machine,
Redhat 6.2, mysql 3.23.35).
Here's how it manifests itself: Create a table with at least 32
columns. Then load a row or two into the table and try to do any
query using a range (, , between
Hi!
I have completed the writing of the new Innobase manual. It will
also appear as a section in the MySQL manual.
Best regards,
Heikki Tuuri
Innobase Oy
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi!
I posted an incomplete Innobase manual at my website. I will
be updating it daily as the writing progresses.
Best regards,
Heikki Tuuri
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Alex,
yes, SHOW TABLE STATUS returns only approximate statistics about the
row count for Innobase tables. These statistics are used in the SQL
optimization.
From section 8.7 in the MySQL manual:
...snip
SHOW TABLE STATUS FROM TEST LIKE 'CUSTOMER'
if you have created
Readers of the mailing list,
when I was writing about recovery in the upcoming Innobase manual,
I realized that a logical log used in MySQL in the roll-forward recovery
from a backup does not work properly. The problem is that
the log does not contain enough information on the snapshot
Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 17, 2001 8:20 AM
To: [EMAIL PROTECTED]
Subject: Re: INNOBASE
Cal,
I will write more documentation during the week beginning 19th of
March, and post that to my website at www.innobase.fi. It will
also appear in the MySQL
1 - 100 of 176 matches
Mail list logo