Bryan Cantwell wrote:
I have Mysql 5.0.45 using innodb tables.
Occasionally, I get corrupted tables. I can go into Mysql administrator
gui and see the bad table and I can repair the index or whatever is
wrong from the gui.
I need a command line way to periodically detect for issues and if it
find
Depending on the version you use MySQL will see a definition of
varchar(25) as 25 bytes or 25 characters. I believe this changed from
4.1 to 5.0 respectively but I am not sure.
THis could be the root of the problem
Boyd
CONFIDENTIALITY NOTICE: This email & attached documents may conta
On 3/26/07, Anil D <[EMAIL PROTECTED]> wrote:
Varchar = 0 bytes
I don't think this is right, see below.
Charset used: UTF8
UTF8 means that some characters may be two bytes, see below.
Note: When consider even the size Varchar(m) = m+1 bytes, the size of row
has reached 35,000 bytes.
Resend,
Anybody please give me information about different insert performance
between MySQL 5.0.18 and MySQL 4.1.18
as my posting at
http://forums.mysql.com/read.php?22,74279,74279
Thank your
Heikki
Please see my testing result on MySQL Forum
http://forums.mysql.com/read.php?22,74279,7427
Heikki
Please see my testing result on MySQL Forum
http://forums.mysql.com/read.php?22,74279,74279#msg-74279
I need explanation about this issue :)
Heikki Tuuri wrote:
Ady,
- Original Message - From: "Ady Wicaksono"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Mo
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?
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: Inno
Ok greg,
I'll report this bug
Thx
Greg 'groggy' Lehey wrote:
On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote:
I have MySQL with about 12 billion rows when i try to create 2
process, each select count(*) on the same table after a long
time about 30 minutes it crash
On Wednesday, 16 November 2005 at 20:40:35 +0700, Ady Wicaksono wrote:
> I have MySQL with about 12 billion rows when i try to create 2
> process, each select count(*) on the same table after a long
> time about 30 minutes it crashed :(
>
> ANy information?
>
> ...
>
> InnoDB: We intentionally
Dear All
It happens after these condition
InnoDB: ## Diagnostic info printed to the standard error stream
InnoDB: Warning: a long semaphore wait:
--Thread 1103972416 has waited at ../include/btr0btr.ic line 28 for
369.00 seconds the semaphore:
S-lock on RW-latch at 0x88cdd6b8 created in fi
Hi,
the only right answers sould be here :
http://www.mysql.com/company/legal/licensing/
Mathias
Selon Daniel Kiss <[EMAIL PROTECTED]>:
> Hi All,
>
> I would have a question about licensing MySQL.
>
> I am writing an application that relies on MySQL+InnoDB (uses MySQL as a
> database backend).
Hi,
the only right answers sould be here :
http://www.mysql.com/company/legal/licensing/
Mathias
Selon Daniel Kiss <[EMAIL PROTECTED]>:
> Hi All,
>
> I would have a question about licensing MySQL.
>
> I am writing an application that relies on MySQL+InnoDB (uses MySQL as a
> database backend).
This has never arrived :
Hi,
the only right answers sould be here :
http://www.mysql.com/company/legal/licensing/
Mathias
>
> Selon Daniel Kiss <[EMAIL PROTECTED]>:
>
> > Hi All,
> >
> > I would have a question about licensing MySQL.
> >
> > I am writing an application that relies on MySQL+In
Asad,
InnoDB type tables have enforced FOREIGN KEY constraints since 2001.
Unfortunately, none of the table types of MySQL yet supports CHECK
constraints.
Best regards,
Heikki
.
List: mysql
Subject:Re: MySQL/InnoDB-4.1.10 is released
From: Asad Habib
Date
Are foreign key and other constraints enforced by the db server in this
version or is this something that the programmer has to ensure via
application logic?
- Asad
On Tue, 15 Feb 2005, Heikki Tuuri wrote:
> Hi!
>
> InnoDB is the MySQL table type that supports foreign keys, transactions,
> non-
Nick,
- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, January 14, 2005 9:28 PM
Subject: Re: MySQL/InnoDB-4.1.9 is released
Heikki Tuuri wrote:
http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html
"
The co
Heikki Tuuri wrote:
http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html
"
The correct way to use LOCK TABLES with transactional tables, like
InnoDB, is to set AUTOCOMMIT = 0 and not to call UNLOCK TABLES until
you commit the transaction explicitly. When you call LOCK TABLES,
InnoDB internally tak
Nick,
- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, January 14, 2005 7:39 PM
Subject: Re: MySQL/InnoDB-4.1.9 is released
Heikki Tuuri wrote:
* Do not acquire an internal InnoDB table lock in LOCK TABLES
Heikki Tuuri wrote:
* Do not acquire an internal InnoDB table lock in LOCK TABLES if
AUTOCOMMIT=1. This helps in porting old MyISAM applications to InnoDB.
InnoDB table locks in that case caused very easily deadlocks.
Could you explain a bit more about how this relates to MyISAM? Is it
just tha
Walt,
- Original Message -
From: "kernel" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, December 02, 2004 11:01 PM
Subject: Re: MySQL/InnoDB-5.0.2 is released
"MySQL to return wrong results if a SELECT uses two indexes at the same
time&qu
"MySQL to return wrong results if a SELECT uses two indexes at the same
time"
Does mysql 5.0.x have the ability to use more than one index per table
on a select ? We had to rewrite a simple
"select id from table_a where last_name like 'smith%' and first_name
like 'john%'"
to
"select id from
Nickolai,
this very much sounds like a hardware fault. No MySQL or InnoDB bug should
be able to freeze the WHOLE operating system. And SELECT ... INTO OUTFILE
... is a very basic operation in the database.
Regards,
Heikki
- Original Message -
From: ""Nickolai Nielsen"" <[EMAIL PROTECTE
Milan Svrlo <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'd ask you :
> Can I use in MySQL 4.x on InnoDB tables something like :
> create dump from this InnoDB tables with cascade INSERT sql statements
> based foreign keys ?
> And if yes, how ?
>
No.
Probably you need mysqldump and SET FOREIGN_KEY_CHE
On Tue, May 18, 2004 at 10:56:14PM +0200, Mark wrote:
> Mihail Manolov wrote:
>
> >>> Release 4.0.20 is mainly a bugfix release, but there are also some
> >>> important functional changes. Release 4.0.19 was completely skipped
> >>> over because Bug #3596 might have caused segmentation faults on s
Mihail Manolov wrote:
>>> Release 4.0.20 is mainly a bugfix release, but there are also some
>>> important functional changes. Release 4.0.19 was completely skipped
>>> over because Bug #3596 might have caused segmentation faults on some
>>> platforms. The changelog below lists all the changes sin
i" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, May 18, 2004 2:21 PM
Subject: Re: MySQL/InnoDB-4.0.20 is released
> Heikki Tuuri wrote:
>
> > Release 4.0.20 is mainly a bugfix release, but there are also
some
> > important fu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark wrote:
| Heikki Tuuri wrote:
|
|
|>Release 4.0.20 is mainly a bugfix release, but there are also some
|>important functional changes. Release 4.0.19 was completely skipped
|>over because Bug #3596 might have caused segmentation faults on some
|>pla
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark wrote:
| Heikki Tuuri wrote:
|
|
|>Release 4.0.20 is mainly a bugfix release, but there are also some
|>important functional changes. Release 4.0.19 was completely skipped
|>over because Bug #3596 might have caused segmentation faults on some
|>pla
Heikki Tuuri wrote:
> Release 4.0.20 is mainly a bugfix release, but there are also some
> important functional changes. Release 4.0.19 was completely skipped
> over because Bug #3596 might have caused segmentation faults on some
> platforms. The changelog below lists all the changes since 4.0.18.
On Fri, 16 Apr 2004, mayuran wrote:
> I would like to optimize the configuration settings
> for this beast of a machine, here are the specs:
>
> Quad Xeon 3ghz (4x2 = 8 cpus), 512 cache
> 16 gigs ram
> running Redhat Enterprise 3.0 AS
> All tables are InnoDB.
>
> I read this warning in the MySQL d
Ramesh,
- Alkuperäinen viesti -
Lähettäjä: "Ramesh Vadlapatla" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Lähetetty: Monday, December 29, 2003 10:48 PM
Aihe: Re: MySQL/InnoDB-5.0.0 is released
> Hello Heikki,
>
>
Gabriel,
- Original Message -
From: "Gabriel Ricard" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 27, 2003 6:46 PM
Subject: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is
released + sneak peek of 4.1.1)
> On Monday, O
On Monday, October 27, 2003, at 07:45 AM, Chris Nolan wrote:
2. I personally use ReiserFS for all of my stuff, most of which is
based upon InnoDB. One thing you have to remember is that InnoDB
treats the space inside the tablespace as a Berkeley Fast
Filesystem-style space, using the underlayin
ournaled file system extra overhead? If so, is
Raw significantly more efficient? How does this choice effect backup
soultion?
thanks, Jon
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 9:55 PM
Sub
Hancock" <[EMAIL PROTECTED]>
> > Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
> > Lähetetty: Monday, October 27, 2003 10:42 AM
> > Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
> >
> >
> > > Heikki,
> >
more efficient? How does this choice effect backup
soultion?
thanks, Jon
> - Original Message -
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, October 24, 2003 9:55 PM
> Subject: Re: MySQL/InnoDB-4.0.16 is rele
Hi Heikki,
> > As you know - I'm a transaction zealot :-)
> >
> > Is there a way to get a signal back to the client when a
> > transaction has started?
>
> what do you mean? If you have AUTOCOMMIT=0, then every SELECT, INSERT,
> UPDATE, DELETE starts a new active transaction.
Aha - that's good, I
Martijn,
- Original Message -
From: ""Martijn Tonies"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, October 24, 2003 4:08 PM
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
> Hi Heikki,
>
> As you know -
Hi Chris,
> I'm not the almighty Heikki, but I might be able to fill you in to some
> extent.
:-)
> Your first and third questions I cannot answer with certainty, but I'm
> pretty
> sure the answer is "no". Regarding the first one, I'm not too sure as to
> why you'd need
> it. Looking at the out
CTED]>; <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 11:23 AM
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
> Eduardo,
>
> - Alkuperäinen viesti -
> Lähettäjä: "Eduardo D Piovesam" <[EMAIL PROTECTED]>
> Vastaanottaja: "
Hi!
I'm not the almighty Heikki, but I might be able to fill you in to some
extent.
Your first and third questions I cannot answer with certainty, but I'm
pretty
sure the answer is "no". Regarding the first one, I'm not too sure as to
why you'd need
it. Looking at the output of SHOW VARIABLES
Eduardo,
- Alkuperäinen viesti -
Lähettäjä: "Eduardo D Piovesam" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Lähetetty: Friday, October 24, 2003 6:17 PM
Aihe: Re: MySQL/InnoDB-4.0.16 is released + sneak
00MB each or
- Just one table2.ibd with 600MB or 1GB?
Thanks again,
Eduardo
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 10:55 AM
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
Hi Heikki,
As you know - I'm a transaction zealot :-)
Is there a way to get a signal back to the client when a
transaction has started? Or perhaps something like
@@trancount in MSSQL?
Is there a way to turn ON/OFF auto-commit?
And, are metadata operations under transaction control?
With regar
com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM
tables
..
From: "Eduardo D Piovesam" ([EMAIL PROTECTED])
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek
, and foreign keys for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM
tables
From: Chris Nolan ([EMAIL PROTECTED])
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
View this article only
Newsgroups: mailing.database.myodbc
Date: 2003-
(Sorry for the last email, it's not complete).
Hello Heikki,
Sorry, but I didn't understand the concept of tablespace applied. It's
different from Oracle, right?
AFAIK, tablespace is utilized to logically group "tables" into one (or more)
files.
And to group "indexes" into another files...
But
Hello Heikki,
I didn't understand the concept of tablespaces utilized,
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 22, 2003 12:00 PM
Subject: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
>
Hello Heikki!!!
Multiple table spaces eh? Funky! Of course, as you've no doubt become
aware, I am one of these annoying
people that has many questions to ask the list the moment something like
this comes along! Please feel
free to ignore these questions though, as we're all hanging out for 4.1.1
the other
AND clauses, if doing so would allow a lot of records to be skipped
over during the index scan, rather than read in their entirety.
> From: "Wendell Dingus" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Subject: RE: MySQ
Thanks to everyone who has helped and/or made suggestions so far. I'll
try to provide some answers to your further queries and report back on
some testing I've done.
Jeremy asked for explains of some of the problem queries:
Here is a particularly troublesome one that gets ran quite a lot:
mysql> S
On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
> Hello, I've got a situation I'm hoping someone here can help me out with.
We
> have a web server serving up data via some PHP programs pulling from MySQL
> (3.23.56 currently) in INNODB tables. There are 40+ (active) databases
> t
On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
> Hello, I've got a situation I'm hoping someone here can help me out with. We
> have a web server serving up data via some PHP programs pulling from MySQL
> (3.23.56 currently) in INNODB tables. There are 40+ (active) databases
> tota
Sent: Saturday, June 28, 2003 2:45 PM
To: Wendell Dingus
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL/INNODB speed on large databases
Maybe my question is too obvious but, since you have several databases
instead of only one, have you considered moving some of them to a
separate server ?
Also, have you che
riginal Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 2:45 PM
To: Wendell Dingus
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL/INNODB speed on large databases
Maybe my question is too obvious but, since you have several databases
instead of only one, have you
Maybe my question is too obvious but, since you have several databases
instead of only one, have you considered moving some of them to a
separate server ?
Also, have you checked MySQL replication capabilities ?
It is a very efficient way to distribute the load across several
servers unless you do a
Hi!
The following essential change was forgotten from the changelog of 3.23.57
below, though it is listed in the MySQL-3.23.57 changelog:
* Changed the default value of innodb_flush_log_at_trx_commit from 0 to 1.
If you have not specified it explicitly in your my.cnf, and your application
runs mu
On Monday 02 June 2003 04:32 am, Kieran Kelleher wrote:
> What platform and hardware spec are you using?
Linux (2.4.19 with the rmap vm) on Intel x86 (32 bit) with 3GB of memory.
Mysql won't start if I set the InnoDB buffer above 2048MB.
>
> -Original Message-
> From: Per Andreas Buer
What platform and hardware spec are you using?
-Original Message-
From: Per Andreas Buer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 1:48 PM
To: [EMAIL PROTECTED]
Subject: mysql/innodb and the 2GB limit
Hi.
Lately, I've been banging against the glibc 2GB malloc limit - what a
Rainer,
- Original Message -
From: "Rainer Collet" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, May 31, 2003 5:49 PM
Subject: Re: MySQL/InnoDB-4.0.13 is released
> [EMAIL PROTECTED] ("Heikki Tuuri") wrote in message
news:
Paul,
which MySQL version you are using?
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
"
Corresponding ON UPDATE options are available starting from 4.0.8.
"
If you are using >= 4.0.8, can you create a small repeatable test case?
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technic
Rogger,
- Original Message -
From: "Rogger Vasquez" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 4:43 PM
Subject: Re: MySQL/InnoDB-3.23.55 is released
&
Hello.
On Sun 2002-12-29 at 21:40:22 +0300, [EMAIL PROTECTED] wrote:
> > tell me please where i need write my question about InnoDB in MySQL ?
This mailing list is fine for questions about InnoDB. But your
question is not a MySQL problem, but a misunderstanding about PHP and
Web pages in general
Andrew,
> > If i use code at PHP IN ONE PAGE - that uses like :
> > SET COMMIT
[snip]
> > All Actions - work OK - COMMIT & ROLLBACK
> > But if i try use every Insert at defferent page (php)
[snip]
> > p1.php - has
> > SET COMMIT;
> > INSERT 1
> >
> > {go to p2.php}
> > INSERT 1
> > ROLLBA
Hi!
Buildmaster Lenz Grimmer of MySQL AB informed me that the last changeset in
4.0.7 was from Dec 20th, 2002.
That means that InnoDB-4.0.7 is essentially the same as InnoDB-4.0.6, and
the changes listed below will only appear in MySQL-4.0.8!
I apologize for the confusion. It was my error not to
At 19:54 19/12/2002 -0400, Adolfo Bello wrote:
Hi,
There is not link to download the Windows version.
http://www.mysql.com/Downloads/MySQL-Max-4.0/mysql-max-4.0.6-gamma-win.zip
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]>
/
There is not link to download the Windows version.
Any date for the Windows version to be published?
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Patricio,
- Original Message -
From: ""Patricio Díaz G."" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, December 13, 2002 4:20 AM
Subject: [MySQL] InnoDB Lock status
> I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and
Delphi
> in a WinXP box, mo
hi
i have had a look for a download of this release (ie 4.0.5) and the latest
release that i have been able to locate a download for is for 4.0.3. is
there a url that anyone can direct me to to download 4.0.5 (or even 4.0.4)
or are these commercial releases?
thanks.
- Original Message -
sql,query
At 15:50 -0600 10/25/02, Jeff Mathis wrote:
Paul DuBois wrote:
>(2) drop all indexes on your table(s). rebuild them after loading (this
>alone can give orders of magnitude improvement)
For ISAM or MyISAM, that works. It has no effect for InnoDB.
Do you actually observe a rep
In the last episode (Oct 25), Jeff Mathis said:
> I'll agree to this somewhat:
>
> (1) always bind your variables. whatever code you are using to do your
> inserts, the fewer prepared statements you can make the better.
>
> for example:
> insert into TableName (col1, col2, col2, col4) values (?,?
David Lloyd wrote:
Mark,
Note that mysql does not support bind variables. If you think
you're>using them, whatever API you are using is filling them in
before>sending the statement to mysql. Bind variables do solve
quoting>problems, though, so if you use them, know why you're using
them :)>
At 15:46 -0600 10/25/02, Jeff Mathis wrote:
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is signifi
Mark,
> >>Note that mysql does not support bind variables. If you think
> >you're>using them, whatever API you are using is filling them in
> >before>sending the statement to mysql. Bind variables do solve
> >quoting>problems, though, so if you use them, know why you're using
> >them :)>
Rumou
Jeff Mathis wrote:
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than creati
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than creating a new
prepared st
Jeroen Geusebroek wrote:
[snip]
You where right, what i did use indivudual inserts. Now I have it
segmented in 1000 rows in one query which massively speeds up the whole
inserting progress. 160K records now takes about 20 seconds instead of
the 100 records ;) I'm really impressed by this massive s
I'll agree to this somewhat:
(1) always bind your variables. whatever code you are using to do your
inserts, the fewer prepared statements you can make the better.
for example:
insert into TableName (col1, col2, col2, col4) values (?,?,?,?)
then, once you have a prepared statment, do a loop and
Hi,
>What method are you using for inserting the data?
>Individual INSERTs can be very slow:
> INSERT INTO foo (x, y, z) VALUES (1, 2, 3);
> INSERT INTO foo (x, y, z) VALUES (4, 5, 6);
> ...
>Batch INSERTs can be massively faster:
> INSERT INTO foo (x, y, z) VALUES (1, 2,
Jeroen,
Two things are likely to make this umpteen times faster.
a) Commit the insert transaction every.. say 1000 records?
b) use mysql's extended insert statement,
insert into mytable values
(row1_field1,row1_field2),(row2_field1,row2_field2),(?,?),(?,?) etc etc
Ric.
- Original M
PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 7:48 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
> Hi Heikki and all friends,
> You quite right.If OS_THREAD_MAX_N is 100 or 1000 all it's ok and
svr_init()
> works well.
thank you!
Next week Lenz wil
; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 5:07 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
> Gelu,
>
> - Original Message -
> From: "Gelu Gogancea" <[EMAIL PROTECTED]>
> To: "Puiu Hrenciuc" &
rom: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Puiu Hrenciuc" <[EMAIL PROTECTED]>;
"Philip Molter" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 2:40 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
> Hi,
> You have right, in the new version (4.0.4) on Windows 9x are the same
> symptom.
> I research a little in this morning and i found where is the pr
ot;Philip Molter"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 12:46 AM
Subject: Re: MySQL/InnoDB-4.0.4 is released
> I hoped that you will solve the MySQL consuming all computer's
> res
Puiu,
- Original Message -
From: "Puiu Hrenciuc" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Philip Molter"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thu
At least I saw you fixed WinMySQLAdmin.
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Philip Molter" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October
Philip,
- Original Message -
From: "Philip Molter" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 4:16 PM
Subject: Re: MySQL
On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote:
: Hi!
:
: InnoDB is a table type which provides transactions, row level locking,
: foreign key constraints, and a non-free hot backup tool to MySQL.
:
: InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and
: My
Peter,
- Original Message -
From: ""Peter"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 02, 2002 2:44 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
> Hi,
>
> I have been wondering if there is a schedule when
Hi,
I have been wondering if there is a schedule when MySQL 4.x is not
considered "beta/developement" anymore - www.mysql.com recommend MySQL 4.x
for testing only, and has done for some time now.
Thanks and best regards
Peter
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTE
At 1:58 + 9/25/02, Jessica Thomale wrote:
>On Wednesday, Sep 25, 2002, at 01:00 Etc/GMT, Paul DuBois wrote:
>
>>At 0:39 + 9/25/02, Jessica Thomale wrote:
>>>Hi,
>>>
>>>Is it possible to use InnoDB tables that have transaction support
>>>without using InnoDB for server logs?
>>
>>The InnoDB
On Wednesday, Sep 25, 2002, at 01:00 Etc/GMT, Paul DuBois wrote:
> At 0:39 + 9/25/02, Jessica Thomale wrote:
>> Hi,
>>
>> Is it possible to use InnoDB tables that have transaction support
>> without using InnoDB for server logs?
>
> The InnoDB handler maintains its own logs, and it uses thes
At 0:39 + 9/25/02, Jessica Thomale wrote:
>Hi,
>
>Is it possible to use InnoDB tables that have transaction support
>without using InnoDB for server logs?
The InnoDB handler maintains its own logs, and it uses these for
transaction support and crash recovery. You can't turn them off.
Howeve
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
Hi,
AFAIK, all versions are affected since I reproduced the bug with 4.0.4-beta
under linux.
Regards,
Jocelyn
- Original Message -
From: "PR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 12, 2002 1:53 AM
Subject: Re: MySql/InnoDB crashes
Heikki, does this bug affect all versions or just the -max windows
versions... we just installed 4.0.3-beta (unix-freebsd) to do some
benchmarking/testing tonite on innodb and this would impact us. Thx.
>Rafa,
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>Newsgroups: mailing.datab
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 I
Dan,
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Harald Fuchs" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 6:10 PM
Subject: Re: MySQL/InnoDB-4.0.3 is released
>
In the last episode (Aug 28), Harald Fuchs said:
> I think there's something missing in the changelog. About a month
> ago, someone named Christian Jaeger from ETH Zurich asked about
> unbuffered raw device support for Linux. You replied immediately
> with two sets of patches for 3.23.x (regarin
1 - 100 of 129 matches
Mail list logo
