7 sec)
Records: 0 Duplicates: 0 Warnings: 0
root@sbtest 05:11:26>desc sb1;
ERROR 1146 (42S02): Table 'sbtest.sb1' doesn't exist
*3. different code between innodb and plugin*
3.1 innodb add err = DB_ERROR; before goto funct_exit; when
dict_table_rename_in_cache failed.
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
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 are
t; <[EMAIL 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 - an
[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
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
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&#
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=rss&url=http://www.infoworld.com/art
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, and it is
>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_
>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:
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
want configure the downloaded version from our bulid
and configure environment. (for example /mysql/obj/mysql-3.23.55).
We take the ./configure from the obj-Directory-Path:
/mysql/src/mysql-3.23.55/configure --with-innodb (to have Innobase
DB support).
After we take the make command we become some
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
Subje
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
> Su
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 opera
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, et
e,
or it removes 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 t
>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/con
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 for
my experience is that old bugs do not reappear. 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 switche
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. Zawodn
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, col2 SMALLINT
>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 NO
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 DOES
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 lo
id = $groupid AND m.parentmsgid = 0
AND m.clean = 1 ORDER BY postdate DESC limit 50;
and also:
SELECT * FROM users WHERE username = LOWER('xxx') AND password =
PASSWORD('xxx')
In both cases the connection is using auto commit = 1... so I dont think it
can be a deadlock problem. I
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
(Inno
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
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 and
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
>
> 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
l hours long, conversion 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
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
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, and
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 for
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
>
>>--=-jUldtxkxbNmI4+gJVNJEContent-Type: text/plain; charset=ISO-8859-1
>>
nME:
>
>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. Abor
er for me 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
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
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 fi
og files 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 = /
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
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 re
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 ar
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 restrictio
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
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
confirmation one way or the other that I had innobase support
> compiled in).
>
> have_bdbYES
> have_gemini NO
> have_innodb NO
>
> The first two are as expected, the third isn't. However, this is
> with a mysqld that was configured with --with-inno
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,
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
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 rea
kki
[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
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
MARY KEY (id),
> KEY id_bourse (bourse),
> KEY id_date (date)
>) TYPE=Innobase;
>
>mysql> desc mybuffer;
>+-+--+--+-+-+--
--+
>| Field | Type | Null | Key | Default | Extra
|
>+---
'',
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 mybuffer;
+-+--+--+-+-++
| Field
>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:
ut is from 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@loca
QL website. 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 (= Innoba
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&#
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 do
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)
To
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
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 in the SQL parser. Miguel's query on Win NT perhaps worked
because the
>HT> optimizer there chose another access path a
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&g
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 p
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 :
>
&g
00) not null,
-> index id_lib (libelle(1))
-> ) 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 |
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
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]>
Tec
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
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 i
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
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
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
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
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
-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
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 becaus
are welcome 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
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
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 (t
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
'
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
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
> >> -DDATADIR="\"/usr/local/mysql/var\""
> >> -DSHAREDIR="\"/usr/local/mysql/share/mysql\""
> >> -DHAVE_CONFIG_H -I../bdb/build_unix
> >> -I../inno
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 t
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 so
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 in the setting from the 8.7.2
rt
>records one at a time with no problem, but if I 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
ting records dies 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&
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 will
/usr/local/mysql/var\""
> -DSHAREDIR="\"/usr/local/mysql/share/mysql\""
> -DHAVE_CONFIG_H -I../bdb/build_unix
> -I../innobase/include
> -I./../include -I./../regex
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 abo
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
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
bina
en wrote:
>>
>> I've got a reproducable 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
>> co
gt;
Cc: "Arne Claassen" <[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
Please unsubscribe me from the list.
-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 10:35 AM
To: [EMAIL PROTECTED]
Cc: Arne Claassen; Heikki Tuuri; [EMAIL PROTECTED]
Subject: Re: Signal 11 on Innobase table range queries
Hi
Hi!
>>>>> "Jeremy" == Jeremy D Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Sun, Mar 25, 2001 at 09:52:22PM -0800, Arne Claassen wrote:
>>
>> I've got a reproducable signal 11 death in mysqld using Innobase
>> tables and range qu
1 - 100 of 201 matches
Mail list logo
