Hi,
i've been already reading the documentation the whole day, but still confused
and unsure what to do.
We have two databases which are important for our work. So both are stored
hourly. Now I recognized that each database has a mixture of MyISAM- and
InnoDB-tables. A backup of this mix does
for saving
MyISAM-tables. For InnoDB-tables --single-transaction is useful. But both are
mutually exclusive
(http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_single-transaction
). The dump of both take about 10 seconds. If the db is locked for that
period I can live
XTrabackup can handle both InnoDB and MyISAM in
a consistent way while minimizing lock time on
MyISAM tables ...
http://www.percona.com/doc/percona-xtrabackup/2.1/
--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
SkySQL - The MariaDB Company | http://www.skysql.com/
--
MySQL General
Am 21.09.2012 18:18, schrieb Rick James:
(Apologies to the rare bottom-poster.)
bullshit
on mostly egvery mailing-list there are guidlines that you NOT
should top-post, try it out on the postfix-list as example
and wait what Wietse wille xplain you about both
* your top-posting
* and your
Hi Guys,
I have requirement to change my production database tables which are using
myISAM and now bcoz of some changes we have to move to Innodb.
Can anyone suggest how the plan should be and risks involve?
Thanks,
Girish Talluru
Am 21.09.2012 15:26, schrieb Girish Talluru:
I have requirement to change my production database tables which are using
myISAM and now bcoz of some changes we have to move to Innodb.
Can anyone suggest how the plan should be and risks involve?
no because this depends hardly on your data
On 21/09/2012 9:26 AM, Girish Talluru wrote:
Hi Guys,
I have requirement to change my production database tables which are using
myISAM and now bcoz of some changes we have to move to Innodb.
Can anyone suggest how the plan should be and risks involve?
Thanks,
Girish Talluru
Whats the size
Hi Reindl,
I'm sorry if I ask wrong question here?
I'm new to this and people before me did the terrible mistake of using
myISAM even though they decided to move to Innodb many times. Data grows
like hell and now requirements came in where we have to use transactions.
At this stage we have to
do NOT top-post which makes threads unreadable
Am 21.09.2012 15:55, schrieb Girish Talluru:
On Fri, Sep 21, 2012 at 6:44 AM, Reindl Harald h.rei...@thelounge.net
mailto:h.rei...@thelounge.net wrote:
Am 21.09.2012 15:26, schrieb Girish Talluru:
I have requirement to change my
(Apologies to the rare bottom-poster.)
This contains lots of tips on converting from MyISAM to InnoDB:
http://mysql.rjweb.org/doc.php/myisam2innodb
Generally, the conversion should go smoothly.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Friday
Olá pessoal.
Tenho um banco com tabelas originalmente myisam e algumas outras eu
converti para innodb. Estou tentando converter outras tabelas maiores
porém gostaria de fazer um teste primeiro, estava pensando em fazer
uma cópia fiel da base, ctrl+c/v da base em outra máquina para fazer o
teste.
Hi,
if you want to copy from one server to another can't you just use
mysqldump? This is then restored via the mysql command using a pipe
or STDIN redirection. If you can shutdown the database for the
duration of the copy then you can do cold backup of all data files.
Both options will
lol sorry for send the email in portuguese, I did not realize that the
list were in english (a little mistake, I have many mailing lists).
I can use mysqldump but its take many hours to complete a restore. I
can stop the server, so i'm think in a physical copy of the database.
But I have not
Quoting Yoshio geanyos...@gmail.com:
I can use mysqldump but its take many hours to complete a restore. I
can stop the server, so i'm think in a physical copy of the database.
But I have not found the innodb files. Where are that files?
InnoDB is a bit tricky, without going into details (I
I found the ibdata and logfiles, but outside from my database dir.
so basically I need copy everything in /var/lib/mysql/* ?
2011/5/27 a.sm...@ukgrid.net:
Quoting Yoshio geanyos...@gmail.com:
I can use mysqldump but its take many hours to complete a restore. I
can stop the server, so i'm
Quoting Yoshio geanyos...@gmail.com:
I found the ibdata and logfiles, but outside from my database dir.
so basically I need copy everything in /var/lib/mysql/* ?
Yeah that's normal, they will be in the top level of your MySQL
datadir. Yep, copy everything. As I said, if you have any
as they happen.
From: Hank [mailto:hes...@gmail.com]
Primarily due to many positive posts I've seen about MySQL 5.5 and
advances in InnoDB, I'm seriously considering converting all my MyISAM
databases to InnoDB. I don't need many of the InnoDB features, but if
I'm going to upgrade from 4.1.14 to 5.5, I
information
like myisamchk output. That would be an awesome feature to add to 5.5.
Expect to see anywhere from a 1.5x to a 3x increase in size when converting
from myisam to innodb, depending on your field types and indexes. It's the
penalty you pay for supporting transactions and concurrent read
Primarily due to many positive posts I've seen about MySQL 5.5 and
advances in InnoDB, I'm seriously considering converting all my MyISAM
databases to InnoDB. I don't need many of the InnoDB features, but
if I'm going to upgrade from 4.1.14 to 5.5, I might as well bit the
bullet since that seems
]
Sent: Tuesday, September 28, 2010 3:29 PM
To: mysql@lists.mysql.com
Subject: Migrating my mindset from MyISAM to InnoDB
Primarily due to many positive posts I've seen about MySQL 5.5 and
advances in InnoDB, I'm seriously considering converting all my MyISAM
databases to InnoDB. I don't need many
Also note, 5.5 isn't production ready. 5.1 is the current GA release.
-Original Message-
From: Hank [mailto:hes...@gmail.com]
Sent: Tuesday, September 28, 2010 3:29 PM
To: mysql@lists.mysql.com
Subject: Migrating my mindset from MyISAM to InnoDB
Primarily due to many positive posts
Hi,
What is the basic functionality of the MyISAM, InnoDB etc ?
Vikram A
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
What is the basic functionality of the MyISAM, InnoDB etc ?
http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase
Hello again!
I am trying to convert my tables to InnoDB, and i am getting an error...
Error: 1075
Incorrect table definition; there can be only one auto column and it must be
defined as a key
Now, I converted a table in my sandbox earlier this morning to do some
testing, and it worked fine...
If you have a column defined as auto_increment, there must be a key on it.
This is true both in myisam and innodb.
If you need further help, please show us the full structure of the real table
you're operating on (not the one from your sandbox), the statement you run, and
the error message
;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM vs InnoDB - Index choice and Huge performance difference
just want to take a note on 4Gbytes
What
a query I often run on the big table that is performing really
poorly on InnoDB (18mins Innodb vs 29secs MyISAM)
This is my query
SELECT
DATE_FORMAT(calldate, '%d') AS day,
count(*) AS num,
disposition
FROM cdr
WHERE calldate BETWEEN '2007-07-01 00:00:00' AND '2007-07-30 23
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM vs InnoDB - Index choice and Huge performance difference
just want to take a note on 4Gbytes
What kernel u use?
4Gbytes or bigger means nothing
-30 23:59:59'
)
GROUP BY day, disposition;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM vs InnoDB - Index choice and Huge performance difference
just want
is a sort of
a log of our subscriber's phone calls.
I have a query I often run on the big table that is performing really
poorly on InnoDB (18mins Innodb vs 29secs MyISAM)
This is my query
SELECT
DATE_FORMAT(calldate, '%d') AS day,
count(*) AS num,
disposition
FROM cdr
WHERE
7.000.000 rows, this big table is a sort of
a log of our subscriber's phone calls.
I have a query I often run on the big table that is performing really
poorly on InnoDB (18mins Innodb vs 29secs MyISAM)
This is my query
SELECT
DATE_FORMAT(calldate, '%d') AS day,
count(*) AS num
U might want to try seting you index to calldate, disposition
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 25, 2007 10:03 PM
To: Edoardo Serra
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM vs InnoDB - Index choice and Huge performance
Hi! Comments inline.
Edoardo Serra wrote:
SELECT sum(usercost) FROM cdr WHERE calldate BETWEEN '2007-06-01
00:00:00' AND '2007-06-30 23:59:59'
If I run it on the MyISAM table, MySQL choose the right index (the one
on the calldate column) and the query is fast enough
If I run it on the
with an index on it (it's a non unique index)
I have the same table in InnoDB and MyISAM storage engines.
I have this simple query:
SELECT sum(usercost) FROM cdr WHERE calldate BETWEEN '2007-06-01
00:00:00' AND '2007-06-30 23:59:59'
If I run it on the MyISAM table, MySQL choose the right index
Hello,
we have a MySQL DBMS with a lot of databases. Most of them are using MyISAM
tables but three databases use InnoDB and MyISAM tables.
What is the best method to get a consitent ONLINE backup of both table types?
Thanks,
Spiker
--
Pt! Schon vom neuen GMX MultiMessenger gehört?
Der
Check out this thread:
http://www.sitepoint.com/forums/showpost.php?p=3357628postcount=2
2007/7/17, [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hello,
we have a MySQL DBMS with a lot of databases. Most of them are using
MyISAM tables but three databases use InnoDB and MyISAM tables.
What
.
- Original Message -
From: tim h [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, May 22, 2007 2:56 PM
Subject: corruption in db. myisam bad? innodb good?
hi. database is myisam, 5.8Gb, 7mil records.
recently had some corruption i think due to mysqld service failure.
10
hi. database is myisam, 5.8Gb, 7mil records.
recently had some corruption i think due to mysqld service failure.
10 tabes were crashed.
question --
how can i prevent or minimize this?
Will switching to innodb help?
Will converting all my queries to transactions help?
thanks.
--
Tim H
On Jan 7, 2007, at 4:23 PM, TK wrote:
In short, the original inventors of the GIF format (CompuServe,
1987) have always defined the pronunciation to be like JIF. So,
that has always been the correct pronunciation.
Sure, so I'll start pronouncing graphics as jraphics.
--
MySQL General
Subject: Re: [OT} How to pronounce GIF (was: Re: How to
pronounce MyISAM and InnoDB)
On Jan 7, 2007, at 4:23 PM, TK wrote:
In short, the original inventors of the GIF format (CompuServe,
1987) have always defined the pronunciation to be like JIF. So,
that has always been the correct
Jan,
In English I pronounce them as...
My-eye-sam
In-oh-dee-bee
...respectively.
Regards,
Phil
2007/1/7, js [EMAIL PROTECTED]:
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
Thanks in advance.
When
I'll bite..
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
I pronounce MyISAM as give-me-foreign-keys and InnoDB as
curse-you-cryptic-foreign-key-errors
(currently running far and fast)
--
MySQL General Mailing List
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just say
My, I, Sam and inno, d, b
Michael
-Original Message-
From: js [EMAIL PROTECTED]
Date: Mon, 8 Jan 2007 00:09:15
To:mysql@lists.mysql.com
Subject: How to pronounce MyISAM and InnoDB
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing
To:mysql@lists.mysql.com
Subject: How to pronounce MyISAM and InnoDB
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
2007/1/7, js [EMAIL PROTECTED]:
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
Thanks in advance.
When I'm speaking Dutch (which is most of the time) I say
My-ee-sahm
Inno-day-bay
JP
--
MySQL General Mailing
MyISAM and InnoDB.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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 List
For list archives: http
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 the end od the CREATE TABLE like
):
mysql 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
MyISAM
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]
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 tablename;
It will tell you what the able
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 List
For list
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
-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
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 documentation
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 think
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 mean 2PC are
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 Borries
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 (needs
a proprietary backup tool);
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, which is still β.
Ok, so your solution is to use
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
notices;
and SolidDB, which is still β.
Is there a better open source database out there for that amount of
data?
Several. MySQLâ?Ts own MaxDB, PostgreSQL, Firebird if you are
into
Borland stuff, Ingres if you need XA distributed transactions.
Firebird isn't Borland :-)
I usually recommend PostgreSQL, or Ingres if
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 already a
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, or Ingres if
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
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)
Administrador
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 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 deprecated
At 07:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
snip .. 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)
Miles Thompson [EMAIL PROTECTED] wrote:
At 07:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
snip .. 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, since
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
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
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
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 deprecated until further notices; and SolidDB,
which
is still Î
-
From: Mikhail Berman [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, November 1, 2006 10:31:13 AM GMT-0500 US/Eastern
Subject: MyISAM to InnoDB conversion help
Hi everyone,
I am hoping to get help with extremely slow performance of MyISAM to
InnoDB conversion. Or find out
[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 table-name ENGINE = InnoDB;
That's all.
Let MySQL worry about conversion.
You may
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
-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 variables
related
Edwards [EMAIL PROTECTED]
To: Mikhail Berman [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, November 1, 2006 11:24:00 AM GMT-0500 US/Eastern
Subject: Re: MyISAM to InnoDB conversion help
Check these variable
bulk_insert_buffer_size (Default usually 8M)
innodb_buffer_pool_size (Default
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
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
proprietary
backup tool); BDB, which is deprecated until
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
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
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
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
/storage-engines.html
Thanks,
Jimmy Guerrero
MySQL, Inc
-Original Message-
From: Francis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 31, 2006 2:25 PM
To: mysql@lists.mysql.com
Subject: MyISAM vs InnoDB
Hi list,
Question about MyISAM vs InnoDB ? What is the best
most of my Storage enines is MyISAM i wanna change them all to|InnoDB
how do i do this ?thanks
|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
most of my Storage enines is MyISAM i wanna change them all to|InnoDB
how do i do this ?
ALTER TABLE tblname ENGINE=innodb;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Brian, you can also set a default storage engine in your mysql config
file (my.cnf) to ensure future tables get created with the desired
storage engine (unless otherwise specified in your create statement).
From http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
If you omit the
11:51 PM
Subject: Re: Row count discrepancy when converting from MyISAM to InnoDB
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of this many rows
: Tuesday, July 25, 2006 11:51 PM
Subject: Re: Row count discrepancy when converting from MyISAM to InnoDB
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss
the conversion to InnoDB using the following ways
1. by dumping all the data in a text file and loading it.
2. by using ALTER TABLE
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of this many rows?
I
On Jul 25, 2006, at 11:55 AM, Frank wrote:
Why is the record count so low after conversion to InnoDB?
Who should I believe: InnoDB or MyISAM?
Any ideas as to what can be done to avoid loss of this many rows?
InnoDB doesn't keep a count on number of rows, like MyISAM does.
InnoDB only
Thank you to everyone who replied. It turned out I had index corruption and
after running an OPTIMIZE TABLE I was able to convert all the records to
InnoDB.
Thanks,
Frank
/order.php
- Original Message -
From: Patrick Herber [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, January 15, 2006 4:16 PM
Subject: RE: ERROR 1114 (HY000): The table is full converting a big table
from MyISAM to InnoDB on 5.0.18
Thanks a lot for your answer
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since I have some performance troubles with table-locking in a multi-user
environment (when one of them performs a complex query all the other have to
wait up to 1 minute, which is not very nice...), I would like to
Hi,
I think you should change the tmpdir variable value to a directory which
have enough room to create your temp big table (by default, it points
to /tmp dir).
Regards,
Jocelyn
Patrick Herber a écrit :
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
1 - 100 of 284 matches
Mail list logo