log mentioned, a fix from
InnoDB has been integrated into 5.30.
5.0.30 I meant.
Tweakers.net has already tested
this fix and it does show some improvement, but it still has a long
way to go: http://tweakers.net/reviews/661/6
Yes Innodb has a long ways to go and I'm wondering if it is
At 12:49 PM 1/1/2007, Jochem van Dieten wrote:
On 1/1/07, mos wrote:
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
Hi Heikki,
Yes indeed. We have a "uid" field that is AUTO INC. Is the error more
an issue of the auto inc code in InnoDB not setting its error codes
correctly on a rollback than the auto increment code initiating an
error? Thank you in advance.
Best Regards,
Jason
On 12/31/06, He
On 1/1/07, mos wrote:
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postg
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/
a deadlock was associated with this event.
ha_innodb.cc in 5.0:
int
convert_error_code_to_mysql(
/**/
/* out: MySQL error code */
int error, /* in: InnoDB error code */
THD*thd)/* in: user thread handle or NULL
Hello,
I noticed the error messages below in my MySQL error log and found
them a bit perplexing. Can't find anything on them in the MySQL
documentation. If anyone has any clue what they mean it is greatly
appreciated. As a sidenote, SHOW INNODB STATUS completes, but only
shows throug
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
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. Whe
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
Which version of mysql is this?
In 5.1.12 when I run your test the section transaction blocks waiting
for the lock (as it should). My show innodb status output is:
TRANSACTIONS
Trx id counter 0 1300
Purge done for trx's n:o < 0 1288 undo n:o < 0 0
History li
lift it high enough so that the complaints about a too small lsn end.
The risk in having inconsistent lsn's stamped into data pages is that if
there is a database crash, then the log will not be applied to those pages.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions
Hi, all,
We have an innodb table named test. It has some rows as follow:
mysql> show create table test;
+---+-+
| Table | Create Ta
h K J
- Original Message -
From: "Jan Kirchhoff" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, December 11, 2006 1:25 PM
Subject: Re: Innodb log sequence error - urgent
> Ratheesh K J schrieb:
>> Hello all,
&
server it is (innodb_log_file_size = 5M).
Today morning when I checked the error log, there seems to be a lot of error
msg flowing in.
061211 11:41:47 InnoDB: Error: page 203046 log sequence number 87 3002891543
InnoDB: is in the future! Current system log sequence number 86 4025048037.
InnoDB
(innodb_log_file_size = 5M).
Today morning when I checked the error log, there seems to be a lot of error
msg flowing in.
061211 11:41:47 InnoDB: Error: page 203046 log sequence number 87 3002891543
InnoDB: is in the future! Current system log sequence number 86 4025048037.
InnoDB: Your database may be
Hi,
I sent a mail to this list almost a year ago asking if our current way of
keeping some of our tables memory could be improved by using the cluster-engine
since we were getting problems with too long locks.
A few people suggested I should use innodb and said it should be able to handle
the
At 11:34 AM +1100 12/4/06, Daniel Kasak wrote:
Paul DuBois wrote:
At 10:57 AM +1100 12/4/06, Daniel Kasak wrote:
Carlos Proal wrote:
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more.
I was under the impression that you should avoid files > 2GB on 32
bit syst
Paul DuBois wrote:
At 10:57 AM +1100 12/4/06, Daniel Kasak wrote:
Carlos Proal wrote:
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more.
I was under the impression that you should avoid files > 2GB on 32
bit systems, which have to do some dodgy stuff to supp
At 10:57 AM +1100 12/4/06, Daniel Kasak wrote:
Carlos Proal wrote:
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more.
I was under the impression that you should avoid files > 2GB on 32
bit systems, which have to do some dodgy stuff to support files
bigger t
Carlos Proal wrote:
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more.
I was under the impression that you should avoid files > 2GB on 32 bit
systems, which have to do some dodgy stuff to support files bigger than
2GB. Does this advice apply?
If you w
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more. If you want several data files (mainly because performance)
you need to add them in the my.cnf following the instructions in:
14.2.7. Adding and Removing InnoDB Data and Log Files
http://dev.mysql.com/doc/refman/5.0/en
Hi all.
I'm about to import a LOT of data ( 20 GB ) into some InnoDB tables. At
the moment, I have:
innodb_data_file_path = ibdata1:10M:autoextend
in my /etc/mysql/my.cnf
The ibdata1 file is 499MB at the moment. What happens when this goes
past 2GB? Do I automatically get allocated an
Mike Kruckenberg wrote:
mysql> SET @staff_id = LAST_INSERT_ID();
Query OK, 0 rows affected (0.01 sec)
I don't know if this behaviour has changed in later versions of mysql,
but using session variables, although lovely, was the quickest way to
break replication (at least up to and including 4.
Thanks for all your help Mike.
Problem solved. I divided to process in two parts: one write the
insert/update/delete and then write the changes in the audit trail. All this
inside one transaction. If the first part fails, ROLLBACK. If the second
part fails, ROLLBACK, otherwise, if both were done o
Andre Matos wrote:
Thanks Mike.
I understand the possible "gaps" that I might have if I use the ROLLBACK.
This is acceptable in my case.
What I really want to avoid is what I am doing now: open one transaction to
insert, or update, or delete certain information and close with the commit.
Then,
Thanks Mike.
I understand the possible "gaps" that I might have if I use the ROLLBACK.
This is acceptable in my case.
What I really want to avoid is what I am doing now: open one transaction to
insert, or update, or delete certain information and close with the commit.
Then, I get the LAST_INSER
Andre Matos wrote:
SET AUTOCOMMIT=0;
START TRANSACTION;
INSERT INTO staff (`Name`) VALUES ('ABC');
INSERT INTO changes (`Key`, `Table`, `Value`) VALUES (LAST_INSERT_ID(),
'staff', 'ABC');
COMMIT;
SET AUTOCOMMIT=1;
This works fine in my test environment, however what about many users doing
at the
Andre Matos wrote:
The idea is to have a audit trail to record the changes made. So, I want to
insert a new record in the "staff" table and right after this, insert a
record in the "changes" table.
SET AUTOCOMMIT=0;
START TRANSACTION;
INSERT INTO staff (`Name`) VALUES ('ABC');
INSERT INTO change
;,
`Value` text collate latin1_general_cs NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs
AUTO_INCREMENT=1;
CREATE TABLE `staff` (
`ID` int(3) unsigned NOT NULL auto_increment,
`Name` varchar(35) collate latin1_general_cs NOT NULL default
PM
Subject: How Do I Know If mySQL is using MyISAM or InnoDB?
Is there a command at the command line that can tell me if I am using
MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
MySQL General Mailing
.
Thanks
ViSolve DB Team.
- Original Message -
From: "sofox" <[EMAIL PROTECTED]>
To:
Sent: Friday, November 17, 2006 5:32 PM
Subject: Moving large Innodb table to another mysql
> Dear All,
>
> I am using mysql-4.0.26, and I have a very large innodb table(>10G)
I've got a FreeBSD system (named 'db1') running mysql 4.1.14 with
innodb. I am running a dump onto another system in preparation for
setting up a third system as a slave. (I can't use the "flush tables
with read lock" because the db1 has a single tablespace file a
sofox wrote:
Message: Multi-statement transaction required more than
'max_binlog_cache_size'
bytes of storage; increase this mysqld variable and try again
Why don't you try doing what it suggests?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Kruckenberg <[EMAIL PROTECTED]>
To: John Kopanas <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, November 17, 2006 12:32:19 PM GMT-0500 US/Eastern
Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB?
For any specific table if you do:
show create table ;
It will te
nas wrote:
Is there a command at the command line that can tell me if I am using
MyISAM
or InnoDB? Thanks :-).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> show variables like 'table_type';
+---++
| Variable_name | Value |
+---++
| table_type| MYISAM |
+---++
1 row in set (0.00 sec)
John Kopanas wrote:
Is there a command at the command line that can tell me if I am using
MyIS
stern
Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB?
This is will tell you your default storage engine type
should you create a table without specifying an engine:
show variables like 'storage engine';
If you want to create a table with a specific engine,
specify it at
INE=MyISAM;
CREATE TABLE ( ... ) ENGINE=InnoDB;
To show what engines are available on your MySQL server, do this:
show engines;
- Original Message -
From: John Kopanas <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Friday, November 17, 2006 12:13:33 PM GMT-0500 US/Eastern
Subject:
Is there a command at the command line that can tell me if I am using MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
Sorry - what's your question?
#1 will work, or you can increase the value for the variable named in
the error message in scenario #2.
Dan
On 11/17/06, sofox <[EMAIL PROTECTED]> wrote:
Dear All,
I am using mysql-4.0.26, and I have a very large innodb table(>10G) .
When I tr
Dear All,
I have a very large table(>10G) in innodb, and I want move it to another
mysql server.
Of cause, mysqldump --quick mydb mytable > mytable.sql && mysql -h newhost
newdb < mytable.sql can do this for me, except:
1) if I use --no-autocommit while dumping, I will get err
Dear All,
I am using mysql-4.0.26, and I have a very large innodb table(>10G) .
When I try to moved the table from one mysqld to another one by mysqldump to a
script and import the script on target server, I have problem:
1) if I don't use --no-autocommit option when mysqldump, it w
I would have preferred if AUTO_INCREMENT threw an error on
InnoDB tables, this way we would have known this months ago instead of now
that we're well into this porting of tables, schema and now code.
This is such a subtle but significant change to the table-type that it
should have been
ach time.
You'd have to look in the docs to find what command does this, its
something for setting the next auto increment id. Hope this helps.
-Ryan
Daevid Vincent wrote:
http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html
We have recently switched several database ta
omething for setting
the next auto increment id. Hope this helps.
-Ryan
Daevid Vincent wrote:
http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html
We have recently switched several database tables from MYISM to INNODB, only
to find out this colossal design flaw in InnoDB tab
http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html
We have recently switched several database tables from MYISM to INNODB, only
to find out this colossal design flaw in InnoDB tables.
We ship out mySQL on our appliances in enterprise level scenarios. We often
like to start
that MySQL AB is overhauling the
fulltext system so that it would better support fulltext implementations
inside different engines.
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 I
-
From: "Visolve DB Team" <[EMAIL PROTECTED]>
To: "FalconSoft, Inc" <[EMAIL PROTECTED]>;
Sent: Wednesday, November 08, 2006 11:25 PM
Subject: Re: InnoDB + FULLTEXT
Hi,
Till MySQL 5.0 there was no support for FULLTEXT by InnoDB. More info on:
www.innodb.c
Hi,
Till MySQL 5.0 there was no support for FULLTEXT by InnoDB. More info on:
www.innodb.com/innodbtalkUC2005.pdf
Thanks
ViSolve DB Team.
- Original Message -
From: "FalconSoft, Inc" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 09, 2006 6:28 AM
Subject: I
Does anyone know if/when InnoDB will support FULLTEXT indexes? I have a
project that I'm working on now that really needs support for both.
Thanks!
Tim Gustafson
FalconSoft, Inc
[EMAIL PROTECTED]
http://falconsoft.com/
(831) 425-4522
(831) 621-6299 (Fax)
--
MySQL General Mailing Lis
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 7 Nov 2006, at 12:35, Jochem van Dieten wrote:
On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
PostgreSQL supports 2 phase commit. IIRC except for transaction
interleavi
On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
PostgreSQL supports 2 phase commit. IIRC except for transaction
interleaving, join and suspend/resume it supports XA. I think that puts it
about on par with Ingres and Firebi
> > On two-phase commits? I guess it's the IB 6 docs where you have to read
> > that, or get a copy of Helen Borries Firebird book. Get a copy of the
> > IBPhoenix CD that includes docs.
> >
> > The Firebird project itself has no full documentation yet - it's being
> > worked on.
>
> Hm, do you me
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
> PostgreSQL supports 2 phase commit. IIRC except for transaction
> interleaving, join and suspend/resume it supports XA. I think that puts it
> about on par with Ingres and Firebird.
I would have to analyze better, but I thi
Em Fri, 03 Nov 2006 09:18:21 +0100, Martijn Tonies escreveu:
> On two-phase commits? I guess it's the IB 6 docs where you have to read
> that, or get a copy of Helen Borries Firebird book. Get a copy of the
> IBPhoenix CD that includes docs.
>
> The Firebird project itself has no full documentati
> > InterBase had two-phase commits ages ago, Firebird inherited it.
> >
> > If there's anything specific you want to know, ask
>
> I *am* asking — where is the specific piece of documentation?
On two-phase commits? I guess it's the IB 6 docs where you have
to read that, or get a copy of Helen Bo
Em Thu, 02 Nov 2006 17:40:44 +0100, Martijn Tonies escreveu:
> InterBase had two-phase commits ages ago, Firebird inherited it.
>
> If there's anything specific you want to know, ask
I *am* asking — where is the specific piece of documentation?
Because if you don’t read MySQL’s
Em Thu, 02 Nov 2006 17:30:14 +0100, Martijn Tonies escreveu:
> Falcon has a transactional storage engine, including Foreign
> Keys (Jim wouldn't do a database without em)
Obviouſly.
> MGA
Ma ze?
--
Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel)
Administrado
On 11/2/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Wed, 01 Nov 2006 09:34:05 -0600, mos escreveu:
> Is there a better open source database out there for that amount of data?
Several. MySQL's own MaxDB, PostgreSQL, Firebird if you are into
Borland stuff, Ingres if you need XA
> >> Several. MySQL’s own MaxDB, PostgreSQL, Firebird if you are into
> >> Borland stuff, Ingres if you need XA distributed transactions.
> >
> > Firebird isn't Borland
>
> Granted. But it is (even more) attractive if you are already a Borland
> shop.
>
>
> >> I usually recommend PostgreSQL
Em Thu, 02 Nov 2006 15:32:06 +0100, Martijn Tonies escreveu:
>> Several. MySQL’s own MaxDB, PostgreSQL, Firebird if you are into
>> Borland stuff, Ingres if you need XA distributed transactions.
>
> Firebird isn't Borland
Granted. But it is (even more) attractive if you are alrea
t across drives, but you cannot tell Firebird to do it directly.
As for 1TB - I must admit I don't know, there's probably a maximum
number of rows, not data though.
> There is also the Falcon table engine that is coming out for
>MySQL, but MySQL AB claims it is *not* a replacem
At 08:32 AM 11/2/2006, you wrote:
> >> Always use a DBMS, and MySQL is no (proper) DBMS without a
> >> transactional backend. There are InnoDB, which is not completely free
(needs
> >> a proprietary backup tool); BDB, which is deprecated until further
notic
> >> Always use a DBMS, and MySQL is no (proper) DBMS without a
> >> transactional backend. There are InnoDB, which is not completely free
(needs
> >> a proprietary backup tool); BDB, which is deprecated until further
notices;
> >> and SolidDB, w
Em Wed, 01 Nov 2006 09:34:05 -0600, mos escreveu:
> At 05:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
>>
>> Always use a DBMS, and MySQL is no (proper) DBMS without a
>> transactional backend. There are InnoDB, which is not completely free (n
On 11/1/06, mos wrote:
At 02:27 PM 11/1/2006, Jochem van Dieten wrote:
What is the big deal of a TB? Now, if you get past 20 TB you might
want to team up with one of the commercial PostgreSQL supporters
(Fujitsu, EnterpriseDB, Greenplum etc.), but Sun even sells appliances
for 100 TB PostgreSQL
At 02:27 PM 11/1/2006, Jochem van Dieten wrote:
On 11/1/06, mos wrote:
Sure, I've thought of those too. But has anyone gotten Firebird to
store 700-800gb tables? Can you split Firebird's .gdb file across drives?
The main problem with tables of that size is maintaining the index. My
upp
On 11/1/06, mos wrote:
Sure, I've thought of those too. But has anyone gotten Firebird to
store 700-800gb tables? Can you split Firebird's .gdb file across drives?
The main problem with tables of that size is maintaining the index. My
upper limit for MySQL is 100 million rows. After tha
At 09:35 AM 11/1/2006, Martijn Tonies wrote:
>> > MyISAM vs InnoDB ? What is the best to use
>>
>> Always use a DBMS, and MySQL is no (proper) DBMS without a
>> transactional
>>backend. There are InnoDB, which is not completely free (needs a
propriet
Great,
Thank you for your help Rolando,
Mikhail Berman
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 01, 2006 11:41 AM
Cc: mysql@lists.mysql.com; Mikhail Berman
Subject: Re: MyISAM to InnoDB conversion help
I just noticed your
I just noticed your innodb_data_file_path
You have a shared InnoDB tablespace
That can be murder on a MySQL Server
You may want to separate each InnoDB into a separate file
Here are the steps needed to separate InnoDB tables.
1) Do a mysqldump on your database to mydata.sql.
2) Shutdown MySQL
3
11:13:44 AM GMT-0500 US/Eastern
Subject: RE: MyISAM to InnoDB conversion help
Hi Rolando,
Thank you for your help.
I am on MySQL 5, and I have tried to do the conversion using ALTER TABLE
command. With the same very slow result.
Do you by any chance have specific suggestions how to tweak varia
Francis wrote:
Question about MyISAM vs InnoDB ? What is the best to use, I have
a large table contain around 10 millons of records. What is the best
for me ? Use MyISAM or InnoDB ?
Depends VERY much on your application. If any concurrency and/or
durability is required then I would
Francis wrote:
Question about MyISAM vs InnoDB ? What is the best to use, I have
a large table contain around 10 millons of records. What is the best
for me ? Use MyISAM or InnoDB ?
Depends VERY much on your application. If any concurrency and/or
durability is required then I would
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 01, 2006 11:05 AM
To: Mikhail Berman
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB conversion help
If you are do this in MySQL 5, try this:
ALTER TABLE ENGINE = InnoDB;
That's all.
Let MySQL worry about conversion.
You may also
If you are do this in MySQL 5, try this:
ALTER TABLE ENGINE = InnoDB;
That's all.
Let MySQL worry about conversion.
You may also want to tweek the innodb
system variables (show variables like 'innodb%)
for better InnoDB performance prior to trying this.
- Original Message
>> > MyISAM vs InnoDB ? What is the best to use
>>
>> Always use a DBMS, and MySQL is no (proper) DBMS without a
>> transactional
>>backend. There are InnoDB, which is not completely free (needs a
proprietary
>>backup tool); BDB, which is deprec
At 05:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Tue, 31 Oct 2006 15:24:44 -0500, Francis escreveu:
> MyISAM vs InnoDB ? What is the best to use
Always use a DBMS, and MySQL is no (proper) DBMS without a
transactional
backend. There are InnoDB, which is
Hi everyone,
I am hoping to get help with extremely slow performance of MyISAM to
InnoDB conversion. Or find out if this type of performance is usual
I have MyISAM table that contains - 3,299,509 rows and I am trying to
convert it to InnoDB for the use with row-level locking, and I am
getting
On Nov 1, 2006, at 12:56 PM, Leandro Guimarães Faria Corcete DUTRA
wrote:
Em Tue, 31 Oct 2006 15:24:44 -0500, Francis escreveu:
MyISAM vs InnoDB ? What is the best to use
Always use a DBMS, and MySQL is no (proper) DBMS without a
transactional
backend. There are InnoDB, which is not
Miles Thompson <[EMAIL PROTECTED]> wrote:
> At 07:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
> > .. further notices; and SolidDB, which
> >is still β.
>
> Help this poor English-speaker - what's the symbol you use to describe
> SolidDB?
I assume it is a "beta" character, sin
At 07:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
.. further notices; and SolidDB, which
is still β.
Choose your evil.
--
Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel)
Administrador de (Bases de) Dados +55 (11) 2122 0302 (com)
http://b
Em Tue, 31 Oct 2006 15:24:44 -0500, Francis escreveu:
> MyISAM vs InnoDB ? What is the best to use
Always use a DBMS, and MySQL is no (proper) DBMS without a transactional
backend. There are InnoDB, which is not completely free (needs a proprietary
backup tool); BDB, which is depreca
Hello,
Although the number of records is a consideration to weigh in your decision,
there are many other (perhaps more important) factors to consider.
For example, do you need foreign keys? transactions? row-level locks?...then
InnoDB is your choice.
Perhaps with more details concerning the
Hi list,
Question about MyISAM vs InnoDB ? What is the best to use, I have a
large table contain around 10 millons of records. What is the best for me ?
Use MyISAM or InnoDB ?
Ty for reply ☺
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
hi,ive some two forum tables with abot 700Mb each one, and they was type
myisam. I was getting some lock problems and i decided to switch them to innodb,
but server load growed from 3 to 20. I followed your steps but i got not any
server load improvements.
should i back to myisam? or is
On Thu, Oct 19, 2006 at 11:03:11AM -0500, Mazur Worden, Kathy wrote:
> I had this problem just this morning and wound up fixing it by changing
> the innodb data and log file directories to new folders in the .cnf
> file. This enabled to server to start up (new data and log files were
I had this problem just this morning and wound up fixing it by changing
the innodb data and log file directories to new folders in the .cnf
file. This enabled to server to start up (new data and log files were
created) and I then restored the data from a dump.
Kathy Mazur Worden
On Wednesday 18 October 2006 23:36, Dan Buettner wrote:
> George-Cristian - is it possible that the *.frm files also got moved
> about??
Nope. What I'm thinking is the logs got moved, server restarted, it created
new ones and...
--
George-Cristian Bîrzan
Network Engineer
___
I haven't tried moving things about with the server running, but have
tried to clean up a hosed InnoDB installation after moving files about
during an upgrade (trial run on a test system thankfully).
You're probably right about the inode thing Jerry.
George-Cristian - is it possibl
TECTED]
> > Sent: Wednesday, October 18, 2006 2:16 PM
> > To: George-Cristian B�rzan
> > Cc: mysql@lists.mysql.com
> > Subject: Re: InnoDB messup
> >
> > Can you just put the files back where they were originally?
> > Ordinarily that would be in the path s
day, October 18, 2006 2:16 PM
> To: George-Cristian Bîrzan
> Cc: mysql@lists.mysql.com
> Subject: Re: InnoDB messup
>
> Can you just put the files back where they were originally?
> Ordinarily that would be in the path set up in mysql - see SHOW
> VARIABLES LIKE "datadir&quo
wrote:
Hello! I'm having some troubles fixing an InnoDB messup, maybe somebody will
be able to help me with at least knowing if it's a lost cause...
A colleague of mine moved the ib* files around, with MySQL (5.0.15) still
running, which didn't really do it justice... The problem might&
Hello! I'm having some troubles fixing an InnoDB messup, maybe somebody will
be able to help me with at least knowing if it's a lost cause...
A colleague of mine moved the ib* files around, with MySQL (5.0.15) still
running, which didn't really do it justice... The problem mig
Heikki
thanks for filing that report. You can close it again.
I had a look at the create-table statements for these 3 tables.
As it turns out, the person who initially created those tables had a
create statement like "create table ... comment='InnoDB free: 6144 kB'"
for s
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
> w
what does SHOW TABLE STATUS show for other tables?
It shows 2 values for about 3 of 260 tables. So most tables are okay. It
does not seem to depend on table size, as the other tables only have a
few hundred rows.
Are you using innodb_file_per_table?
Yes.
--
MySQL General Mailing List
For
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
Name: table
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 4354196
Avg_row_length: 210
Data_length: 917536768
Max_data_length: 0
Index_length: 2294349824
Data_free: 0
Auto_increment: 35040856
Create_time: 2006-10-12 10:29:36
Update_time: NULL
1001 - 1100 of 5315 matches
Mail list logo
